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;