[MCOL-4163] RENAME TABLE doesn't support UTF8 object names. Created: 2020-07-12  Updated: 2023-10-27  Resolved: 2023-10-27

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 1.4.3, 5.5.1, 6.1.1
Fix Version/s: 23.10

Type: Task Priority: Major
Reporter: Roman Assignee: Leonid Fedorov
Resolution: Won't Fix Votes: 0
Labels: beginner-friendly

Issue Links:
Problem/Incident
is caused by MCOL-3764 Renaming table causes schema out of sync Closed
Sprint: 2021-1

 Description   

RENAME doesn't handle UTF8 object names b/c of MCOL-3764.



 Comments   
Comment by David Hall (Inactive) [ 2021-01-18 ]

Roman, can you give an example?

Comment by Roman [ 2021-01-19 ]

MariaDB [test]> create table t42(i bigint)engine=columnstore;
Query OK, 0 rows affected (0.599 sec)
 
MariaDB [test]> rename table t42 to `таблица`;
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.
MariaDB [test]> rename table t42 to t43;
Query OK, 0 rows affected (0.201 sec)
 
MariaDB [test]> alter table t43 rename to `таблица`;
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.
MariaDB [test]> alter table t43 rename to t44;
Query OK, 0 rows affected (0.189 sec)

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