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

Google translator fails to update timestamp value reformatted after update

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 10.0, 8.12.11.6_4
    • 9.3, 8.12.10.6_3
    • Misc. Connectors
    • None
    • Hide
      1. INSERT INTO SmallA (IntKey, StringNum, TimestampValue) values (100, '100', {ts '1991-03-18 15:17:01.0'}

        )

      2. UPDATE SmallA SET StringNum='1' WHERE IntKey=100 // format after this: 03/18/1991 15:17:01
      3. UPDATE SmallA SET StringNum='2' WHERE IntKey=100
      Show
      INSERT INTO SmallA (IntKey, StringNum, TimestampValue) values (100, '100', {ts '1991-03-18 15:17:01.0'} ) UPDATE SmallA SET StringNum='1' WHERE IntKey=100 // format after this: 03/18/1991 15:17:01 UPDATE SmallA SET StringNum='2' WHERE IntKey=100

      Cell of type timestamp is reformatted after an update. Data inserted from teiid are in format "yyyy-mm-dd hh:mm:ss[.fffffffff]", which is reformatted to "dd/mm/yyyy hh:mm:ss[.fffffffff]". Subsequent update of such row throws exception "Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp".

      Google spreadsheet locale was UK, timezone was set to Berlin.

        1. gs-reformatted-timestamp.log
          3 kB
          Lucie Krejcirova

            rhn-engineering-shawkins Steven Hawkins
            lfabriko@redhat.com Lucie Krejcirova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: