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
    • Resolution: Fixed
    • Critical
    • 4.6.0, 5.0.0
    • 4.5.1
    • 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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MB-26268 Concurrency issue when using multiple Collection Operators with same variable name

          • Major - Major loss of function.
          • Closed
          For Gerrit Dashboard: MB-21720
          # Subject Branch Project Status CR V
          70321,2 MB-21720. AND of multiple predicates on the same array index. master query Status: MERGED +2 +1
          70326,2 MB-21720. AND of multiple predicates on the same array index. watson query Status: MERGED +2 +1
          70442,2 MB-21720 Test case for AND of ANY / EVERY working with array indexes master testrunner Status: MERGED +2 +1

          Activity

            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