[MCOL-4268] ADD COLUMN FIRST throws syntax error Created: 2020-08-24  Updated: 2021-01-14

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


 Description   

ADD COLUMN FIRST 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 c0 INT FIRST;
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.