[jira] [Commented] (DRILL-2411) Scalar SUM/AVG over empty result set returns no rows instead of NULL

2015-05-05 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14528951#comment-14528951 ] Victoria Markman commented on DRILL-2411: - Verified fixed in: 0.9.0 #Sun May 03

[jira] [Commented] (DRILL-2411) Scalar SUM/AVG over empty result set returns no rows instead of NULL

2015-03-25 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14380831#comment-14380831 ] Victoria Markman commented on DRILL-2411: - This behavior is SQL standard: If no

[jira] [Commented] (DRILL-2411) Scalar SUM/AVG over empty result set returns no rows instead of NULL

2015-03-09 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14353974#comment-14353974 ] Mehant Baid commented on DRILL-2411: Yes it is a different function, however the base

[jira] [Commented] (DRILL-2411) Scalar SUM/AVG over empty result set returns no rows instead of NULL

2015-03-09 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14353860#comment-14353860 ] Jinfeng Ni commented on DRILL-2411: --- The plan for the query seems to be fine, and I feel