Bug #95232 The text of error message 1846 and the online DDL doc table should be updated
Submitted: 2 May 22:45 Modified: 3 May 8:03
Reporter: monty solomon Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.7.23, 5.7.26 OS:Any
Assigned to: CPU Architecture:Any

[2 May 22:45] monty solomon
Description:
The text of error message 1846 should be updated.

ERROR 1846 (0A000): LOCK=NONE/SHARED/EXCLUSIVE is not supported. Reason: Partition specific operations do not yet support LOCK/ALGORITHM. Try LOCK=DEFAULT.

There are some notes about valid usage of LOCK with some partition specific operations in the online DDL section.
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html#online-ddl-parti...

Some of the entries in the online DDL table are missing notes about LOCK usage and an entry for UPGRADE PARTITIONING is missing from the table.

How to repeat:
Read the documentation about valid use of LOCK with partition specific operations.

https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html#online-ddl-parti...

Suggested fix:
Update the text of error message 1846.

Update the online DDL table in the documentation to add the missing LOCK details and the missing entry.
[3 May 8:03] Umesh Shastry
Hello monty,

Thank you for the report.

regards,
Umesh