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:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:	5.7.23, 5.7.26	OS:	Any
Assigned to:		CPU Architecture:	Any

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.

Hello monty,

Thank you for the report.

regards,
Umesh

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.