[MCOL-3479] JSON functions return "can only be used in the outermost...." error messages Created: 2019-09-04 Updated: 2023-02-04 Resolved: 2023-02-04 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | 1.4.0 |
| Fix Version/s: | 22.08.1 |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Epic Link: | Columnstore JSON Compatibility | ||||||||||||||||||||||||
| Description |
|
Build tested: 1.4.0-1 [dlee@master centos7]$ cat gitversionInfo.txt 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 |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2019-10-02 ] |
|
This likely isn't fixable in 1.4 without a huge amount of work. Workaround is to use columnstore_processing_handlers_fallback. |
| Comment by Roman [ 2023-02-04 ] |
|
Has been resolved by |