Krystal created DRILL-4529:
------------------------------

             Summary: SUM() with windows function result in mismatch nullability
                 Key: DRILL-4529
                 URL: https://issues.apache.org/jira/browse/DRILL-4529
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Krystal
            Assignee: Sean Hsuan-Yi Chu


git.commit.id.abbrev=cee5317

select 
        sum(1)  over w sum1, 
        sum(5)  over w sum5,
        sum(10) over w sum10
from 
        j1_v
where 
        c_date is not null
window w as (partition by c_date);

Output from test:
limit 0: [columnNoNulls, columnNoNulls, columnNoNulls]
regular: [columnNullable, columnNullable, columnNullable]




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to