[MDEV-31812] Add switch to old_mode to disable non-locking ALTER Created: 2023-07-31  Updated: 2023-08-25  Resolved: 2023-08-16

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Variables
Fix Version/s: 11.2.1

Type: Task Priority: Critical
Reporter: Elena Stepanova Assignee: Nikita Malyavin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-16329 Engine-independent online ALTER TABLE Closed

 Description   

Add a value to old_mode variable to disable the logic introduced in MDEV-16329, e.g. NO_ONLINE_COPY_ALTER or NO_NOLOCK_COPY_ALTER.

Note: Just NO_ONLINE_ALTER doesn't work, as it's ambiguous due to the old ALTER ONLINE syntax.

The value should not be set by default.

If it is set,

  • ALTER TABLE without explicit ALGORITHM=COPY, LOCK=NONE should fall back to the old logic;
  • ALTER TABLE with explicit ALGORITHM=COPY, LOCK=NONE can be either allowed or forbidden, whichever is easier to implement.

 Comments   
Comment by Sergei Golubchik [ 2023-08-09 ]

reviewed on slack

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