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

Join on document key and extra filter in the ON-clause may return incorrect result

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • None
    • Untriaged
    • 1
    • No

    Description

      Similar to MB-42745, except putting the WHERE clause filter as part of the ON clause:

      SELECT *
      FROM `travel-sample` r
      JOIN `travel-sample` a
      ON r.airlineid = META(a).id
      AND a.country = "United States"
      limit 10

      With only primary index defined on the bucket, this query returns country other than "United States" as well.

      This issue reproduces in both Cheshire-Cat as well as Mad-Hatter, which is different than MB-42745. It is not a regression. It should also reproduce in 5.5 and 6.0 lines although I've not verified that.

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-42754
          # Subject Branch Project Status CR V

          Activity

            People

              pierre.regazzoni Pierre Regazzoni
              bingjie.miao Bingjie Miao
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty