Details
-
New Feature
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Do
-
None
Description
I noticed we don't have BEFORE/AFTER keyword for columnstore table to add column at specific position. It would be nice if we have this option in columnstore table like in InnoDB engine.
That's how it works in InnoDB.
MariaDB [abc]> CREATE TABLE innodb_test ( A int, C int) ENGINE=InnoDB;
Query OK, 0 rows affected (0.02 sec)
MariaDB [abc]> ALTER TABLE innodb_test ADD COLUMN B INT AFTER A;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [abc]> show create table innodb_test\G
Table: cs_test
Create Table: CREATE TABLE `cs_test` (
`A` int(11) DEFAULT NULL,
`B` int(11) DEFAULT NULL,
`C` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
while the same error out in CS engine.
ALTER TABLE cs_test ADD COLUMN B INT AFTER A;
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.