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

JSON_EXISTS returns always 1 if it is used range notation for json path

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 10.9.1
    • JSON
    • None

    Description

      Test: (value in range 3 to 4 is absent)

      SET @json= '[
      		 
                   [1, {"key1": "value1"}, 3],
      		 
                   [false, 5, 6],
      		 
                   [7, 8, [9, {"key2": 2}, 11]],
      		 
                   [15, 1.34, [14], ["string1", [16, {"key1":[1,2,3,[4,5,6]]}, 18]]],
      		 
                   [19, 20],
      		 
                   21, 22
      		 
                  ]';
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][3]');
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][4]');
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][3 to 4]');

      Expected result:

      SET @json= '[
      		 
                   [1, {"key1": "value1"}, 3],
      		 
                   [false, 5, 6],
      		 
                   [7, 8, [9, {"key2": 2}, 11]],
      		 
                   [15, 1.34, [14], ["string1", [16, {"key1":[1,2,3,[4,5,6]]}, 18]]],
      		 
                   [19, 20],
      		 
                   21, 22
      		 
                  ]';
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][3]');
      		 
      JSON_EXISTS(@json, '$[2][2][3]')
      		 
      0
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][4]');
      		 
      JSON_EXISTS(@json, '$[2][2][4]')
      		 
      0
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][3 to 4]');
      		 
      JSON_EXISTS(@json, '$[2][2][3 to 4]')
      		 
      0

      Actual result:

      SET @json= '[
      		 
                   [1, {"key1": "value1"}, 3],
      		 
                   [false, 5, 6],
      		 
                   [7, 8, [9, {"key2": 2}, 11]],
      		 
                   [15, 1.34, [14], ["string1", [16, {"key1":[1,2,3,[4,5,6]]}, 18]]],
      		 
                   [19, 20],
      		 
                   21, 22
      		 
                  ]';
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][3]');
      		 
      JSON_EXISTS(@json, '$[2][2][3]')
      		 
      0
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][4]');
      		 
      JSON_EXISTS(@json, '$[2][2][4]')
      		 
      0
      		 
      SELECT JSON_EXISTS(@json, '$[2][2][3 to 4]');
      		 
      JSON_EXISTS(@json, '$[2][2][3 to 4]')
      		 
      1

      Attachments

        Issue Links

          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

            Ascending order - Click to sort in descending order
            rucha174 Rucha Deodhar added a comment - - edited

            Patch: https://github.com/MariaDB/server/commit/c66ce14fca08999d18f2db09097631591d3b12cb

            rucha174 Rucha Deodhar added a comment - - edited Patch: https://github.com/MariaDB/server/commit/c66ce14fca08999d18f2db09097631591d3b12cb
            holyfoot Alexey Botchkov added a comment -

            ok to push.

            holyfoot Alexey Botchkov added a comment - ok to push.
            rucha174 Rucha Deodhar added a comment -

            Pushed to https://github.com/MariaDB/server/tree/bb-10.9-MDEV-27911

            rucha174 Rucha Deodhar added a comment - Pushed to https://github.com/MariaDB/server/tree/bb-10.9-MDEV-27911

            People

              rucha174 Rucha Deodhar
              lstartseva Lena Startseva
              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.