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

     1  statement ok
     2  CREATE TABLE kv (
     3    k CHAR PRIMARY KEY,
     4    v CHAR
     5  )
     6  
     7  query TT
     8  SELECT * FROM kv
     9  ----
    10  
    11  statement ok
    12  INSERT INTO kv (k,v) VALUES ('a', 'b'); INSERT INTO kv (k,v) VALUES ('c', 'd')
    13  
    14  query TT rowsort
    15  SELECT * FROM kv
    16  ----
    17  a b
    18  c d
    19  
    20  # error if either statement returns an error
    21  # first statement returns an error. Second stmt shouldn't execute.
    22  statement error duplicate key value \(k\)=\('a'\) violates unique constraint "primary"
    23  INSERT INTO kv (k,v) VALUES ('a', 'b'); INSERT INTO kv (k,v) VALUES ('e', 'f')
    24  
    25  query TT rowsort
    26  SELECT * FROM kv
    27  ----
    28  a b
    29  c d
    30  
    31  # second statement returns an error
    32  statement error duplicate key value \(k\)=\('a'\) violates unique constraint "primary"
    33  INSERT INTO kv (k,v) VALUES ('g', 'h'); INSERT INTO kv (k,v) VALUES ('a', 'b')
    34  
    35  query TT rowsort
    36  SELECT * FROM kv
    37  ----
    38  a b
    39  c d
    40  g h
    41  
    42  # parse error runs nothing
    43  statement error at or near "k": syntax error
    44  INSERT INTO kv (k,v) VALUES ('i', 'j'); INSERT INTO VALUES ('k', 'l')
    45  
    46  query TT rowsort
    47  SELECT * FROM kv
    48  ----
    49  a b
    50  c d
    51  g h
    52  
    53  statement error pq: relation "x.y" does not exist
    54  BEGIN; INSERT INTO x.y(a) VALUES (1); END
    55  
    56  statement error pq: current transaction is aborted, commands ignored until end of transaction block
    57  SELECT * from kv; ROLLBACK
    58  
    59  statement ok
    60  ROLLBACK
    61  
    62  statement error pgcode 42P01 relation "system.t" does not exist
    63  BEGIN TRANSACTION; SELECT * FROM system.t; INSERT INTO t(a) VALUES (1)