[
https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458730#comment-15458730
]
Ankit Singhal commented on PHOENIX-3054:
----------------------------------------
Thanks [~jamestaylor] for detailing the test failures.
Attaching v1 patch for QA run..
bq. what happens if there's a GROUP BY but there are no groups (i.e. because
the WHERE clause filters them all out)?
As per SQL standard, We should not show any row in that case because there is
no group available but I'll let Julian to confirm.
> Counting zero null rows returns an empty result set
> ---------------------------------------------------
>
> Key: PHOENIX-3054
> URL: https://issues.apache.org/jira/browse/PHOENIX-3054
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.7.0
> Reporter: Kevin Liew
> Assignee: Ankit Singhal
> Priority: Minor
> Labels: count, count(*), null, sql
> Fix For: 4.8.1
>
> Attachments: PHOENIX-3054.patch, PHOENIX-3054_v1.patch
>
>
> Execute the following query on a table with zero null cells.
> {code}
> select count(*) from table where column1 = null
> {code}
> The result set should consist of one cell with the value `0` but the result
> set is empty.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
