[
https://issues.apache.org/jira/browse/PHOENIX-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14616055#comment-14616055
]
Dumindu Buddhika commented on PHOENIX-2063:
-------------------------------------------
It seems that reset() gets called once at each ResultSet.next() call . For this
query it gets called only once as ResulSet.next() is called only once to get
the result. That may be the reason for not resetting at each row for the COUNT
DISTINCT?
> Row value constructor doesn't work when used in COUNT DISTINCT
> --------------------------------------------------------------
>
> Key: PHOENIX-2063
> URL: https://issues.apache.org/jira/browse/PHOENIX-2063
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Assignee: Dumindu Buddhika
> Attachments: PHOENIX-2063-v1.patch
>
>
> As a workaround for PHOENIX-2062, I tried the following query:
> {code}
> SELECT COUNT(DISTINCT (a.col1, b.col2)) ...
> {code}
> However, this always returns 1 as the COUNT DISTINCT which is wrong.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
