[
https://issues.jboss.org/browse/TEIID-3376?page=com.atlassian.jira.plugin...
]
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)