MySQL Bugs: #101898: Delayed index creation and table schemas with AUTO

Bug #101898	Delayed index creation and table schemas with AUTO_INCREMENT
Submitted:	7 Dec 2020 18:43	Modified:	7 Dec 2020 22:21
Reporter:	Rolf Martin-Hoster	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: mysqlpump Command-line Client	Severity:	S3 (Non-critical)
Version:	Ver 1.0.0 Distrib 5.7.26-29, for Linux	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When a table schema is defined with an AUTO_INCREMENT the related index must be defined at table creation. When '--defer-table-indexes' is specified, those required indexes are not in the table creation and the restore will fail.

How to repeat:
Create a table with AUTO_INCREMENT in a normal index, dump it, load it.

Suggested fix:
Don't delay AUTO_INCREMENTED

Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=84186 and https://bugs.mysql.com/bug.php?id=93074.