Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26726

Limitations on path value for JSON_VALUE function (and maybe others) are not described

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • N/A
    • Documentation
    • None

    Description

      JSON_VALUE and JSON_EXTRACT descriptions both show path as the 2nd argument in syntax:

      JSON_VALUE(json_doc, path)

      JSON_EXTRACT(json_doc, path[, path] ...)

      JSON_EXTRACT additionally says that

      The path expression be a JSONPath expression as supported by MariaDB

      (possibly a typo, but understandable).

      JSON_VALUE says nothing about path meaning.

      It appears that for JSON_VALUE path must be explicit, without wildcards. If so, it should be mentioned in the documentation.
      Possibly there are other functions with the same limitation.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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