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

     1  # LogicTest: 5node
     2  
     3  statement ok
     4  CREATE TABLE xyz (
     5    id INT PRIMARY KEY,
     6    x INT,
     7    y INT,
     8    z INT
     9  )
    10  
    11  statement ok
    12  ALTER TABLE xyz SPLIT AT VALUES (2), (4), (6), (7)
    13  
    14  statement ok
    15  ALTER TABLE xyz EXPERIMENTAL_RELOCATE VALUES
    16    (ARRAY[1], 0),
    17    (ARRAY[2], 2),
    18    (ARRAY[3], 4),
    19    (ARRAY[4], 6),
    20    (ARRAY[5], 7)
    21  
    22  
    23  query TTTI colnames
    24  SELECT start_key, end_key, replicas, lease_holder from [SHOW RANGES FROM TABLE xyz]
    25  ----
    26  start_key  end_key  replicas  lease_holder
    27  NULL       /2       {1}       1
    28  /2         /4       {2}       2
    29  /4         /6       {3}       3
    30  /6         /7       {4}       4
    31  /7         NULL     {5}       5
    32  
    33  query TTTTT
    34  EXPLAIN (VERBOSE) SELECT x, y, z, ordinality FROM xyz WITH ORDINALITY
    35  ----
    36  ·           distributed  false        ·                        ·
    37  ·           vectorized   true         ·                        ·
    38  ordinality  ·            ·            (x, y, z, "ordinality")  ·
    39   └── scan   ·            ·            (x, y, z)                ·
    40  ·           table        xyz@primary  ·                        ·
    41  ·           spans        FULL SCAN    ·                        ·
    42  
    43  query T
    44  SELECT url FROM [EXPLAIN (DISTSQL) SELECT x, y, z, ordinality FROM xyz WITH ORDINALITY]
    45  ----
    46  https://cockroachdb.github.io/distsqlplan/decode.html#eJyUkE9Lw0AQxe9-imVOCiNtqqc9pdiKC7GpSUClzWHNDiWQZuPuBpKWfHdJIv4DpR7nzfzee7tHsK8FcIiXwfImYbUp2G0U3rPN8mkdzMWKnS9EnMQPwQV7P2mQtcgOyLagjcpLWeSu3cKINe2BPYrkjoXRQqzmgUieU0AotaKV3JMFvgEPUoTK6Iys1aaXjsOBUA3wKUJeVrXr5RQh04aAH8HlriDgkMiXgiKSisxkCgiKnMyLwbYy-V6a1m_aAyDElSwtZ5eAENaOM3-G_hX615B2CLp2nxHWyR0B9zo8vUb48fCJ963Fb-6z_7hHZCtdWjrJedqlCKR2NH6k1bXJaG10NsSMYzhwg6DIunHrjYMox1Vf8Cvs_QnPfsBpd_YWAAD__zocvUQ=