[teiid-issues] [JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update

[Lucie Fabrikova (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13396710#comment-13396710 ] 

Lucie Fabrikova commented on TEIID-4854:
----------------------------------------

If timestamp value is reformatted, query 'SELECT TimestampValue from SmallA' produces two different results depending on sheet content:
1. If there is no other row (only header and this one), exception is thrown 'Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp'
2. if there is present some other row with correctly formatted timestamp value, null is return for reformatted TimeStampValue

> Google translator fails to update timestamp value reformatted after update
> --------------------------------------------------------------------------
>
>                 Key: TEIID-4854
>                 URL: https://issues.jboss.org/browse/TEIID-4854
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 9.3, 8.12.10.6_3
>            Reporter: Lucie Fabrikova
>            Assignee: Steven Hawkins
>             Fix For: 9.3
>
>         Attachments: gs-reformatted-timestamp.log
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)