Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.4.0
-
None
Description
Build tested: 1.4.0-1
[dlee@master centos7]$ cat gitversionInfo.txt
server commit:
67452bc
engine commit:
4d2a159
Autopilot test case: features.json
this case works in 1.2.4-1
The following json functions return this error:
ERROR 1178 (42000) at line 15: The storage engine for the table doesn't support IDB-1001: Function 'json_remove' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.
when the json function is use in the syntax of the following pattern:
SELECT cVarchar, JSON_ARRAY_APPEND(cVarchar, '$[0]', 5), cText, JSON_ARRAY_APPEND(cText, '$[0]', 5) from jsontest;
18 Failed JSON_ARRAY_APPEND.sql.diff.log
13 Failed JSON_ARRAY_INSERT.sql.diff.log
5 Failed JSON_COMPACT.sql.diff.log
9 Failed JSON_CONTAINS_PATH.sql.diff.log
17 Failed JSON_CONTAINS.sql.diff.log
10 Failed JSON_DEPTH.sql.diff.log
5 Failed JSON_DETAILED.sql.diff.log
17 Failed JSON_EXISTS.sql.diff.log
13 Failed JSON_EXTRACT.sql.diff.log
5 Failed JSON_INSERT.sql.diff.log
11 Failed JSON_KEYS.sql.diff.log
11 Failed JSON_LENGTH.sql.diff.log
5 Failed JSON_LOOSE.sql.diff.log
6 Failed JSON_MERGE.sql.diff.log
6 Failed JSON_QUERY.sql.diff.log
6 Failed JSON_QUOTE.sql.diff.log
11 Failed JSON_REMOVE.sql.diff.log
5 Failed JSON_REPLACE.sql.diff.log
5 Failed JSON_SEARCH.sql.diff.log
5 Failed JSON_SET.sql.diff.log
5 Failed JSON_TYPE.sql.diff.log
15 Failed JSON_UNQUOTE.sql.diff.log
9 Failed JSON_VALID.sql.diff.log
6 Failed JSON_VALUE.sql.diff.log
Attachments
Issue Links
- relates to
-
MCOL-784 JSON_REPLACE() returned a json_update does not exist error.
- Closed
-
MCOL-785 Implement DISTRIBUTED JSON functions
- Closed
-
MCOL-1358 Json Datatype not support
- Closed
-
MCOL-2099 Document supported JSON functions in KB
- Closed
-
MCOL-1548 Add feature to load the json/xml file format data with cpimport into columnstore
- Closed