[jira] [Created] (CALCITE-1954) SqlValidator need to maintain forceNullable across joins and renaming

["MinJi Kim (JIRA)" <ji...@apache.org>]

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)