1
#--source include/have_tokudb.inc
2
SET DEFAULT_STORAGE_ENGINE='TokuDB';
5
DROP TABLE IF EXISTS t1, t2;
8
CREATE TABLE t1 (a int);
11
insert into t1 values(1);
12
delete from t1 where a=1;
18
create table t1 (a int, b int, primary key (a));
21
# do some rollback tests, all nesting levels are 2
24
insert into t1 values (1,10);
30
insert into t1 values (1,10);
34
update t1 set b=b+5 where a=1;
40
insert into t1 values (1,10),(2,20);
42
delete from t1 where a > 1;
47
insert into t1 values (1,10),(2,20),(3,30);
53
# do some commit tests
56
insert into t1 values (4,40),(5,50),(6,60);
62
insert into t1 values (7,70);
64
insert into t1 values (8,80), (9,90), (1,10), (10,100);
65
insert into t1 values (11,110);
71
insert into t1 values (7,70);
73
insert into t1 values (8,80), (9,90), (1,10), (10,100);
74
insert into t1 values (11,110);
79
alter table t1 add index (b);
81
insert ignore into t1 values (1,10),(2,20),(3,30),(1,10),(4,40);
85
insert ignore into t1 values (5,50),(3,30),(6,60),(7,70);
91
insert ignore into t1 values (5,50),(3,30),(6,60),(7,70);