[MCOL-5536] alter table renaming column failed when utf8 is used Created: 2023-07-19  Updated: 2023-10-27  Resolved: 2023-10-27

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

Type: Bug Priority: Critical
Reporter: Daniel Lee (Inactive) Assignee: Leonid Fedorov
Resolution: Won't Fix Votes: 0
Labels: 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.


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