1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
DROP TABLE IF EXISTS foo;
create table foo ( a int, b bigint auto_increment, primary key (a,b));
insert into foo values (1,4444000000);
insert into foo (a) values (1),(1);
select * from foo;
a b
1 4444000000
1 4444000001
1 4444000002
flush table foo;
insert into foo (a) values (1),(1);
select * from foo;
a b
1 4444000000
1 4444000001
1 4444000002
1 4444000003
1 4444000004
drop table foo;
create table foo (a bigint auto_increment, primary key (a))engine=tokudb, auto_increment=4444000000;
insert into foo values (),();
select * from foo;
a
4444000000
4444000001
DROP TABLE foo;
|