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

Query using JSON_EXTRACT on a json object containing a nested array returns different result using or not using WHERE

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • JSON
    • docker image 10.10.2

    Description

      You can see the description on stackoverflow:

      https://stackoverflow.com/questions/74910526/mariadb-query-using-json-extract-on-a-json-object-containing-a-nested-array-retu

      One comment says that this (probably) bug was introduced in version 10.9 because he tried something similar on dbfiddle.

      Thanks in advance

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30304 Json Range only affects first row of the result set

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-27911 Implement range notation for json path

          • Major - Major loss of function.
          • Closed

          Activity

            alice Alice Sherepa added a comment - - edited

            Thank you for the report!
            it is a similar bug to MDEV-30304, the reason is not WHERE, but only the first row is returned correctly. I added a comment there so that the test case would be checked.

            alice Alice Sherepa added a comment - - edited Thank you for the report! it is a similar bug to MDEV-30304 , the reason is not WHERE, but only the first row is returned correctly. I added a comment there so that the test case would be checked.

            People

              Unassigned Unassigned
              darcome Luca
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.