[MCOL-694] ALTER TABLE doesn't support AFTER Created: 2017-05-01  Updated: 2024-01-25  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.0.8, 1.1.3
Fix Version/s: 23.10

Type: New Feature Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Fix Votes: 0
Labels: beginner-friendly

Issue Links:
Duplicate
is duplicated by MCOL-4663 CLONE - ALTER TABLE doesn't support A... Closed
Relates
relates to MCOL-130 ALTER TABLE does not support changing... Closed
relates to MCOL-321 support mariadb syntax for alter tabl... Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

If someone attempts to execute a command like the following:

ALTER TABLE tab ADD COLUMN `col2` INT AFTER `col1`;

Then they will see errors like the following:

ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

At least at the time that this JIRA issue is being created, I don't see this limitation mentioned here:

https://mariadb.com/kb/en/mariadb/ddl-statements-that-differ-for-columnstore/

And I do see that "AFTER" is shown as a part of the grammar of "ALTER TABLE" here:

https://mariadb.com/kb/en/mariadb/columnstore-alter-table/

 Comments   
Comment by David Thompson (Inactive) [ 2017-05-01 ]

kb article has been updated to remove AFTER syntax for now.

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