[
https://issues.apache.org/jira/browse/PHOENIX-296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-296.
----------------------------------
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.
> Wrong query result and IO exception with DESC PK column
> -------------------------------------------------------
>
> Key: PHOENIX-296
> URL: https://issues.apache.org/jira/browse/PHOENIX-296
> Project: Phoenix
> Issue Type: Task
> Reporter: mujtaba
>
> Sharanya reported the following issues:
> 1) Date comparison queries seems to be throwing “Unexpected IO Exception” .
> Example: select * from TESTRUN where START_DATE<CURRENT_DATE(). Where
> START_DATE (DATE Data type ) is part of the primary key with no order
> specified while defining schema. However leading key is stored sorted DESC.
>
> Error Message:
> Error: ERROR 101 (0800):Unexpected IO exception
> SQLState: 08000
> ErrorCode:101
> 2) For columns that are stored as DESC , the query for runId<5 returns a
> results set for runs having Ids 6,7,8 etc instead of 1,2,3,4. This seems to
> be counterintuitive
> [Unit test added for both issues]
> (https://github.com/forcedotcom/phoenix/commit/ecfdcd29b16022aab8072cd3f8f2638824a9ba64)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
