[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14528951#comment-14528951 ]
Victoria Markman commented on DRILL-2411: ----------------------------------------- Verified fixed in: 0.9.0 #Sun May 03 18:33:43 EDT 2015 git.commit.id.abbrev=10833d2 Tests are checked in under: Functional/Passing/aggregation/bugs/drill-2411-[1234].sql > Scalar SUM/AVG over empty result set returns no rows instead of NULL > -------------------------------------------------------------------- > > Key: DRILL-2411 > URL: https://issues.apache.org/jira/browse/DRILL-2411 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Relational Operators > Reporter: Victoria Markman > Assignee: Mehant Baid > Priority: Critical > Fix For: 1.0.0 > > > Queries below should return NULL: > {code} > 0: jdbc:drill:schema=dfs> select sum(a2) from t2 where 1=0; > +------------+ > | EXPR$0 | > +------------+ > +------------+ > No rows selected (0.08 seconds) > 0: jdbc:drill:schema=dfs> select avg(a2) from t2 where 1=0; > +------------+ > | EXPR$0 | > +------------+ > +------------+ > No rows selected (0.074 seconds) > {code} > When grouped, result is correct: > {code} > 0: jdbc:drill:schema=dfs> select a2, sum(a2) from t2 where 1=0 group by a2; > +------------+------------+ > | a2 | EXPR$1 | > +------------+------------+ > +------------+------------+ > No rows selected (0.11 seconds) > {code} > I'm not convinced and it is not very intuitive that correct result should be > NULL, but this is what postgres returns and Aman thinks NULL is the correct > behavior :) -- This message was sent by Atlassian JIRA (v6.3.4#6332)