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

JSON_EXTRACT "to last" syntax gives wrong results

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.2.2
    • None
    • None
    • None
    • Centos 7

    Description

      I have wrong results when I use JSON_EXTRACT with "to last":

      JSON_EXTRACT(`tree_idPath`, '$[3 to last]')

      with a single row result it works, but if I have multiple rows something works something things go terribly wrong

      in json_extract_example1.png you can see the problem with the records with tree_parentId = 11956

      in json_extract_example2.png you can cry

      in json_extract_example2-single-row.png you can see that everything seems to work fine if there is a single output row

      if I use JSON_EXTRACT(`tree_idPath`, '$[3 to 123]') it works fine

      bye!

      Attachments

        1. json_extract_example1.png
          125 kB
          Claudio Friizziero
        2. json_extract_example2.png
          124 kB
          Claudio Friizziero
        3. json_extract_example2-single-row.png
          36 kB
          Claudio Friizziero

        Activity

          People

            Unassigned Unassigned
            specialfx Claudio Friizziero
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.