[teiid-issues] [JBoss JIRA] (TEIID-3376) SQL Server 2008/2012 - incompatible data types in comparison after cast/convert

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3376.
-----------------------------------
    Fix Version/s: 8.11
       Resolution: Done


Added handling for the cast to time from timestamp for 2008+

> SQL Server 2008/2012 - incompatible data types in comparison after cast/convert
> -------------------------------------------------------------------------------
>
>                 Key: TEIID-3376
>                 URL: https://issues.jboss.org/browse/TEIID-3376
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1
>         Environment: OS: fedora 20
> java: oracle 1.7
> arch: x86_64
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> If user want to cast/convert timestamp-value to time and then use it in comparison, Teiid throws an Exception:
> "SQLServerException: The data types datetime and time are incompatible in the greater than operator."
> Expected behavior:
> The query should return correct result as the SQL Server is able to handle similar queries (teiid does not have any problem with same query with oracle, postgres, mysql,...)



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)