[MCOL-4240] Support non-scalar data types enum, set, json Created: 2020-08-10  Updated: 2021-02-19  Resolved: 2021-02-19

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

Type: New Feature Priority: Major
Reporter: susil.behera Assignee: Todd Stoffel (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Server version: 10.5.5-MariaDB MariaDB Server
Columnstore: 1.5.4-1

Issue Links:
Duplicate
duplicates MCOL-269 ENUM and SET not supported Closed

 Description   

At present Columnstore doesn't support non-scalar data types like enum, set, json.

CREATE TABLE t_enum(col ENUM('min','max','avg'))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.

CREATE TABLE t_set(col SET('x','y','z'))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.

CREATE TABLE t_json(col JSON)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.

Like Innodb we should support the above data types.
Generated at Thu Feb 08 02:48:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.