Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11
Description
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. |
|