Bug #95232 The text of error message 1846 and the online DDL doc table should be updated

• Submitted: 2 May 2019 22:45
• Modified: 3 May 2019 8:03
• Reporter: monty solomon
• Status: Verified
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 5.7.23, 5.7.26
• OS: Any
• CPU Architecture: Any

[2 May 2019 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 2019 8:03] MySQL Verification Team

Hello monty,

Thank you for the report.

regards,
Umesh