github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/cli/testdata/dump/row (about)

     1  sql
     2  CREATE DATABASE d;
     3  CREATE TABLE d.t (
     4  	i int,
     5  	f float,
     6  	s string,
     7  	b bytes,
     8  	d date,
     9  	t time,
    10  	ts timestamp,
    11  	n interval,
    12  	o bool,
    13  	e decimal,
    14  	u uuid,
    15  	ip inet,
    16  	j JSON,
    17  	ary string[],
    18  	tz timestamptz,
    19  	e1 decimal(2),
    20  	e2 decimal(2, 1),
    21  	s1 string(1),
    22  	s2 string collate en_u_ks_level2,
    23  	oi oid,
    24  	FAMILY "primary" (i, f, d, t, ts, n, o, u, ip, j, ary, tz, e1, e2, s1, s2, oi, rowid),
    25  	FAMILY fam_1_s (s),
    26  	FAMILY fam_2_b (b),
    27  	FAMILY fam_3_e (e)
    28  );
    29  INSERT INTO d.t VALUES (
    30  	1,
    31  	2.3,
    32  	'striiing',
    33  	'\x613162326333',
    34  	'2016-03-26',
    35  	'01:02:03.456',
    36  	'2016-01-25 10:10:10',
    37  	'2h30m30s',
    38  	true,
    39  	1.2345,
    40  	'e9716c74-2638-443d-90ed-ffde7bea7d1d',
    41  	'192.168.0.1',
    42  	'{"a":"b"}',
    43  	ARRAY['hello','world'],
    44  	'2016-01-25 10:10:10',
    45  	3.4,
    46  	4.5,
    47  	's',
    48  	'hello' COLLATE en_u_ks_level2,
    49  	6
    50  );
    51  INSERT INTO d.t VALUES (DEFAULT);
    52  INSERT INTO d.t (f, e) VALUES (
    53  	CAST('+Inf' AS FLOAT), CAST('+Inf' AS DECIMAL)
    54  ), (
    55  	CAST('-Inf' AS FLOAT), CAST('-Inf' AS DECIMAL)
    56  ), (
    57  	CAST('NaN' AS FLOAT), CAST('NaN' AS DECIMAL)
    58  );
    59  ----
    60  INSERT 3
    61  
    62  dump d t
    63  ----
    64  ----
    65  CREATE TABLE t (
    66  	i INT8 NULL,
    67  	f FLOAT8 NULL,
    68  	s STRING NULL,
    69  	b BYTES NULL,
    70  	d DATE NULL,
    71  	t TIME NULL,
    72  	ts TIMESTAMP NULL,
    73  	n INTERVAL NULL,
    74  	o BOOL NULL,
    75  	e DECIMAL NULL,
    76  	u UUID NULL,
    77  	ip INET NULL,
    78  	j JSONB NULL,
    79  	ary STRING[] NULL,
    80  	tz TIMESTAMPTZ NULL,
    81  	e1 DECIMAL(2) NULL,
    82  	e2 DECIMAL(2,1) NULL,
    83  	s1 STRING(1) NULL,
    84  	s2 STRING COLLATE en_u_ks_level2 NULL,
    85  	oi OID NULL,
    86  	FAMILY "primary" (i, f, d, t, ts, n, o, u, ip, j, ary, tz, e1, e2, s1, s2, oi, rowid),
    87  	FAMILY fam_1_s (s),
    88  	FAMILY fam_2_b (b),
    89  	FAMILY fam_3_e (e)
    90  );
    91  
    92  INSERT INTO t (i, f, s, b, d, t, ts, n, o, e, u, ip, j, ary, tz, e1, e2, s1, s2, oi) VALUES
    93  	(1, 2.3, 'striiing', '\x613162326333', '2016-03-26', '01:02:03.456', '2016-01-25 10:10:10+00:00', '02:30:30', true, 1.2345, 'e9716c74-2638-443d-90ed-ffde7bea7d1d', '192.168.0.1', '{"a": "b"}', ARRAY['hello','world'], '2016-01-25 10:10:10+00:00', 3, 4.5, 's', 'hello' COLLATE en_u_ks_level2, 6),
    94  	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
    95  	(NULL, '+Inf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Infinity', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
    96  	(NULL, '-Inf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-Infinity', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
    97  	(NULL, 'NaN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NaN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    98  ----
    99  ----