[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3223:
---------------------------------------
With SQL Server 2008+ and without this fix, the following will not work:
source type, Teiid type, driver
datetime, time, sql server - incorrect results
time, time, sql server - exception
So without the fix, you would have to use the JTDS driver or with a source type of
datetime use a Teiid type of timestamp (which is what the dynamic vdbs were doing).
An issue with time in WHERE clause - SQLServer
----------------------------------------------
Key: TEIID-3223
URL: https://issues.jboss.org/browse/TEIID-3223
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1
Environment: OS: fedora20
arch: x86_64
java: oracle 1.7
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Fix For: 8.7.1, 8.10
Teiid is not able to manage WHERE clause with time value.
translator: sqlserver
base DB: SQL Server 2012/2008/2005
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
3641
days inactive
3641
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)