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

Juraj Duráni created TEIID-3376: ----------------------------------- Summary: 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 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)