[teiid-issues] [JBoss JIRA] (TEIID-4844) Google translator unexpected behavior for comparison with time

[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)