By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test (id smallint not null auto_increment primary key, val int) auto_increment=32765
insert into test (val) values (1),(2)
insert into test (val) values (3),(4)
Failed to read auto-increment value from storage engine
insert into test (val) values (5)
insert into test (val) values (6)
Duplicate entry '32767' for key 'test.PRIMARY'
select * from test
| id | val |
|---|---|
| 32765 | 1 |
| 32766 | 2 |
| 32767 | 5 |