From 9a3b9a541659f9d2637614df417a39d5508abeaa Mon Sep 17 00:00:00 2001
From: Sergei Golubchik <sergii@pisem.net>
Date: Mon, 9 Sep 2013 13:59:38 +0200
Subject: tokudb test suites

---
 storage/tokudb/mysql-test/tokudb/r/mvcc-33.result | 63 +++++++++++++++++++++++
 1 file changed, 63 insertions(+)
 create mode 100644 storage/tokudb/mysql-test/tokudb/r/mvcc-33.result

(limited to 'storage/tokudb/mysql-test/tokudb/r/mvcc-33.result')

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;
-- 
cgit v1.2.1