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