[ https://issues.apache.org/jira/browse/DRILL-4529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal closed DRILL-4529. -------------------------- git.commit.id.abbrev=5705d45 Verified that bug is fixed. > 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 > Labels: limit0 > Fix For: 1.7.0 > > > 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)