[MCOL-321] support mariadb syntax for alter table online Created: 2016-09-23  Updated: 2023-07-02  Resolved: 2023-07-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 1.0.3
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: David Thompson (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-130 ALTER TABLE does not support changing... Closed
relates to MCOL-694 ALTER TABLE doesn't support AFTER Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

ColumnStore uses the following syntax for online alter table (as at the time when InfiniDB added support for of online alter table, MySQL 5.1 did not support it):

select calonlinealter('alter table foo add column col7 int;');
 
alter table foo add column col7 int comment 'schema sync only'

MariaDB 10.1.x introduced support for this syntax:

ALTER [ONLINE] TABLE tbl_name
 
    alter_specification [, alter_specification]

ColumnStore should be aligned to use the MariaDB 10.1.x syntax and calonlinealter should be deprecated.

 Comments   
Comment by Todd Stoffel (Inactive) [ 2023-07-02 ]

The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket.

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