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

     1  build
     2  SHOW DATABASES
     3  ----
     4  sort
     5   ├── columns: database_name:2!null
     6   ├── ordering: +2
     7   └── distinct-on
     8        ├── columns: catalog_name:2!null
     9        ├── grouping columns: catalog_name:2!null
    10        └── project
    11             ├── columns: catalog_name:2!null
    12             └── scan "".information_schema.schemata
    13                  └── columns: crdb_internal_vtable_pk:1!null catalog_name:2!null schema_name:3!null default_character_set_name:4 sql_path:5
    14  
    15  # Note: t is the default database for the test catalog.
    16  build
    17  SHOW SCHEMAS FROM t
    18  ----
    19  sort
    20   ├── columns: schema_name:3!null
    21   ├── ordering: +3
    22   └── project
    23        ├── columns: schema_name:3!null
    24        └── select
    25             ├── columns: crdb_internal_vtable_pk:1!null catalog_name:2!null schema_name:3!null default_character_set_name:4 sql_path:5
    26             ├── scan t.information_schema.schemata
    27             │    └── columns: crdb_internal_vtable_pk:1!null catalog_name:2!null schema_name:3!null default_character_set_name:4 sql_path:5
    28             └── filters
    29                  └── catalog_name:2 = 't'