[jira] [Resolved] (PHOENIX-296) Wrong query result and IO exception with DESC PK column

["Gabriel Reid (JIRA)" <ji...@apache.org>]

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