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)