Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-21720

AND of ANY / EVERY does not work with array indexes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 4.5.1
    • 4.6.0, 5.0.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      In this forum post, there is an AND of ANY expressions, both of which use the same array index. The generated plan is incorrect, leading to incorrect results.

      https://forums.couchbase.com/t/additional-help-with-n1ql-dynamic-attribute-key/10806

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            gerald Gerald Sangudi (Inactive) added a comment - Spock http://review.couchbase.org/#/c/70321/ 4.6 http://review.couchbase.org/#/c/70326/

            Build 4.6.0-3527 contains query commit 5513fcedf32372bbb3d0bfa547626c80a672f5d0 with commit message:
            MB-21720. AND of multiple predicates on the same array index.
            https://github.com/couchbase/query/commit/5513fcedf32372bbb3d0bfa547626c80a672f5d0

            build-team Couchbase Build Team added a comment - Build 4.6.0-3527 contains query commit 5513fcedf32372bbb3d0bfa547626c80a672f5d0 with commit message: MB-21720 . AND of multiple predicates on the same array index. https://github.com/couchbase/query/commit/5513fcedf32372bbb3d0bfa547626c80a672f5d0

            Build 4.7.0-1362 contains query commit 84a21595e2ccff17a551a06a829176fae5769b33 with commit message:
            MB-21720. AND of multiple predicates on the same array index.
            https://github.com/couchbase/query/commit/84a21595e2ccff17a551a06a829176fae5769b33

            build-team Couchbase Build Team added a comment - Build 4.7.0-1362 contains query commit 84a21595e2ccff17a551a06a829176fae5769b33 with commit message: MB-21720 . AND of multiple predicates on the same array index. https://github.com/couchbase/query/commit/84a21595e2ccff17a551a06a829176fae5769b33

            @Gerald:the exact query reported in the forum will not work with this change for 4.6 since object_pairs and object_inner_pairs return "key","val" pairs instead of "key", "value" pairs as per MB-20128
            Opening a doc bug for same.

            Prerna.Manaktala Prerna Manaktala (Inactive) added a comment - - edited @Gerald:the exact query reported in the forum will not work with this change for 4.6 since object_pairs and object_inner_pairs return "key","val" pairs instead of "key", "value" pairs as per MB-20128 Opening a doc bug for same.

            Added test case yesterday but wanted Wayne to link test case gerrit review to this bug.
            https://issues.couchbase.com/browse/CBD-1937.
            If it will take time,I will close this issue.

            Prerna.Manaktala Prerna Manaktala (Inactive) added a comment - - edited Added test case yesterday but wanted Wayne to link test case gerrit review to this bug. https://issues.couchbase.com/browse/CBD-1937 . If it will take time,I will close this issue.

            Build 4.7.0-1386 contains testrunner commit 43ee3257818540431429d70ea9691828ae20013a with commit message:
            MB-21720 Test case for AND of ANY / EVERY working with array indexes
            https://github.com/couchbase/testrunner/commit/43ee3257818540431429d70ea9691828ae20013a

            build-team Couchbase Build Team added a comment - Build 4.7.0-1386 contains testrunner commit 43ee3257818540431429d70ea9691828ae20013a with commit message: MB-21720 Test case for AND of ANY / EVERY working with array indexes https://github.com/couchbase/testrunner/commit/43ee3257818540431429d70ea9691828ae20013a

            Build 4.6.1-3804 contains testrunner commit 43ee3257818540431429d70ea9691828ae20013a with commit message:
            MB-21720 Test case for AND of ANY / EVERY working with array indexes
            https://github.com/couchbase/testrunner/commit/43ee3257818540431429d70ea9691828ae20013a

            build-team Couchbase Build Team added a comment - Build 4.6.1-3804 contains testrunner commit 43ee3257818540431429d70ea9691828ae20013a with commit message: MB-21720 Test case for AND of ANY / EVERY working with array indexes https://github.com/couchbase/testrunner/commit/43ee3257818540431429d70ea9691828ae20013a

            People

              Prerna.Manaktala Prerna Manaktala (Inactive)
              gerald Gerald Sangudi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty