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

     1  # Default behavior, where atomicity violations are allowed
     2  
     3  statement ok
     4  CREATE TABLE testing (k int, v string);
     5    INSERT INTO testing (k,v) VALUES (1, 'a'), (2, 'b'), (3, 'a'), (4, 'b');
     6    CREATE TABLE unrelated(x INT)
     7  
     8  
     9  statement ok
    10  BEGIN
    11  
    12  statement ok
    13  ALTER TABLE testing ADD CONSTRAINT "unique_values" UNIQUE(v)
    14  
    15  statement ok
    16  INSERT INTO testing (k,v) VALUES (5, 'c');
    17  INSERT INTO unrelated(x) VALUES (1);
    18  
    19  
    20  statement error pgcode XXA00 violates unique constraint.*\n.*\n.*\n.*\n.*issues/42061
    21  COMMIT
    22  
    23  # oops!
    24  query IT rowsort
    25  SELECT * FROM testing
    26  ----
    27  1  a
    28  2  b
    29  3  a
    30  4  b
    31  5  c
    32  
    33  # oops again!
    34  query I
    35  SELECT * FROM unrelated
    36  ----
    37  1