Bug #113815 MySQL auto increment ID will skip 4294967294
Submitted: 31 Jan 3:35 Modified: 31 Jan 10:35
Reporter: sq wu Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[31 Jan 3:35] sq wu
Description:
MySQL auto increment ID will skip 4294967294

How to repeat:
1.create table 
create table t(id int unsigned auto_increment primary key) auto_increment=4294967290;

2.add data
insert into t values(null);
insert into t values(null);
insert into t values(null);
insert into t values(null);
insert into t values(null);
insert into t values(null);

3.query data
select *from t;
[31 Jan 10:35] MySQL Verification Team
Hi Mr. wu,

Thank you for your bug report.

We have been able to verify it with latest release 8.0.36:

ERROR 1062 (23000) at line 15: Duplicate entry '4294967295' for key 't.PRIMARY'
id
4294967290
4294967291
4294967292
4294967293
4294967295
id
4294967290
4294967291
4294967292
4294967293
4294967294
4294967295

This is now a verified bug report.