Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Tue, 6 Sep 2016 05:47:20 +0000 (UTC)
From: "Ankit Singhal (JIRA)" <jira@apache.org>
To: dev@phoenix.apache.org
Message-ID: <JIRA.12987303.1467842565000.494848.1473140840731@Atlassian.JIRA>
In-Reply-To: <JIRA.12987303.1467842565000@Atlassian.JIRA>
References: <JIRA.12987303.1467842565000@Atlassian.JIRA> <JIRA.12987303.1467842565465@arcas>
Subject: [jira] [Commented] (PHOENIX-3054) Counting zero null rows returns
 an empty result set
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 06 Sep 2016 05:47:22 -0000


    [ 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)