[
https://issues.jboss.org/browse/TEIID-4854?page=com.atlassian.jira.plugin...
]
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)