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

StringToTimestamp in convert fails during DST transition hour

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major 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.

      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

        1. ArgentinaTest.java
          4 kB

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

                Created:
                Updated:
                Resolved: