[jira] [Updated] (PHOENIX-118) Type mismatch error on upsert for unsigned_date and date

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor updated PHOENIX-118:
---------------------------------

    Attachment: typeFixes.patch

> Type mismatch error on upsert for unsigned_date and date
> --------------------------------------------------------
>
>                 Key: PHOENIX-118
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-118
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: Mujtaba Chohan
>            Assignee: James Taylor
>             Fix For: 3.0.0
>
>         Attachments: typeFixes.patch
>
>
> Following upsert statement fails for unsigned_date
> upsert into TEST values (TO_DATE('2013-01-04 01:01:01'));
> Error:ERROR 203 (22005): Type mismatch. DATE and UNSIGNED_DATE for expression: '2013-01-04 01:01:01.000' in column CREATED_DATE (state=22005,code=203)
> Uncovered during 2.x > 3.0 upgrade when date type is changed to unsigned_date type.



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