[MCOL-1941] Add support for ALTER TABLE ... CONVERT TO CHARACTER SET Created: 2018-11-15  Updated: 2022-11-05  Resolved: 2022-11-05

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

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-21504 Collation: Create shared library for ... Closed

 Description   

If you try to execute the following:

CREATE TABLE tab (
 
`id` int(11) DEFAULT NULL,
 
`str` varchar(50) DEFAULT NULL
 
) ENGINE=Columnstore DEFAULT CHARSET=latin1;
 
ALTER TABLE tab CONVERT TO CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

You'll get an error:

MariaDB [db1]> CREATE TABLE tab (
 
    -> `id` int(11) DEFAULT NULL,
 
    -> `str` varchar(50) DEFAULT NULL
 
    -> ) ENGINE=Columnstore DEFAULT CHARSET=latin1;
 
Query OK, 0 rows affected (0.19 sec)
 
 
 
MariaDB [db1]> ALTER TABLE tab CONVERT TO CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
 
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 Todd Stoffel (Inactive) [ 2022-11-05 ]

This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.

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