MySQL Bugs: #109445: Handler table flag HA_DUPLICATE_KEY_NOT_IN

Bug #109445	Handler table flag HA_DUPLICATE_KEY_NOT_IN_ORDER is unused
Submitted:	21 Dec 2022 5:14	Modified:	21 Dec 2022 7:44
Reporter:	Laurynas Biveinis (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Storage Engine API	Severity:	S3 (Non-critical)
Version:	8.0.31	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
No storage engine ever sets HA_DUPLICATE_KEY_NOT_IN_ORDER, and this includes 3rd party engines I was able to check. Git history suggests this was never used in Oracle MySQL, it might have been used in other related databases.

How to repeat:
Read source code

Suggested fix:
Remove it

Hello Laurynas,

Thank you for the report and feedback!

regards,
Umesh