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)