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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: N/A
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      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

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

              Dates

              Created:
              Updated:

                Git Integration