Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1928

PSQL emulation layer has problems converting timestamp '0000

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 7.6
    • None
    • None

    Description

      When we attempt to run the following query against our teiid 7.6 install we get an error about converting timestamps. Note this only seems to affect the PSQL emulation layer, jdbc layer is fine

      EngVDBF=> select * from orgchart2s.history;
ERROR:  Error Code:S1009 Message:OrgChart2DS: Error Code:S1009 Message:Unexpected exception while translating results: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
DETAIL:  org.teiid.jdbc.TeiidSQLException: Error Code:S1009 Message:OrgChart2DS: Error Code:S1009 Message:Unexpected exception while translating results: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
EngVDBF=>

      It looks like there is a problem converting a timestamp of '0000-00-00 00:00:00'

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            graeme.gillies Graeme Gillies (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: