|
Currently on CS 22.08.4, JSON_DETAILED does not work.
Docs: https://mariadb.com/kb/en/json_detailed/
Reproduce
CREATE TABLE `jsontest` (
|
`a` int(11) DEFAULT NULL,
|
`cVarchar` varchar(255) DEFAULT NULL,
|
`cText` MEDIUMTEXT DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3
|
|
SET @json = '
|
{"key1":"xxxx", "key2":[1, 2, 3]}
|
';
|
INSERT INTO jsontest VALUES (1, @json, @json);
|
|
SELECT cVarchar, JSON_DETAILED(cVarchar), cText, JSON_DETAILED(cText) from jsontest; -- MCS-1001: Function 'json_detailed' isn't supported.
|
|
|