2
drop table if exists t;
5
create table t (id tinyint unsigned not null auto_increment, key(id));
6
insert into t set id=0xf8;
9
select last_insert_id() from t limit 1;
13
insert into t set id=null;
16
select last_insert_id() from t limit 1;
23
insert into t set id=null;
24
select last_insert_id() from t limit 1;
29
create table t (id smallint unsigned not null auto_increment, key(id));
30
insert into t set id=0xfff8;
33
select last_insert_id() from t limit 1;
37
insert into t set id=null;
40
select last_insert_id() from t limit 1;
47
insert into t set id=null;
48
select last_insert_id() from t limit 1;
53
create table t (id int unsigned not null auto_increment, key(id));
54
insert into t set id=0xfffffff8;
57
select last_insert_id() from t limit 1;
61
insert into t set id=null;
64
select last_insert_id() from t limit 1;
71
insert into t set id=null;
72
select last_insert_id() from t limit 1;
77
create table t (id bigint unsigned not null auto_increment, key(id));
78
insert into t set id=0xfffffffffffffff8;
83
insert into t set id=null;
86
select last_insert_id() from t limit 1;
93
insert into t set id=null;
94
select last_insert_id() from t limit 1;
b'\\ No newline at end of file'