phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3054) Counting zero null rows returns an empty result set
Date Tue, 06 Sep 2016 05:47:20 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15466502#comment-15466502
] 

Ankit Singhal commented on PHOENIX-3054:
----------------------------------------

Thanks [~giacomotaylor] for the review.

bq. Were the ProductMetricsIT tests failing because there were no iterators in the merge sort?
Yes, it is failing because of no iterators in the merge sort.

bq. Is this the same, but slightly more efficient?
Yes, It is more efficient, did the change during commit.

Committed to 4.8, 4.x and master branches.

> 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.9.0, 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)

Mime
View raw message