diff options
Diffstat (limited to 'mysql-test/r/transaction_timeout.result')
-rw-r--r-- | mysql-test/r/transaction_timeout.result | 86 |
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 |