drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4529) SUM() with windows function result in mismatch nullability
Date Tue, 22 Mar 2016 22:26:25 GMT
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)

Mime
View raw message