summaryrefslogtreecommitdiff
path: root/mysql-test/main/commit.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/commit.test')
-rw-r--r--mysql-test/main/commit.test26
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;