[IGNITE-14356] Regression when using derived table in LEFT JOIN

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.10
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Vladimir Ermakov
• Reporter: Lukas Eder
• Created: 19/Mar/21 13:38
• Updated: 01/Nov/21 10:59
• Resolved: 01/Nov/21 10:59

Description

This used to work in 2.9.1 and no longer does in 2.10.0:

 

CREATE TABLE t (i int PRIMARY KEY, j int);
INSERT INTO t VALUES (1, 1);
SELECT * 
FROM t AS t1
LEFT JOIN (SELECT * FROM t WHERE false) AS t2
ON t1.i = t2.i

 

It should result in 1 row as the LEFT JOIN should have no effect, but the result set is empty as if t2 were inner joined.

Issue Links

• duplicates: IGNITE-14358 Regression when referencing aliased constant from derived table