diff options
author | Sergey Vojtovich <svoj@mariadb.org> | 2016-03-25 20:51:22 +0400 |
---|---|---|
committer | Sergey Vojtovich <svoj@mariadb.org> | 2016-03-31 10:11:16 +0400 |
commit | 282497dd6d1049b4fb963641504c2733752845a7 (patch) | |
tree | 7288d17c29fbbe9ac47ec51f6988fb954f59a361 /storage/tokudb/mysql-test/tokudb/r/mvcc-29.result | |
parent | 5052e2479e873461bebfcedbc674bbaf57d3c968 (diff) | |
download | mariadb-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.result | 9 |
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; |