Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Fix
-
None
-
None
-
None
Description
Build tested: develop branch
MariaDB [mytest]> CREATE TABLE `t1` ( `c1` char(3) DEFAULT NULL ) ENGINE=Columnstore;
Query OK, 0 rows affected (0.214 sec)
MariaDB [mytest]> insert into t1 values ('a');
Query OK, 1 row affected (0.113 sec)
MariaDB [mytest]> alter table t1 change c1 c2 char(3);
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Changing the datatype of a column is not supported
MariaDB [mytest]> alter table t1 change c1 c2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
The same works for innodb table
The same statements also work for ColumnStore table when latin1 is used.