github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/drop_table (about)

     1  # LogicTest: local
     2  
     3  statement ok
     4  CREATE TABLE a (id INT PRIMARY KEY)
     5  
     6  statement ok
     7  CREATE TABLE b (id INT PRIMARY KEY)
     8  
     9  query TTT
    10  SHOW TABLES FROM test
    11  ----
    12  public  a  table
    13  public  b  table
    14  
    15  statement ok
    16  INSERT INTO a VALUES (3),(7),(2)
    17  
    18  query I rowsort
    19  SELECT * FROM a
    20  ----
    21  2
    22  3
    23  7
    24  
    25  statement ok
    26  DROP TABLE a
    27  
    28  # The "updating privileges" clause in the SELECT statement is for excluding jobs
    29  # run by an unrelated startup migration.
    30  # TODO (lucy): Update this if/when we decide to change how these jobs queued by
    31  # the startup migration are handled.
    32  query TT
    33  SELECT job_type, status FROM [SHOW JOBS] WHERE job_type = 'SCHEMA CHANGE GC' OR (job_type = 'SCHEMA CHANGE' AND description != 'updating privileges')
    34  ----
    35  SCHEMA CHANGE     succeeded
    36  SCHEMA CHANGE GC  running
    37  
    38  query TTT
    39  SHOW TABLES FROM test
    40  ----
    41  public  b  table
    42  
    43  statement error pgcode 42P01 relation "a" does not exist
    44  SELECT * FROM a
    45  
    46  statement error pq: \[53 AS a\]: table is being dropped
    47  SELECT * FROM [53 AS a]
    48  
    49  statement error pgcode 42P01 relation "a" does not exist
    50  DROP TABLE a
    51  
    52  statement ok
    53  DROP TABLE IF EXISTS a
    54  
    55  statement ok
    56  CREATE TABLE a (id INT PRIMARY KEY)
    57  
    58  query I
    59  SELECT * FROM a
    60  ----