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

Join on document key returns incorrect results

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Yes

    Description

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

       

      The above query result includes airlines from country other than United States. Only primary on bucket is used in the plan.

      Build: Enterprise Edition 7.0.0 build 3613

      Not reproducible in Enterprise Edition 6.6.0 build 7909

       

      Attachments

        Issue Links

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

          Activity

            Build couchbase-server-7.0.0-3734 contains query commit d752189 with commit message:
            MB-42745 Save/restore filter for consideration of different join methods

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-3734 contains query commit d752189 with commit message: MB-42745 Save/restore filter for consideration of different join methods
            ajay.bhullar Ajay Bhullar added a comment -

            verified in 7.0.0-3734 the query now works as intended, Bingjie Miao if theres other related queries that would be good to try please let me know

            ajay.bhullar Ajay Bhullar added a comment - verified in 7.0.0-3734 the query now works as intended, Bingjie Miao if theres other related queries that would be good to try please let me know

            Ajay Bhullar Pierre Regazzoni This issue needs to be automated.

            mihir.kamdar Mihir Kamdar (Inactive) added a comment - Ajay Bhullar Pierre Regazzoni This issue needs to be automated.

            Closed as verified

            mihir.kamdar Mihir Kamdar (Inactive) added a comment - Closed as verified

            People

              mihir.kamdar Mihir Kamdar (Inactive)
              binh.le Binh Le
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty