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

StringToTimestamp in convert fails during DST transition hour

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.1, 9.0.4
    • 8.7.7.6_2
    • Common
    • None
    • Hide
      1. Place a timestamp value in source database which is during the DST transition hour.
      2. Perform a Teiid JDBC - select * from mytable; against a dynamic VDB on that table.
      3. Receive TEIID10060 saying the timestamp is invalid, often preventing return of data to select against an entire table, due to one problematic timestamp in one row.
      Show
      Place a timestamp value in source database which is during the DST transition hour. Perform a Teiid JDBC - select * from mytable; against a dynamic VDB on that table. Receive TEIID10060 saying the timestamp is invalid, often preventing return of data to select against an entire table, due to one problematic timestamp in one row.

    Description

      Issue is due to [https://github.com/teiid/teiid/blob/master/common-core/src/main/java/org/teiid/core/types/basic/StringToTimestampTransform.java#L66 | this line] in StringToTimestampTransform.java. In particular, if you pass in a string date for a timestamp at the beginning of the DST transition hour, the result will be an hour in the future or past, so this string comparison fails, throwing TEIID10060 exception.

      Examples include:

      • America/Edmonton 2016-03-13 02:00:00
      • America/Argentina/Buenos_Aires 1991-10-20 00:00:00

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            guydavis_jira Guy Davis (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: