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)