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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.7.23, 5.7.26 OS:Any
Assigned to: CPU Architecture:Any

[2 May 2019 22:45] monty solomon
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.

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.


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.