summaryrefslogtreecommitdiff
path: root/mysql-test/r/transaction_timeout.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/transaction_timeout.result')
-rw-r--r--mysql-test/r/transaction_timeout.result86
1 files changed, 6 insertions, 80 deletions
diff --git a/mysql-test/r/transaction_timeout.result b/mysql-test/r/transaction_timeout.result
index 1b8d7dbc2a5..c8db4a0e744 100644
--- a/mysql-test/r/transaction_timeout.result
+++ b/mysql-test/r/transaction_timeout.result
@@ -1,125 +1,51 @@
-connect c0,localhost,root,,test,,;
-SET autocommit=0;
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
+# Test idle_transaction_timeout
+connect c0,localhost,root,,test,,;
SHOW VARIABLES LIKE 'idle_%transaction_timeout';
Variable_name Value
idle_readonly_transaction_timeout 0
idle_readwrite_transaction_timeout 0
idle_transaction_timeout 0
+SET autocommit=0;
SET idle_transaction_timeout=1;
-SHOW VARIABLES LIKE 'idle_%transaction_timeout';
-Variable_name Value
-idle_readonly_transaction_timeout 0
-idle_readwrite_transaction_timeout 0
-idle_transaction_timeout 1
BEGIN;
-INSERT INTO t1 VALUES (1),(2),(3);
-COMMIT;
SELECT * FROM t1;
a
-1
-2
-3
-BEGIN;
-INSERT INTO t1 VALUES (4),(5),(6);
SELECT * FROM t1;
Got one of the listed errors
disconnect c0;
+# Test idle_readonly_transaction_timeout
connect c1,localhost,root,,test,,;
-SELECT * FROM t1;
-a
-1
-2
-3
-DROP TABLE t1;
-SET idle_transaction_timeout=0;
SHOW VARIABLES LIKE 'idle_%transaction_timeout';
Variable_name Value
idle_readonly_transaction_timeout 0
idle_readwrite_transaction_timeout 0
idle_transaction_timeout 0
SET autocommit=0;
-CREATE TABLE t1 (a INT) ENGINE=InnoDB;
-SHOW VARIABLES LIKE 'idle_%transaction_timeout';
-Variable_name Value
-idle_readonly_transaction_timeout 0
-idle_readwrite_transaction_timeout 0
-idle_transaction_timeout 0
SET idle_readonly_transaction_timeout=1;
-SHOW VARIABLES LIKE 'idle_%transaction_timeout';
-Variable_name Value
-idle_readonly_transaction_timeout 1
-idle_readwrite_transaction_timeout 0
-idle_transaction_timeout 0
BEGIN;
-INSERT INTO t1 VALUES (1),(2),(3);
SELECT * FROM t1;
a
-1
-2
-3
-COMMIT;
-SELECT * FROM t1;
-a
-1
-2
-3
SELECT * FROM t1;
Got one of the listed errors
disconnect c1;
+# Test idle_readwrite_transaction_timeout
connect c2,localhost,root,,test,,;
-SELECT * FROM t1;
-a
-1
-2
-3
-DROP TABLE t1;
-SET idle_readonly_transaction_timeout=0;
SHOW VARIABLES LIKE 'idle_%transaction_timeout';
Variable_name Value
idle_readonly_transaction_timeout 0
idle_readwrite_transaction_timeout 0
idle_transaction_timeout 0
SET autocommit=0;
-CREATE TABLE t1 (a INT) ENGINE=InnoDB;
-SHOW VARIABLES LIKE 'idle_%transaction_timeout';
-Variable_name Value
-idle_readonly_transaction_timeout 0
-idle_readwrite_transaction_timeout 0
-idle_transaction_timeout 0
SET idle_readwrite_transaction_timeout=1;
-SHOW VARIABLES LIKE 'idle_%transaction_timeout';
-Variable_name Value
-idle_readonly_transaction_timeout 0
-idle_readwrite_transaction_timeout 1
-idle_transaction_timeout 0
BEGIN;
-INSERT INTO t1 VALUES (1),(2),(3);
-SELECT * FROM t1;
-a
-1
-2
-3
-COMMIT;
SELECT * FROM t1;
a
-1
-2
-3
SELECT * FROM t1;
a
-1
-2
-3
-INSERT INTO t1 VALUES (4),(5),(6);
+INSERT INTO t1 VALUES (1);
SELECT * FROM t1;
Got one of the listed errors
disconnect c2;
connection default;
DROP TABLE t1;
-SET idle_readwrite_transaction_timeout=0;
-SHOW VARIABLES LIKE 'idle_%transaction_timeout';
-Variable_name Value
-idle_readonly_transaction_timeout 0
-idle_readwrite_transaction_timeout 0
-idle_transaction_timeout 0