summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result
diff options
context:
space:
mode:
authorSergey Vojtovich <svoj@mariadb.org>2016-03-25 20:51:22 +0400
committerSergey Vojtovich <svoj@mariadb.org>2016-03-31 10:11:16 +0400
commit282497dd6d1049b4fb963641504c2733752845a7 (patch)
tree7288d17c29fbbe9ac47ec51f6988fb954f59a361 /storage/tokudb/mysql-test/tokudb/r/mvcc-29.result
parent5052e2479e873461bebfcedbc674bbaf57d3c968 (diff)
downloadmariadb-git-282497dd6d1049b4fb963641504c2733752845a7.tar.gz
MDEV-6720 - enable connection log in mysqltest by default
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-29.result')
-rw-r--r--storage/tokudb/mysql-test/tokudb/r/mvcc-29.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result
index 5c02babaed3..994b906e2a2 100644
--- a/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result
+++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-29.result
@@ -1,10 +1,14 @@
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
# Establish connection conn1 (user = root)
+connect conn1,localhost,root,,;
DROP TABLE IF EXISTS foo;
+connection conn1;
set session transaction isolation level repeatable read;
+connection default;
set session transaction isolation level repeatable read;
create table foo (a int, b int, primary key (a))engine=TokUDB;
insert into foo values (1,1),(2,2),(3,3),(4,4),(5,5),(10,10),(20,20),(30,30),(40,40),(50,50);
+connection conn1;
begin;
select * from foo;
a b
@@ -22,6 +26,7 @@ a b
explain select * from foo where a > 1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE foo range PRIMARY PRIMARY 4 NULL 9 Using where
+connection default;
delete from foo where a > 5;
# number of rows should be 9
explain select * from foo where a > 1;
@@ -34,6 +39,7 @@ a b
3 3
4 4
5 5
+connection conn1;
# number of rows should be 9
explain select * from foo where a > 1;
id select_type table type possible_keys key key_len ref rows Extra
@@ -51,5 +57,8 @@ a b
40 40
50 50
commit;
+connection default;
+disconnect conn1;
+connection default;
set session transaction isolation level serializable;
DROP TABLE foo;