diff options
Diffstat (limited to 'mysql-test/main/commit.test')
-rw-r--r-- | mysql-test/main/commit.test | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/mysql-test/main/commit.test b/mysql-test/main/commit.test index a0d4ddee152..4fb86f5e8bc 100644 --- a/mysql-test/main/commit.test +++ b/mysql-test/main/commit.test @@ -34,23 +34,23 @@ COMMIT; # # Verify consistent output from -# SELECT @@tx_isolation (Bug#20837) +# SELECT @@transaction_isolation (Bug#20837) # # The transaction will be in READ UNCOMMITTED mode, -# but SELECT @@tx_isolation should report the session +# but SELECT @@transaction_isolation should report the session # value, which is REPEATABLE READ # SET @@autocommit=0; COMMIT; SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; START TRANSACTION; -SELECT @@tx_isolation; +SELECT @@transaction_isolation; --echo Should be REPEATABLE READ SELECT * FROM t1; -SELECT @@tx_isolation; +SELECT @@transaction_isolation; --echo Should be REPEATABLE READ INSERT INTO t1 VALUES (-1); -SELECT @@tx_isolation; +SELECT @@transaction_isolation; --echo Should be REPEATABLE READ COMMIT; @@ -370,16 +370,16 @@ COMMIT; --echo # Test 2: Check setting of variable. SET SESSION TRANSACTION READ WRITE; -SELECT @@tx_read_only; +SELECT @@transaction_read_only; SET SESSION TRANSACTION READ ONLY; -SELECT @@tx_read_only; +SELECT @@transaction_read_only; SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ, READ WRITE; -SELECT @@tx_read_only; +SELECT @@transaction_read_only; SET SESSION TRANSACTION READ ONLY, ISOLATION LEVEL REPEATABLE READ; -SELECT @@tx_read_only; +SELECT @@transaction_read_only; START TRANSACTION; --echo # Not allowed inside a transaction @@ -628,14 +628,14 @@ DROP TABLE t1; CREATE PROCEDURE p1() SET SESSION TRANSACTION READ ONLY; CALL p1(); -SELECT @@tx_read_only; +SELECT @@transaction_read_only; SET SESSION TRANSACTION READ WRITE; DROP PROCEDURE p1; CREATE PROCEDURE p1() SET SESSION TRANSACTION READ ONLY, ISOLATION LEVEL SERIALIZABLE; CALL p1(); -SELECT @@tx_read_only; +SELECT @@transaction_read_only; SET SESSION TRANSACTION READ WRITE, ISOLATION LEVEL REPEATABLE READ; DROP PROCEDURE p1; @@ -648,7 +648,7 @@ END| delimiter ;| SELECT f1(); -SELECT @@tx_read_only; +SELECT @@transaction_read_only; SET SESSION TRANSACTION READ WRITE; DROP FUNCTION f1; @@ -661,7 +661,7 @@ END| delimiter ;| SELECT f1(); -SELECT @@tx_read_only; +SELECT @@transaction_read_only; SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ, READ WRITE; DROP FUNCTION f1; |