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

[BP to 7.0.4] - LEFT JOIN breaks with between operator on non-existing attribute

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Yes

    Description

      Steps to reproduce:

      a.  Create bucket customer, scope s1, and collections c1 and c2.

      b.  Add this doc in c1 and c2:

      {"id": 1}

      c.  create these indexes:

       

      CREATE PRIMARY INDEX ON `customer`.`s1`.`c1`;
      		 
      CREATE INDEX `idx1` ON `customer`.`s1`.`c2`(`id`);

       

      d.  run this query:

      SELECT lhs.id
      		 
      FROM customer.s1.c1 lhs
      		 
      LEFT JOIN customer.s1.c2 rhs 
      		 
      ON lhs.id = rhs.id
      		 
          AND rhs.x between 1 and 10

      No documents are output.

      e.  run this query:

      SELECT lhs.id
      		 
      FROM customer.s1.c1 lhs
      		 
      LEFT JOIN customer.s1.c2 rhs 
      		 
      ON lhs.id = rhs.id
      		 
          AND rhs.x >= 1 and rhs.x <= 10

      Now I get 1 doc.  

      Attachments

        Issue Links

          is a backport of

          Bug - A problem which impairs or prevents the functions of the product. MB-51736 LEFT JOIN breaks with between operator on non-existing attribute

          • Major - Major loss of function.
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-48601 LEFT JOIN on collections returns wrong results

          • Major - Major loss of function.
          • Closed
          For Gerrit Dashboard: MB-51739
          # Subject Branch Project Status CR V
          173594,2 MB-51739 Properly handle derived filters in post-join filter determination cheshire-cat query Status: MERGED +2 +1

          Activity

            People

              ajay.bhullar Ajay Bhullar
              bingjie.miao Bingjie Miao
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty