[JBoss JIRA] (TEIID-4844) Google translator unexpected behavior for comparison with time
by Steven Hawkins (JIRA)
[ 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)
7 years, 8 months
[JBoss JIRA] (TEIID-4844) Google translator unexpected behavior for comparison with time
by Lucie Fabrikova (JIRA)
Lucie Fabrikova created TEIID-4844:
--------------------------------------
Summary: 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)
7 years, 8 months