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

     1  sql
     2  CREATE DATABASE d;
     3  CREATE TABLE d.t (
     4  	a JSON,
     5  	b JSON,
     6  	c INT[],
     7  	d INT[],
     8  	e geography(geometry),
     9  	f geometry(point, 4326),
    10  
    11  	INVERTED INDEX idx (a),
    12  	INVERTED INDEX idx3 (c),
    13  	INVERTED INDEX idx5 (e)
    14  );
    15  
    16  CREATE INVERTED INDEX idx2 ON d.t (b);
    17  CREATE INVERTED INDEX idx4 ON d.t (d);
    18  CREATE INVERTED INDEX idx6 ON d.t (f);
    19  
    20  INSERT INTO d.t VALUES ('{"a": "b"}', '{"c": "d"}', ARRAY[1], ARRAY[2], 'POINT(1.0 1.0)', 'SRID=4326;POINT(1.0 1.0)');
    21  ----
    22  INSERT 1
    23  
    24  dump d t
    25  ----
    26  ----
    27  CREATE TABLE t (
    28  	a JSONB NULL,
    29  	b JSONB NULL,
    30  	c INT8[] NULL,
    31  	d INT8[] NULL,
    32  	e GEOGRAPHY(GEOMETRY) NULL,
    33  	f GEOMETRY(POINT,4326) NULL,
    34  	INVERTED INDEX idx (a),
    35  	INVERTED INDEX idx3 (c),
    36  	INVERTED INDEX idx5 (e),
    37  	INVERTED INDEX idx2 (b),
    38  	INVERTED INDEX idx4 (d),
    39  	INVERTED INDEX idx6 (f),
    40  	FAMILY "primary" (a, b, c, d, e, f, rowid)
    41  );
    42  
    43  INSERT INTO t (a, b, c, d, e, f) VALUES
    44  	('{"a": "b"}', '{"c": "d"}', ARRAY[1], ARRAY[2], '0101000020E6100000000000000000F03F000000000000F03F', '0101000020E6100000000000000000F03F000000000000F03F');
    45  ----
    46  ----