[teiid-issues] [JBoss JIRA] (TEIID-4844) Google translator unexpected behavior for comparison with time
RH Bugzilla Integration (JIRA)
issues at jboss.org
Tue Aug 15 10:22:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13449495#comment-13449495 ]
RH Bugzilla Integration commented on TEIID-4844:
------------------------------------------------
Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1460484|https://bugzilla.redhat.com/show_bug.cgi?id=1460484] from NEW to MODIFIED
> 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
> Fix For: 9.3, 8.12.x-6.4, 9.2.2
>
>
> 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)
More information about the teiid-issues
mailing list