Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-118

Type mismatch error on upsert for unsigned_date and date

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.0
    • Labels:
      None

      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.

        Attachments

        1. typeFixes.patch
          176 kB
          James Taylor

          Activity

            People

            • Assignee:
              jamestaylor James Taylor
              Reporter:
              mujtabachohan Mujtaba Chohan
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: