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