[PHOENIX-118] Type mismatch error on upsert for unsigned_date and date

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Assignee: James R. Taylor
• Reporter: Mujtaba Chohan
• Created: 06/Mar/14 22:15
• Updated: 21/Nov/15 02:17
• Resolved: 09/Mar/14 06:52

Description

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.