[MCOL-4267] ADD COLUMN AFTER throws syntax error Created: 2020-08-24  Updated: 2021-11-23

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: susil.behera Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Server version: 10.5.6
MCS version: 1.5.4-1

Issue Links:
Relates
relates to MCOL-2125 BEFORE/AFTER keyword to add column in... Closed

 Description   

ADD COLUMN AFTER throws syntax error.

MariaDB [test]> CREATE TABLE t1 (c1 INT, c2 CHAR(1)) ENGINE=Columnstore;
Query OK, 0 rows affected (0.145 sec)

MariaDB [test]> ALTER TABLE t1 ADD COLUMN c12 CHAR(1) AFTER c1;
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.

This is supported by Innodb.
Generated at Thu Feb 08 02:49:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.