Fix crash during expression to DXL translation in correlated NLJ (#452)
Previously, ORCA would crash when translating a NLJ tree with a empty
filter expression on the outer side. Now, we don't try to access the
empty expression.
Simple repro:
CREATE TABLE foo (
a int
);
CREATE TABLE bar (
b int
);
set optimizer_segments=128;
explain SELECT ( SELECT b FROM bar) AS bar
FROM ( select distinct
1
,max(a) as a
from foo
group by 1
) c
;
Co-authored-by: Chris Hajas <[email protected]>
Co-authored-by: Hans Zeller <[email protected]>
