[MCOL-694] ALTER TABLE doesn't support AFTER - Jira

XML

Word

Printable

Details

Type: New Feature
Status: Closed (View Workflow)
Priority: Major
Resolution: Won't Fix
Affects Version/s: 1.0.8, 1.1.3
Fix Version/s: 23.10.0
Component/s: DMLProc
Labels:
- beginner-friendly

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/

Attachments

Issue Links

is duplicated by

MCOL-4663 CLONE - ALTER TABLE doesn't support AFTER

Closed

relates to

MCOL-130 ALTER TABLE does not support changing data type

Closed

MCOL-321 support mariadb syntax for alter table online

Closed

Activity

People

Assignee:: Todd Stoffel (Inactive)

Reporter:: Geoff Montee (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2017-05-01 19:02

Updated:: 2024-10-03 15:51

Resolved:: 2023-10-25 12:28

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.