You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Mujtaba Chohan (JIRA)" <ji...@apache.org> on 2014/03/06 23:15:43 UTC

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

Mujtaba Chohan created PHOENIX-118:
--------------------------------------

             Summary: 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


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)