diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-2808-read-uncommitted.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/mvcc-2808-read-uncommitted.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-2808-read-uncommitted.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-2808-read-uncommitted.result index e8ffcc7f843..8e2d2b74276 100644 --- a/storage/tokudb/mysql-test/tokudb/r/mvcc-2808-read-uncommitted.result +++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-2808-read-uncommitted.result @@ -1,6 +1,8 @@ # Establish connection conn1 (user = root) +connect conn1,localhost,root,,; SET DEFAULT_STORAGE_ENGINE = 'tokudb'; DROP TABLE IF EXISTS foo,foo_isam; +connection conn1; set session transaction isolation level read uncommitted; create table foo ( a int, b int, primary key (a)); insert into foo values (1,1),(2,2),(3,1),(4,3); @@ -18,8 +20,10 @@ a b 2 2 3 10 4 3 +connection default; insert into foo values (5,5); ERROR HY000: Lock wait timeout exceeded; try restarting transaction +connection conn1; rollback; select * from foo; a b @@ -34,8 +38,10 @@ a b 1 1 3 1 4 3 +connection default; insert into foo values (5,5); ERROR HY000: Lock wait timeout exceeded; try restarting transaction +connection conn1; rollback; select * from foo; a b @@ -46,6 +52,7 @@ a b create table foo_isam (a int, b int)engine=MyISAM; begin; insert into foo_isam select * from foo; +connection default; insert into foo values (5,5); select * from foo; a b @@ -54,6 +61,10 @@ a b 3 1 4 3 5 5 +connection conn1; commit; +connection default; +disconnect conn1; +connection default; set session transaction isolation level serializable; DROP TABLE foo, foo_isam; |