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

     1  exec-ddl
     2  CREATE TABLE abcd (
     3    a INT PRIMARY KEY,
     4    b INT,
     5    c INT,
     6    d INT,
     7    INDEX abc (a, b, c)
     8  )
     9  ----
    10  
    11  build
    12  SELECT * FROM (VALUES ('a'), ('b')) WITH ORDINALITY AS X(name, i)
    13  ----
    14  ordinality
    15   ├── columns: name:1!null i:2!null
    16   └── values
    17        ├── columns: column1:1!null
    18        ├── ('a',)
    19        └── ('b',)
    20  
    21  build
    22  SELECT a, ordinality FROM abcd WITH ORDINALITY
    23  ----
    24  project
    25   ├── columns: a:1!null ordinality:5!null
    26   └── ordinality
    27        ├── columns: a:1!null b:2 c:3 d:4 ordinality:5!null
    28        └── scan abcd
    29             └── columns: a:1!null b:2 c:3 d:4
    30  
    31  build
    32  SELECT a, ordinality FROM (SELECT * FROM abcd ORDER BY a) WITH ORDINALITY
    33  ----
    34  project
    35   ├── columns: a:1!null ordinality:5!null
    36   └── ordinality
    37        ├── columns: a:1!null b:2 c:3 d:4 ordinality:5!null
    38        └── scan abcd
    39             ├── columns: a:1!null b:2 c:3 d:4
    40             └── ordering: +1
    41  
    42  build
    43  SELECT a, ordinality FROM (SELECT * FROM abcd ORDER BY a) WITH ORDINALITY ORDER BY ordinality
    44  ----
    45  project
    46   ├── columns: a:1!null ordinality:5!null
    47   ├── ordering: +5
    48   └── ordinality
    49        ├── columns: a:1!null b:2 c:3 d:4 ordinality:5!null
    50        ├── ordering: +5
    51        └── scan abcd
    52             ├── columns: a:1!null b:2 c:3 d:4
    53             └── ordering: +1
    54  
    55  build
    56  SELECT a FROM abcd WITH ORDINALITY ORDER BY ordinality
    57  ----
    58  project
    59   ├── columns: a:1!null  [hidden: ordinality:5!null]
    60   ├── ordering: +5
    61   └── ordinality
    62        ├── columns: a:1!null b:2 c:3 d:4 ordinality:5!null
    63        ├── ordering: +5
    64        └── scan abcd
    65             └── columns: a:1!null b:2 c:3 d:4
    66  
    67  build
    68  SELECT ordinality FROM abcd WITH ORDINALITY ORDER BY a
    69  ----
    70  sort
    71   ├── columns: ordinality:5!null  [hidden: a:1!null]
    72   ├── ordering: +1
    73   └── project
    74        ├── columns: a:1!null ordinality:5!null
    75        └── ordinality
    76             ├── columns: a:1!null b:2 c:3 d:4 ordinality:5!null
    77             └── scan abcd
    78                  └── columns: a:1!null b:2 c:3 d:4