github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/memo/testdata/logprops/virtual-scan (about)

     1  build
     2  SELECT catalog_name, sql_path
     3  FROM (SELECT * FROM information_schema.schemata WHERE SCHEMA_NAME='public')
     4  LEFT JOIN information_schema.tables
     5  ON CATALOG_NAME=TABLE_CATALOG AND SCHEMA_NAME=TABLE_SCHEMA
     6  ----
     7  project
     8   ├── columns: catalog_name:2(string!null) sql_path:5(string)
     9   ├── prune: (2,5)
    10   └── left-join (cross)
    11        ├── columns: catalog_name:2(string!null) schema_name:3(string!null) default_character_set_name:4(string) sql_path:5(string) information_schema.tables.crdb_internal_vtable_pk:6(int) table_catalog:7(string) table_schema:8(string) table_name:9(string) table_type:10(string) is_insertable_into:11(string) version:12(int)
    12        ├── fd: ()-->(3), (6)-->(7-12)
    13        ├── prune: (4-6,9-12)
    14        ├── reject-nulls: (6-12)
    15        ├── interesting orderings: (+6)
    16        ├── multiplicity: left-rows(one-or-more), right-rows(zero-or-more)
    17        ├── project
    18        │    ├── columns: catalog_name:2(string!null) schema_name:3(string!null) default_character_set_name:4(string) sql_path:5(string)
    19        │    ├── fd: ()-->(3)
    20        │    ├── prune: (2-5)
    21        │    └── select
    22        │         ├── columns: information_schema.schemata.crdb_internal_vtable_pk:1(int!null) catalog_name:2(string!null) schema_name:3(string!null) default_character_set_name:4(string) sql_path:5(string)
    23        │         ├── key: (1)
    24        │         ├── fd: ()-->(3), (1)-->(2,4,5)
    25        │         ├── prune: (1,2,4,5)
    26        │         ├── interesting orderings: (+1)
    27        │         ├── scan information_schema.schemata
    28        │         │    ├── columns: information_schema.schemata.crdb_internal_vtable_pk:1(int!null) catalog_name:2(string!null) schema_name:3(string!null) default_character_set_name:4(string) sql_path:5(string)
    29        │         │    ├── key: (1)
    30        │         │    ├── fd: (1)-->(2-5)
    31        │         │    ├── prune: (1-5)
    32        │         │    └── interesting orderings: (+1)
    33        │         └── filters
    34        │              └── eq [type=bool, outer=(3), constraints=(/3: [/'public' - /'public']; tight), fd=()-->(3)]
    35        │                   ├── variable: schema_name:3 [type=string]
    36        │                   └── const: 'public' [type=string]
    37        ├── scan information_schema.tables
    38        │    ├── columns: information_schema.tables.crdb_internal_vtable_pk:6(int!null) table_catalog:7(string!null) table_schema:8(string!null) table_name:9(string!null) table_type:10(string!null) is_insertable_into:11(string!null) version:12(int)
    39        │    ├── key: (6)
    40        │    ├── fd: (6)-->(7-12)
    41        │    ├── prune: (6-12)
    42        │    └── interesting orderings: (+6)
    43        └── filters
    44             └── and [type=bool, outer=(2,3,7,8), constraints=(/2: (/NULL - ]; /3: (/NULL - ]; /7: (/NULL - ]; /8: (/NULL - ])]
    45                  ├── eq [type=bool]
    46                  │    ├── variable: catalog_name:2 [type=string]
    47                  │    └── variable: table_catalog:7 [type=string]
    48                  └── eq [type=bool]
    49                       ├── variable: schema_name:3 [type=string]
    50                       └── variable: table_schema:8 [type=string]