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

Incorrect result with Subquery as right-hand side of ANSI JOIN, and subquery references CTE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • 6.6.2, 7.0.0
    • 6.6.1
    • query
    • Untriaged
    • 1
    • Yes

    Description

      See CBSE-9639.

      WITH a1 AS ([{"EffectiveDate": "2021-01-27"}, {"EffectiveDate": "2021-01-28"}, {"EffectiveDate": "2021-01-29"}])
      		 
      SELECT l, r
      		 
      FROM a1 AS l
      		 
      JOIN (SELECT d.EffectiveDate FROM a1 AS d) AS r
      		 
      ON l.EffectiveDate = r.EffectiveDate

      The above query should return 3 documents, in 6.6.1 it only returns 1.
      This works in 6.5.1, returns 3 documents.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MB-44258 join with double intersect scan returns no rows

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          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