[teiid-issues] [JBoss JIRA] (TEIID-4844) Google translator unexpected behavior for comparison with time
[
https://issues.jboss.org/browse/TEIID-4844?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4844:
---------------------------------------
Since we already throw an exception with non-supported constructs with update/delete (such
as like), then we'll do that for predicates involving time and timestamp as well. A
workaround would be to mark the columns as unsearchable - but then that would affect the
select case as well.
In version 4 of the api, there isn't even an option to support the sq parameter, so
this will all need rethought with a later revision - we'll likely need to introduce a
concept of searchable only for select or find a different way of processing
update/delete.
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)