[
https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458730#comment-15458730
]
Ankit Singhal edited comment on PHOENIX-3054 at 9/2/16 3:03 PM:
----------------------------------------------------------------
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)?
Checked with some databases also, We should not show any row in that case
because there is no group available but I'll let Julian to confirm.
was (Author: [email protected]):
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)
