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

     1  # LogicTest: local
     2  
     3  query TTTTT
     4  EXPLAIN (VERBOSE) SELECT * FROM system.information_schema.schemata
     5  ----
     6  ·              distributed  false             ·                                                                  ·
     7  ·              vectorized   false             ·                                                                  ·
     8  virtual table  ·            ·                 (catalog_name, schema_name, default_character_set_name, sql_path)  ·
     9  ·              source       schemata@primary  ·                                                                  ·
    10  
    11  query TTT
    12  EXPLAIN SELECT * FROM system.information_schema.tables WHERE table_name='foo'
    13  ----
    14  ·              distributed  false
    15  ·              vectorized   false
    16  virtual table  ·            ·
    17  ·              source       tables@tables_table_name_idx
    18  ·              constraint   /4: [/'foo' - /'foo']
    19  
    20  statement error use of crdb_internal_vtable_pk column not allowed
    21  SELECT crdb_internal_vtable_pk FROM system.information_schema.schemata
    22  
    23  statement error use of crdb_internal_vtable_pk column not allowed
    24  SELECT schema_name FROM system.information_schema.schemata ORDER BY crdb_internal_vtable_pk
    25  
    26  statement error use of crdb_internal_vtable_pk column not allowed
    27  SELECT schema_name FROM system.information_schema.schemata WHERE crdb_internal_vtable_pk = 1