Bug #105871 | auto_increment_offset and auto_increment_increment not effiect | ||
---|---|---|---|
Submitted: | 12 Dec 2021 13:58 | Modified: | 13 Dec 2021 13:18 |
Reporter: | HULONG CUI | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[12 Dec 2021 13:58]
HULONG CUI
[13 Dec 2021 13:18]
MySQL Verification Team
Hi Mr. CUI, Thank you for your bug report. We managed to repeat it fully, although we tried many different approaches: Variable_name Value auto_increment_increment 1 auto_increment_offset 5 innodb_autoinc_lock_mode 2 id name 1 A 2 B 3 C Simply, auto_increment_offset does not work any more with InnoDB. Severity is reduced, because of the very easy workaround, which is to set only first value explicitly. Verified as reported.