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

StringToTimestamp in convert fails during DST transition hour

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.7.7.6_2
    • Fix Version/s: 9.1, 9.0.4
    • Component/s: Common
    • Labels:
      None
    • Steps to Reproduce:
      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                guydavis Guy Davis
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: