[JBoss JIRA] (TEIID-4844) Google translator unexpected behavior for comparison with time
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- 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-4844?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4844:
---------------------------------------
This appears to be more nuance with the google api. Filtering a list feed with the sq
parameter already requires different syntax than a regular sheet query. It appears here a
timeofday value can't have a predicate against it at all - no literal value I have
tried will work.
We have only two options it would appear. Either mark the time column as unsearchable, or
to not use the list feed logic for update/delete - and instead use the query api to obtain
and modify rows.
Google translator unexpected behavior for comparison with time
--------------------------------------------------------------
Key: TEIID-4844
URL: https://issues.jboss.org/browse/TEIID-4844
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12.10.6_3
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
Comparison operators <, <=, >, >=, =, <> work unexpectedly for
'time' datatype, foreign table has column 'timevalue time OPTIONS (NATIVE_TYPE
'TIMEOFDAY')'.
I created view with column 'TimeValue time', inserted data in format
'10:57:23'.
I run queries like 'DELETE FROM smalla WHERE TimeValue < {t
'10:57:23'}'
* <, <>, <= deletes all rows, including rows that should be left
* >, >=, = deletes no rows
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
2841
days inactive
2841
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)