[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman updated DRILL-2411: ------------------------------------ Priority: Critical (was: Major) > 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: Steven Phillips > Priority: Critical > Fix For: 0.9.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)