1source include/have_tokudb.inc;
2set default_storage_engine='tokudb';
3disable_warnings;
4drop table if exists t;
5enable_warnings;
6
7create table t (id tinyint unsigned not null auto_increment, key(id));
8insert into t set id=0xf8;
9show warnings;
10select * from t;
11select last_insert_id() from t limit 1;
12let $i=0;
13let $n=16;
14while ($i < $n) {
15    insert into t set id=null;
16    show warnings;
17    select * from t;
18    select last_insert_id() from t limit 1;
19    inc $i;
20}
21drop table t;
22
23create table t (id smallint unsigned not null auto_increment, key(id));
24insert into t set id=0xfff8;
25show warnings;
26select * from t;
27select last_insert_id() from t limit 1;
28let $i=0;
29let $n=16;
30while ($i < $n) {
31    insert into t set id=null;
32    show warnings;
33    select * from t;
34    select last_insert_id() from t limit 1;
35    inc $i;
36}
37drop table t;
38
39create table t (id int unsigned not null auto_increment, key(id));
40insert into t set id=0xfffffff8;
41show warnings;
42select * from t;
43select last_insert_id() from t limit 1;
44let $i=0;
45let $n=16;
46while ($i < $n) {
47    insert into t set id=null;
48    show warnings;
49    select * from t;
50    select last_insert_id() from t limit 1;
51    inc $i;
52}
53drop table t;
54
55create table t (id bigint unsigned not null auto_increment, key(id));
56insert into t set id=0xfffffffffffffff8;
57show warnings;
58let $i=0;
59let $n=6;
60while ($i < $n) {
61      insert into t set id=null;
62      show warnings;
63      select * from t;
64      select last_insert_id() from t limit 1;
65      inc $i;
66}
67
68error 1264,1467;
69insert into t set id=null;
70select last_insert_id() from t limit 1;
71
72error 1264,1467;
73insert into t set id=null;
74select last_insert_id() from t limit 1;
75
76error 1264,1467;
77insert into t set id=null;
78select last_insert_id() from t limit 1;
79
80error 1264,1467;
81insert into t set id=null;
82select last_insert_id() from t limit 1;
83
84drop table t;