You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/03/16 08:20:48 UTC

[jira] [Resolved] (PHOENIX-247) spurious rows since 81b9e03515be36b4a3502975e379212da0493f14

     [ https://issues.apache.org/jira/browse/PHOENIX-247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-247.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> spurious rows since 81b9e03515be36b4a3502975e379212da0493f14
> ------------------------------------------------------------
>
>                 Key: PHOENIX-247
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-247
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: ryang-sfdc
>
> SELECT mycol FROM mytable WHERE round(date,'day',1) = TO_DATE('xxxx') AND foo = 'bar'
> ACTUAL: [["mycol"],[-1.593776581485206e-7],[23.98]]
> EXPECTED:  [["mycol"],[23.98]]
> SELECT mycol FROM mytable WHERE round(date,'day',1) = TO_DATE('xxxx') AND foo = 'bar'
> [["PLAN"],["CLIENT SERIAL RANGE SCAN OVER mytable 'bar'"],["    SERVER FILTER BY ROUND(DATE) = xxxx"]]
> SELECT max(mycol) FROM mytable WHERE round(date,'day',1) = TO_DATE('xxxx') AND foo = 'bar'
> ACTUAL: [["MAX(mycol)"],[-1.593776581485206e-7]]
> EXPECTED: [["MAX(mycol)"],[23.98]]
> explain SELECT max(mycol) FROM mytable WHERE round(date,'day',1) = TO_DATE('xxxx') AND foo = 'bar'
> [["PLAN"],["CLIENT PARALLEL 2-WAY RANGE SCAN OVER mytable 'bar'"],["    SERVER FILTER BY ROUND(DATE) = xxxx"],["    SERVER AGGREGATE INTO SINGLE ROW"]]



--
This message was sent by Atlassian JIRA
(v6.2#6252)