Bug #113815 MySQL auto increment ID will skip 4294967294

Submitted: 31 Jan 2024 3:35 Modified: 31 Jan 2024 10:35
Reporter: sq wu Email Updates:
Status: Patch pending 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 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.
[28 May 1:13] MySQL Admin 
Posted by developer: Bug status updated to 'Patch pending'

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.