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

            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