summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb_bugs/r/2952.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/r/2952.result')
-rw-r--r--storage/tokudb/mysql-test/tokudb_bugs/r/2952.result10
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;