Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3479

JSON functions return "can only be used in the outermost...." error messages

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.4.0
    • 22.08.1
    • ExeMgr
    • 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

          Activity

            People

              Unassigned Unassigned
              dleeyh Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.