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

     1  # LogicTest: local-mixed-19.2-20.1
     2  
     3  statement error savepoints cannot be used until the version upgrade is finalized
     4  BEGIN;
     5    SAVEPOINT foo
     6  
     7  statement ok
     8  ROLLBACK
     9  
    10  statement error savepoints cannot be used until the version upgrade is finalized
    11  BEGIN;
    12    SAVEPOINT cockroach_restart;
    13    SAVEPOINT foo
    14  
    15  statement ok
    16  ROLLBACK
    17  
    18  ## Verify that restart savepoints still work fine.
    19  
    20  statement ok
    21  CREATE TABLE test(x INT); INSERT INTO test(x) VALUES (1);
    22  
    23  statement ok
    24  BEGIN;
    25    SAVEPOINT cockroach_restart;
    26    INSERT INTO test(x) VALUES (2);
    27    ROLLBACK TO SAVEPOINT cockroach_restart;
    28    COMMIT
    29  
    30  query I
    31  SELECT * FROM test
    32  ----
    33  1
    34  
    35  statement error column "nonexistent" does not exist
    36  BEGIN;
    37    SAVEPOINT cockroach_restart;
    38    INSERT INTO test(x) VALUES (2);
    39    SELECT nonexistent
    40  
    41  statement ok
    42  ROLLBACK TO SAVEPOINT cockroach_restart;
    43    COMMIT
    44  
    45  query I
    46  SELECT * FROM test
    47  ----
    48  1