diff options
Diffstat (limited to 'src/test/regress/sql/transactions.sql')
| -rw-r--r-- | src/test/regress/sql/transactions.sql | 50 |
1 files changed, 25 insertions, 25 deletions
diff --git a/src/test/regress/sql/transactions.sql b/src/test/regress/sql/transactions.sql index d101ff305dd..d83a9f077fa 100644 --- a/src/test/regress/sql/transactions.sql +++ b/src/test/regress/sql/transactions.sql @@ -64,11 +64,11 @@ BEGIN; SAVEPOINT one; DROP TABLE foo; CREATE TABLE bar (a int); - ROLLBACK TO one; - RELEASE one; + ROLLBACK TO SAVEPOINT one; + RELEASE SAVEPOINT one; SAVEPOINT two; CREATE TABLE baz (a int); - RELEASE two; + RELEASE SAVEPOINT two; drop TABLE foobar; CREATE TABLE barbaz (a int); COMMIT; @@ -84,16 +84,16 @@ BEGIN; SAVEPOINT one; INSERT into bar VALUES (1); ROLLBACK TO one; - RELEASE one; + RELEASE SAVEPOINT one; SAVEPOINT two; INSERT into barbaz VALUES (1); RELEASE two; SAVEPOINT three; SAVEPOINT four; INSERT INTO foo VALUES (2); - RELEASE four; - ROLLBACK TO three; - RELEASE three; + RELEASE SAVEPOINT four; + ROLLBACK TO SAVEPOINT three; + RELEASE SAVEPOINT three; INSERT INTO foo VALUES (3); COMMIT; SELECT * FROM foo; -- should have 1 and 3 @@ -103,8 +103,8 @@ SELECT * FROM barbaz; -- should have 1 BEGIN; SAVEPOINT one; SELECT foo; - ROLLBACK TO one; - RELEASE one; + ROLLBACK TO SAVEPOINT one; + RELEASE SAVEPOINT one; SAVEPOINT two; CREATE TABLE savepoints (a int); SAVEPOINT three; @@ -113,7 +113,7 @@ BEGIN; INSERT INTO savepoints VALUES (2); SAVEPOINT five; INSERT INTO savepoints VALUES (3); - ROLLBACK TO five; + ROLLBACK TO SAVEPOINT five; COMMIT; COMMIT; -- should not be in a transaction block SELECT * FROM savepoints; @@ -122,7 +122,7 @@ SELECT * FROM savepoints; BEGIN; SAVEPOINT one; DELETE FROM savepoints WHERE a=1; - RELEASE one; + RELEASE SAVEPOINT one; SAVEPOINT two; DELETE FROM savepoints WHERE a=1; SAVEPOINT three; @@ -145,7 +145,7 @@ BEGIN; INSERT INTO savepoints VALUES (6); SAVEPOINT one; INSERT INTO savepoints VALUES (7); - RELEASE one; + RELEASE SAVEPOINT one; INSERT INTO savepoints VALUES (8); COMMIT; -- rows 6 and 8 should have been created by the same xact @@ -157,7 +157,7 @@ BEGIN; INSERT INTO savepoints VALUES (9); SAVEPOINT one; INSERT INTO savepoints VALUES (10); - ROLLBACK TO one; + ROLLBACK TO SAVEPOINT one; INSERT INTO savepoints VALUES (11); COMMIT; SELECT a FROM savepoints WHERE a in (9, 10, 11); @@ -170,7 +170,7 @@ BEGIN; INSERT INTO savepoints VALUES (13); SAVEPOINT two; INSERT INTO savepoints VALUES (14); - ROLLBACK TO one; + ROLLBACK TO SAVEPOINT one; INSERT INTO savepoints VALUES (15); SAVEPOINT two; INSERT INTO savepoints VALUES (16); @@ -185,9 +185,9 @@ BEGIN; INSERT INTO savepoints VALUES (19); SAVEPOINT two; INSERT INTO savepoints VALUES (20); - ROLLBACK TO one; + ROLLBACK TO SAVEPOINT one; INSERT INTO savepoints VALUES (21); - ROLLBACK TO one; + ROLLBACK TO SAVEPOINT one; INSERT INTO savepoints VALUES (22); COMMIT; SELECT a FROM savepoints WHERE a BETWEEN 18 AND 22; @@ -196,16 +196,16 @@ DROP TABLE savepoints; -- only in a transaction block: SAVEPOINT one; -ROLLBACK TO one; -RELEASE one; +ROLLBACK TO SAVEPOINT one; +RELEASE SAVEPOINT one; -- Only "rollback to" allowed in aborted state BEGIN; SAVEPOINT one; SELECT 0/0; SAVEPOINT two; -- ignored till the end of ... - RELEASE one; -- ignored till the end of ... - ROLLBACK TO one; + RELEASE SAVEPOINT one; -- ignored till the end of ... + ROLLBACK TO SAVEPOINT one; SELECT 1; COMMIT; SELECT 1; -- this should work @@ -215,19 +215,19 @@ BEGIN; DECLARE c CURSOR FOR SELECT unique2 FROM tenk1; SAVEPOINT one; FETCH 10 FROM c; - ROLLBACK TO one; + ROLLBACK TO SAVEPOINT one; FETCH 10 FROM c; - RELEASE one; + RELEASE SAVEPOINT one; FETCH 10 FROM c; CLOSE c; DECLARE c CURSOR FOR SELECT unique2/0 FROM tenk1; SAVEPOINT two; FETCH 10 FROM c; - ROLLBACK TO two; + ROLLBACK TO SAVEPOINT two; -- c is now dead to the world ... FETCH 10 FROM c; - ROLLBACK TO two; - RELEASE two; + ROLLBACK TO SAVEPOINT two; + RELEASE SAVEPOINT two; FETCH 10 FROM c; COMMIT; |