[
https://issues.apache.org/jira/browse/PHOENIX-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-118.
----------------------------------
Resolution: Fixed
> 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)
