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

Google translator fails to update timestamp value reformatted after update

    XMLWordPrintable

    Details

    • Steps to Reproduce:
      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

      Description

      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.

        Attachments

          Activity

            People

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            lfabriko Lucie Krejcirova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: