[MDEV-33333] Unclear documentation for "ALTER ONLINE TABLE" Created: 2024-01-30  Updated: 2024-01-30  Resolved: 2024-01-30

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Ian Gilfillan Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: 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)



 Comments   
Comment by Sergei Golubchik [ 2024-01-30 ]

where do you see that " This statement is equivalent to the following: ALTER TABLE ... ALGORITHM=INPLACE;" ?

Comment by Ian Gilfillan [ 2024-01-30 ]

This issue was created on GitHub in July, it's been fixed since then.

Generated at Thu Feb 08 10:38:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.