[CALCITE-1954] SqlValidator need to maintain forceNullable across joins and renaming

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Assignee: Julian Hyde
• Reporter: MinJi Kim
• Created: 17/Aug/17 22:35
• Updated: 02/Oct/17 14:31
• Resolved: 24/Aug/17 19:35

Description

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.

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)