Improve installation procedure and reduce SQL limitations (MCOL-3686)

[MCOL-128] ALTER TABLE conversion to columnstore fails Created: 2016-06-12  Updated: 2020-03-26  Resolved: 2020-02-11

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 1.4.3

Type: Sub-Task Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: susil.behera
Resolution: Fixed Votes: 2
Labels: None

Issue Links:
Duplicate
is duplicated by MCOL-779 storage engine for the table doesn't ... Closed
Relates
relates to MCOL-3785 CTAS (Create Table as Select) with CO... Closed
Sprint: 2020-1, 2020-2, 2020-4, 2020-5, 2020-6, 2020-7

 Description   

mysql> create table t2(c1 int);
Query OK, 0 rows affected (0.01 sec)

mysql> alter table t2 engine=columnstore;
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.

 Comments   
Comment by dic (Inactive) [ 2017-06-20 ]

I have the similar problem:
MariaDB [employees]> ALTER TABLE salaries ENGINE = ColumnStore;
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.

Comment by Elias maturana [ 2019-10-09 ]

hi, They have found a solution to this problem

regards

Comment by Andrew Hutchings (Inactive) [ 2020-01-20 ]

PR opened, pending regression suite test creation.

Comment by Andrew Hutchings (Inactive) [ 2020-01-21 ]

PR in engine and regression suite to add ALTER TABLE to/from ColumnStore and CTAS.

Comment by Patrick LeBlanc (Inactive) [ 2020-01-24 ]

Merged it into develop-1.4. Merge into develop TBD.

Comment by susil.behera [ 2020-02-11 ]

Build verified: 1.4.3-1

MariaDB [(none)]> CREATE TABLE db1.t1 (c1 int) ENGINE=innodb;
Query OK, 0 rows affected (0.015 sec)

MariaDB [(none)]> ALTER TABLE db1.t1 ENGINE=columnstore;
Query OK, 0 rows affected (0.179 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [(none)]> SHOW CREATE TABLE db1.t1;
--------------------------------------------------------------------------------------------------+

Table Create Table

--------------------------------------------------------------------------------------------------+

t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1

--------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [(none)]> ALTER TABLE db1.t1 ENGINE=innodb;
Query OK, 0 rows affected (0.338 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [(none)]> SHOW CREATE TABLE db1.t1;
---------------------------------------------------------------------------------------------+

Table Create Table

---------------------------------------------------------------------------------------------+

t1 CREATE TABLE `t1` (
`c1` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

---------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [(none)]>

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