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

     1  exec-ddl
     2  CREATE TABLE a (k INT PRIMARY KEY, i INT, s STRING, d DECIMAL NOT NULL)
     3  ----
     4  
     5  opt
     6  SELECT k, i, s || 'foo' FROM a
     7  ----
     8  project
     9   ├── columns: k:1!null i:2 "?column?":5
    10   ├── stats: [rows=1000]
    11   ├── cost: 1090.03
    12   ├── key: (1)
    13   ├── fd: (1)-->(2,5)
    14   ├── scan a
    15   │    ├── columns: k:1!null i:2 s:3
    16   │    ├── stats: [rows=1000]
    17   │    ├── cost: 1070.02
    18   │    ├── key: (1)
    19   │    └── fd: (1)-->(2,3)
    20   └── projections
    21        └── s:3 || 'foo' [as="?column?":5, outer=(3)]
    22  
    23  opt
    24  SELECT k, k+2, i*d FROM a
    25  ----
    26  project
    27   ├── columns: k:1!null "?column?":5!null "?column?":6
    28   ├── stats: [rows=1000]
    29   ├── cost: 1100.03
    30   ├── key: (1)
    31   ├── fd: (1)-->(5,6)
    32   ├── scan a
    33   │    ├── columns: k:1!null i:2 d:4!null
    34   │    ├── stats: [rows=1000]
    35   │    ├── cost: 1070.02
    36   │    ├── key: (1)
    37   │    └── fd: (1)-->(2,4)
    38   └── projections
    39        ├── k:1 + 2 [as="?column?":5, outer=(1)]
    40        └── i:2 * d:4 [as="?column?":6, outer=(2,4)]