Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
N/A
-
None
Description
https://mariadb.com/kb/en/alter-table/#alter-online-table states that
ALTER ONLINE TABLE ...;
[...] This statement is equivalent to the following: ALTER TABLE ... LOCK=NONE;
and then later
This statement is equivalent to the following:
ALTER TABLE ... ALGORITHM=INPLACE;
So, is ALTER ONLINE TABLE equivalent to ALTER TABLE ... LOCK=NONE, ALGORITHM=INPLACE?
If yes, it would be great to have that as a single line on top.
Currently, it makes the impression that all three statements (ALTER ONLINE, ALGORITHM=INPLACE, LOCK=NONE) are equivalent, which I'm not sure is correct. If that's the case, stating it explicitly would also help to clarify things.
(Reported on https://github.com/MariaDB/mariadb-documentation/issues/8, copied here for tracking purposes)