[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:comment-tabpanel&focusedCommentId=13050716#comment-13050716 ] 

Steven Hawkins edited comment on TEIID-3376 at 3/16/15 7:29 PM:
----------------------------------------------------------------

Added another commit to fix an issue with the SQL Server start method.  We are now defaulting the database version to an exception if not set so that the behavior is more clear.  With the old logic the translator would start with the default version and not see that the time type was available, then once it initialized the capabilities would see that the time type was available and the scenario from this issue would fail.  Also added a minor of synchronization around modifications to the executionfactory state to ensure consistency.  Although there may need to be some additional locking on the the other executionfactory method calls to ensure full consistency.


was (Author: shawkins):
Added another commit to fix an issue with the SQL Server start method.  We are now defaulting the database version to an exception if not set so that the behavior is more clear.  With the old logic the translator would start with the default version and not see that the time type was available, then once it initialized the capabilities would see that the time type was available and the scenario from this issue would fail.  Also added a minor of synchronization around modifications to the executionfactory state to ensure consistency.

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