Loading...

XML

Word

Printable

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.

duplicates

MB-44258 join with double intersect scan returns no rows

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