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

Strange difference between implicit and explicit joins with left correlation

    XMLWordPrintable

Details

    • CX Sprint 121

    Description

      Using the Don C tutorial data, the following "equivalent" queries return different results:

      SELECT * FROM customers c, (select value o from orders o where o.custid = c.custid) o
      WHERE c.custid = o.custid
      LIMIT 1;

      (returns the inner join of customers and orders as expected)

      SELECT * FROM customers c JOIN (select value o from orders o where o.custid = c.custid) o
      ON c.custid = o.custid
      LIMIT 1;

      (returns an empty result)

       

       

      Attachments

        Issue Links

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

          Activity

            People

              dmitry.lychagin Dmitry Lychagin (Inactive)
              mike.carey Mike Carey
              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