Details
-
Task
-
Resolution: Fixed
-
Minor
-
5.5.0
-
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
- relates to
-
DOC-4184 Analytics: Document which variables are in scope in JOIN clauses
- Resolved