[MCOL-1358] Json Datatype not support Created: 2018-04-23  Updated: 2022-11-14  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.3
Fix Version/s: Icebox

Type: New Feature Priority: Minor
Reporter: Nicola Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None
Environment:

Vmware with two um modules and three pm server

Issue Links:
Relates
relates to MCOL-784 JSON_REPLACE() returned a json_update... Closed
relates to MCOL-785 Implement DISTRIBUTED JSON functions Closed
relates to MCOL-1548 Add feature to load the json/xml file... Closed
relates to MCOL-1548 Add feature to load the json/xml file... Closed
relates to MCOL-2099 Document supported JSON functions in KB Closed
relates to MCOL-3479 JSON functions return "can only be us... Closed
Epic Link: Columnstore JSON Compatibility

 Description   

Hello to all
I'm trying to create a table with a json column, MariaDb 10.2 supports type json (alias longtext) but on mariadb columnstore I'm wrong saying that it does not support this type of format.
Is this feature supported? because Mariadb columstore is based on MariaDB 10.2 and I assumed that this data type was supported.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-07-10 ]

Alias for longtext

Comment by Matt [ 2019-10-15 ]

I totally agree. This is a great feature and it should be supported.

Matt
https://coding-bootcamps.com/
https://myhsts.org/
https://dcwebmakers.com/

Comment by Todd Stoffel (Inactive) [ 2021-09-03 ]

As Andrew stated above, JSON datatype is simply an alias for LONGTEXT. Use LONGTEXT with Columnstore Engine.

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:28:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.