[MCOL-1105] Can not add a column anywhere other than the end of the table Created: 2017-12-12  Updated: 2017-12-12  Resolved: 2017-12-12

Status: Closed
Project: MariaDB ColumnStore
Component/s: Documentation
Affects Version/s: 1.1.2
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Sasha V Assignee: Andrew Hutchings (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Documentation on ALTER TABLE syntax includes FIRST and AFTER:
https://mariadb.com/kb/en/library/columnstore-alter-table
However, my test queries:

ALTER TABLE test.t1 ADD COLUMN testSmallInt SMALLINT FIRST;
 
ALTER TABLE test.t1 ADD COLUMN testInt INT AFTER a;

fail with

Error Code: 1178. 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.

It appears that MariaDB ColumnStore is unable to add a column anywhere other than the end of the table (i.e. same limitation as InfiniDB has).

Could the documentation be updated accordingly?

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-12-12 ]

Documentation fixed.

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