diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/r/2952.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb_bugs/r/2952.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/2952.result b/storage/tokudb/mysql-test/tokudb_bugs/r/2952.result index d0319ab9f74..df6dd0604dc 100644 --- a/storage/tokudb/mysql-test/tokudb_bugs/r/2952.result +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/2952.result @@ -1,6 +1,8 @@ SET DEFAULT_STORAGE_ENGINE = 'tokudb'; # Establish connection conn1 (user = root) +connect conn1,localhost,root,,; DROP TABLE IF EXISTS foo; +connection default; set session transaction isolation level read uncommitted; set session tokudb_prelock_empty=1; set session tokudb_load_save_space=0; @@ -15,6 +17,7 @@ foo CREATE TABLE `foo` ( ) ENGINE=TokuDB DEFAULT CHARSET=latin1 begin; insert into foo values (1,10,100),(2,20,200),(3,30,300); +connection conn1; set session transaction isolation level read uncommitted; set session lock_wait_timeout=1; insert into foo values (100,100,100); @@ -23,6 +26,7 @@ alter table foo drop index a; ERROR HY000: Lock wait timeout exceeded; try restarting transaction truncate table foo; ERROR HY000: Lock wait timeout exceeded; try restarting transaction +connection default; commit; drop table foo; set session tokudb_prelock_empty=1; @@ -38,12 +42,14 @@ foo CREATE TABLE `foo` ( ) ENGINE=TokuDB DEFAULT CHARSET=latin1 begin; insert into foo values (1,10,100),(2,20,200),(3,30,300); +connection conn1; insert into foo values (100,100,100); ERROR HY000: Lock wait timeout exceeded; try restarting transaction alter table foo drop index a; ERROR HY000: Lock wait timeout exceeded; try restarting transaction truncate table foo; ERROR HY000: Lock wait timeout exceeded; try restarting transaction +connection default; commit; drop table foo; set session tokudb_prelock_empty=0; @@ -59,10 +65,14 @@ foo CREATE TABLE `foo` ( ) ENGINE=TokuDB DEFAULT CHARSET=latin1 begin; insert into foo values (1,10,100),(2,20,200),(3,30,300); +connection conn1; insert into foo values (100,100,100); alter table foo drop index a; ERROR HY000: Lock wait timeout exceeded; try restarting transaction truncate table foo; ERROR HY000: Lock wait timeout exceeded; try restarting transaction +connection default; +disconnect conn1; +connection default; set session transaction isolation level serializable; DROP TABLE foo; |