MinJi Kim created CALCITE-1954:
----------------------------------
Summary: SqlValidator need to maintain forceNullable across joins
and renaming
Key: CALCITE-1954
URL: https://issues.apache.org/jira/browse/CALCITE-1954
Project: Calcite
Issue Type: Bug
Reporter: MinJi Kim
Assignee: Julian Hyde
In the following query below, SqlValidator return rowtype with the second
column as NOT NULL. Since this is a left outer join, it should be nullable.
{code}
select * from
(select row_number() over (order by sal) from emp) as emp1(r1)
left outer join
(select dense_rank() over(order by sal) from emp) as emp2(r2)
on (emp1.r1 = emp2.r2)
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
