mvcc-9.result 1.33 KB
Newer Older
1
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
Zardosht Kasheff's avatar
Zardosht Kasheff committed
2 3 4 5 6 7 8 9 10
# Establish connection conn1 (user = root)
DROP TABLE IF EXISTS foo;
create table foo (a int, b varchar (100), primary key (a)) engine=TokuDB;
show create table foo;
Table	Create Table
foo	CREATE TABLE `foo` (
  `a` int(11) NOT NULL DEFAULT '0',
  `b` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`a`)
11
) ENGINE=TokuDB DEFAULT CHARSET=latin1
Zardosht Kasheff's avatar
Zardosht Kasheff committed
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
set session transaction isolation level repeatable read;
begin;
select * from foo;
a	b
replace into foo values (1, "a");
set session transaction isolation level repeatable read;
begin;
select * from foo;
a	b
1	a
replace into foo values (1,"ab"), (2, "ab");
set session transaction isolation level repeatable read;
begin;
select * from foo;
a	b
1	ab
2	ab
replace into foo values (1,"abc"),(2,"abc"),(3, "abc");
set session transaction isolation level repeatable read;
begin;
select * from foo;
a	b
1	abc
2	abc
3	abc
replace into foo values (1,"abcd"),(2,"abcd"),(3, "abcd"),(4, "abcd");
set session transaction isolation level repeatable read;
begin;
select * from foo;
a	b
1	abcd
2	abcd
3	abcd
4	abcd
select * from foo;
a	b
Zardosht Kasheff's avatar
Zardosht Kasheff committed
48
commit;
Zardosht Kasheff's avatar
Zardosht Kasheff committed
49 50 51
select * from foo;
a	b
1	a
Zardosht Kasheff's avatar
Zardosht Kasheff committed
52
commit;
Zardosht Kasheff's avatar
Zardosht Kasheff committed
53 54 55 56
select * from foo;
a	b
1	ab
2	ab
Zardosht Kasheff's avatar
Zardosht Kasheff committed
57
commit;
Zardosht Kasheff's avatar
Zardosht Kasheff committed
58 59 60 61 62
select * from foo;
a	b
1	abc
2	abc
3	abc
Zardosht Kasheff's avatar
Zardosht Kasheff committed
63
commit;
Zardosht Kasheff's avatar
Zardosht Kasheff committed
64 65 66 67 68 69
select * from foo;
a	b
1	abcd
2	abcd
3	abcd
4	abcd
Zardosht Kasheff's avatar
Zardosht Kasheff committed
70
commit;
Zardosht Kasheff's avatar
Zardosht Kasheff committed
71 72
set session transaction isolation level serializable;
DROP TABLE foo;