[DRILL-4529] SUM() with windows function result in mismatch nullability

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Component/s: Query Planning & Optimization
• Labels: limit0
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Krystal
• Reviewer: Krystal
• Created: 22/Mar/16 22:25
• Updated: 02/May/16 18:30
• Resolved: 28/Apr/16 00:12

Description

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]