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    error 0,167;
16    insert into t set id=null;
17    show warnings;
18    select * from t;
19    select last_insert_id() from t limit 1;
20    inc $i;
21}
22drop table t;
23
24create table t (id smallint unsigned not null auto_increment, key(id));
25insert into t set id=0xfff8;
26show warnings;
27select * from t;
28select last_insert_id() from t limit 1;
29let $i=0;
30let $n=16;
31while ($i < $n) {
32    error 0,167;
33    insert into t set id=null;
34    show warnings;
35    select * from t;
36    select last_insert_id() from t limit 1;
37    inc $i;
38}
39drop table t;
40
41create table t (id int unsigned not null auto_increment, key(id));
42insert into t set id=0xfffffff8;
43show warnings;
44select * from t;
45select last_insert_id() from t limit 1;
46let $i=0;
47let $n=16;
48while ($i < $n) {
49    error 0,167;
50    insert into t set id=null;
51    show warnings;
52    select * from t;
53    select last_insert_id() from t limit 1;
54    inc $i;
55}
56drop table t;
57
58create table t (id bigint unsigned not null auto_increment, key(id));
59insert into t set id=0xfffffffffffffff8;
60show warnings;
61let $i=0;
62let $n=6;
63while ($i < $n) {
64      insert into t set id=null;
65      show warnings;
66      select * from t;
67      select last_insert_id() from t limit 1;
68      inc $i;
69}
70
71error 1264,1467;
72insert into t set id=null;
73select last_insert_id() from t limit 1;
74
75error 1264,1467;
76insert into t set id=null;
77select last_insert_id() from t limit 1;
78
79error 1264,1467;
80insert into t set id=null;
81select last_insert_id() from t limit 1;
82
83error 1264,1467;
84insert into t set id=null;
85select last_insert_id() from t limit 1;
86
87drop table t;
88