Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.0
-
None
Description
[root@localhost mariadb-columnstore-server]# git show
commit 594ef1807a5d6cba45cf7c2bed03cccdc32f177a
Merge: a5f191d ce815f9
Author: David.Hall <david.hall@mariadb.com>
Date: Thu Jun 8 10:12:50 2017 -0500
[root@localhost mariadb-columnstore-engine]# git show
commit ebaf24473c0838989bf504a7c104c511b876fcb8
Author: david hill <david.hill@mariadb.com>
Date: Fri Jun 16 16:53:48 2017 -0500
As of testing time, ColumnStore does not supported distributed distributed JSON functions. JSONs are being executed by MariaDB front end (vtablemode=0).
MariaDB [mytest]> SELECT cVarchar, JSON_REPLACE(cVarchar, '$.B[1]', 4), cText, JSON_REPLACE(cText, '$.B[1]', 4) from jsontest;
ERROR 1305 (42000): FUNCTION mytest.json_update does not exist
create table script:
DROP TABLE IF EXISTS jsontest;
CREATE TABLE jsontest (
cInt INT,
cVarchar VARCHAR(300),
cText TEXT)
ENGINE=columnstore;
test script:
- ---------------------------------------------------------------------- #
- The string is already a JSON string so we can insert it into the table
- ---------------------------------------------------------------------- #
TRUNCATE TABLE jsontest;
SET @json = ' { "A": 1, "B": [2, 3]}';
SELECT @json;
INSERT INTO jsontest VALUES (1, @json, @json);
#
SELECT JSON_REPLACE(@json, '$.B[1]', 4);
#
SELECT * FROM jsontest;
SELECT cVarchar, JSON_REPLACE(cVarchar, '$.B[1]', 4), cText, JSON_REPLACE(cText, '$.B[1]', 4) from jsontest;
#
TRUNCATE TABLE jsontest;
#
Attachments
Issue Links
- relates to
-
MCOL-599 JSON Functions
- Closed
-
MCOL-785 Implement DISTRIBUTED JSON functions
- Closed
-
MCOL-1358 Json Datatype not support
- Closed
-
MCOL-1548 Add feature to load the json/xml file format data with cpimport into columnstore
- Closed
-
MCOL-2099 Document supported JSON functions in KB
- Closed
-
MCOL-3479 JSON functions return "can only be used in the outermost...." error messages
- Closed