summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/r/locks-delete-deadlock-1.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/locks-delete-deadlock-1.result')
-rw-r--r--storage/tokudb/mysql-test/tokudb/r/locks-delete-deadlock-1.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/locks-delete-deadlock-1.result b/storage/tokudb/mysql-test/tokudb/r/locks-delete-deadlock-1.result
index d2feccac563..59fe0a606c7 100644
--- a/storage/tokudb/mysql-test/tokudb/r/locks-delete-deadlock-1.result
+++ b/storage/tokudb/mysql-test/tokudb/r/locks-delete-deadlock-1.result
@@ -1,13 +1,20 @@
SET DEFAULT_STORAGE_ENGINE='tokudb';
drop table if exists t;
+connect conn1,localhost,root;
+connection default;
create table t (a int primary key, b int);
insert into t values (1,0),(2,1),(3,0);
begin;
delete from t where b>0;
+connection conn1;
set transaction isolation level serializable;
select * from t where a!=2;
+connection default;
commit;
+connection conn1;
a b
1 0
3 0
+connection default;
+disconnect conn1;
drop table t;