github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/exec/execbuilder/testdata/geospatial (about)

     1  # This logic test fails in the 3node-tenant configuration because the keys are
     2  # prefixed with the tenant ID if run by a tenant:
     3  # https://github.com/cockroachdb/cockroach/issues/49582
     4  # LogicTest: !3node-tenant
     5  
     6  statement ok
     7  CREATE TABLE b(
     8    a int primary key,
     9    geog geography(geometry, 4326),
    10    geom geometry(point),
    11    FAMILY (a, geog, geom)
    12  )
    13  
    14  statement ok
    15  CREATE TABLE c(
    16    a int primary key,
    17    geog geography(geometry, 4326),
    18    geom geometry(point),
    19    FAMILY (a, geog, geom),
    20    INVERTED INDEX (geog),
    21    INVERTED INDEX (geom)
    22  )
    23  
    24  query T kvtrace
    25  INSERT INTO b VALUES
    26    (1, 'POINT(1.0 1.0)', 'POINT(2.0 2.0)'),
    27    (2, 'LINESTRING(1.0 1.0, 2.0 2.0)', 'POINT(1.0 1.0)')
    28  ----
    29  CPut /Table/53/1/1/0 -> /TUPLE/
    30  CPut /Table/53/1/2/0 -> /TUPLE/
    31  
    32  query T kvtrace
    33  INSERT INTO c VALUES
    34    (1, 'POINT(1.0 1.0)', 'POINT(2.0 2.0)'),
    35    (2, 'LINESTRING(1.0 1.0, 2.0 2.0)', 'POINT(1.0 1.0)')
    36  ----
    37  CPut /Table/54/1/1/0 -> /TUPLE/
    38  InitPut /Table/54/2/1153277837650709461/1/0 -> /BYTES/
    39  InitPut /Table/54/3/1152921526351450449/1/0 -> /BYTES/
    40  CPut /Table/54/1/2/0 -> /TUPLE/
    41  InitPut /Table/54/2/1153290940513779712/2/0 -> /BYTES/
    42  InitPut /Table/54/2/1154047404446580736/2/0 -> /BYTES/
    43  InitPut /Table/54/2/1154328879490400256/2/0 -> /BYTES/
    44  InitPut /Table/54/3/1152921510042997845/2/0 -> /BYTES/
    45  
    46  statement ok
    47  CREATE INVERTED INDEX geog_idx ON b(geog)
    48  
    49  statement ok
    50  CREATE INVERTED INDEX geom_idx ON b(geom)
    51  
    52  query T kvtrace
    53  INSERT INTO b VALUES
    54    (3, 'POINT(1.0 1.0)', 'POINT(2.0 2.0)'),
    55    (4, 'LINESTRING(1.0 1.0, 2.0 2.0)', 'POINT(1.0 1.0)')
    56  ----
    57  CPut /Table/53/1/3/0 -> /TUPLE/
    58  InitPut /Table/53/2/1153277837650709461/3/0 -> /BYTES/
    59  InitPut /Table/53/3/1152921526351450449/3/0 -> /BYTES/
    60  CPut /Table/53/1/4/0 -> /TUPLE/
    61  InitPut /Table/53/2/1153290940513779712/4/0 -> /BYTES/
    62  InitPut /Table/53/2/1154047404446580736/4/0 -> /BYTES/
    63  InitPut /Table/53/2/1154328879490400256/4/0 -> /BYTES/
    64  InitPut /Table/53/3/1152921510042997845/4/0 -> /BYTES/