[JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4854?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4854:
---------------------------------------
Looking at the v4 google apis, this issue will likely still be there. From the docs I
don't see a single notion of canonical RAW date/time/timestamp/numeric value. My
proposed resolution is to add an import property to turn off automatically marking tables
as updatable, and to add a doc note that updates of non-string values may behave
unpredictably - as it seems that simply adjusting the locale isn't enough that either
the automatic type detection or residual settings from the initial locale affect the
values sent from Teiid.
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)
3266
days inactive
3266
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)