Bug #113815 MySQL auto increment ID will skip 4294967294

• Submitted: 31 Jan 2024 3:35
• Modified: 31 Jan 2024 10:35
• Reporter: sq wu
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 8.0
• OS: Any
• CPU Architecture: Any

[31 Jan 2024 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 2024 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.