diff options
author | Sergei Golubchik <sergii@pisem.net> | 2013-09-09 13:59:38 +0200 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2013-09-09 13:59:38 +0200 |
commit | 9a3b9a541659f9d2637614df417a39d5508abeaa (patch) | |
tree | 5df6de4ffdeae387d6610f8b8462ca292b97cd7a /storage/tokudb/mysql-test/tokudb/r/mvcc-33.result | |
parent | d29f874db18068926ee899c532b25d0c8872f5dd (diff) | |
download | mariadb-git-9a3b9a541659f9d2637614df417a39d5508abeaa.tar.gz |
tokudb test suites
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-33.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/mvcc-33.result | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/mvcc-33.result b/storage/tokudb/mysql-test/tokudb/r/mvcc-33.result new file mode 100644 index 00000000000..38acca99831 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/r/mvcc-33.result @@ -0,0 +1,63 @@ +SET DEFAULT_STORAGE_ENGINE = 'tokudb'; +# Establish connection conn1 (user = root) +DROP TABLE IF EXISTS foo; +set session transaction isolation level repeatable read; +create table foo (a int, b int, c int, primary key (a), key (b))engine=TokuDB; +show create table foo; +Table Create Table +foo CREATE TABLE `foo` ( + `a` int(11) NOT NULL DEFAULT '0', + `b` int(11) DEFAULT NULL, + `c` int(11) DEFAULT NULL, + PRIMARY KEY (`a`), + KEY `b` (`b`) +) ENGINE=TokuDB DEFAULT CHARSET=latin1 +insert into foo values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500),(6,60,600),(7,70,700),(8,80,800),(9,90,900); +begin; +select * from foo; +a b c +1 10 100 +2 20 200 +3 30 300 +4 40 400 +5 50 500 +6 60 600 +7 70 700 +8 80 800 +9 90 900 +# should use key b +explain select * from foo where b=50; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE foo ref b b 5 const 1 +# should get (5,50,500) +select * from foo where b=50; +a b c +5 50 500 +set session transaction isolation level repeatable read; +replace into foo values (5,50,555); +select * from foo; +a b c +1 10 100 +2 20 200 +3 30 300 +4 40 400 +5 50 555 +6 60 600 +7 70 700 +8 80 800 +9 90 900 +# should use key b +explain select * from foo where b=50; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE foo ref b b 5 const 1 +# should get (5,50,500) +select * from foo where b=50; +a b c +5 50 500 +replace into foo values (5,50,111111111); +# should get (5,50,111111111) +select * from foo where b=50; +a b c +5 50 111111111 +set session transaction isolation level serializable; +DROP TABLE foo; |