November 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3170) Change build to include spring framework jar dependencies for WS translator

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3170?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3170: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1151047|https://bugzilla.redhat.com/show_bug.cgi?id=1151047] from ASSIGNED to MODIFIED > Change build to include spring framework jar dependencies for WS translator > --------------------------------------------------------------------------- > > Key: TEIID-3170 > URL: https://issues.jboss.org/browse/TEIID-3170 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.7.1 > > > The "org.springframework.spring" module and dependent jars will be added to the kit. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3170) Change build to include spring framework jar dependencies for WS translator

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3170?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3170: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1151047|https://bugzilla.redhat.com/show_bug.cgi?id=1151047] from MODIFIED to ASSIGNED > Change build to include spring framework jar dependencies for WS translator > --------------------------------------------------------------------------- > > Key: TEIID-3170 > URL: https://issues.jboss.org/browse/TEIID-3170 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.7.1 > > > The "org.springframework.spring" module and dependent jars will be added to the kit. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3219) Excel Translator Wrong Result From Columns With Interleaved Null Values

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3219?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3219: ------------------------------------- [~kylin] If you already have the fix, please send the pull request along with your above test code > Excel Translator Wrong Result From Columns With Interleaved Null Values > ----------------------------------------------------------------------- > > Key: TEIID-3219 > URL: https://issues.jboss.org/browse/TEIID-3219 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Attachments: artifacts.zip > > > When querying a column which has a null value somewhere in it, the result set is missing all the rows under the null value in the xlsx file. When querying more columns, the result set is missing some values only if there is a row, where both columns contains null value. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3223. ----------------------------------- Fix Version/s: 8.7.1 8.10 Resolution: Done Updated the sql server translator to use a literal cast instead. > 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)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3223: --------------------------------------- Actually that is still happening with their latest driver as well, so that will need a fix. To recap it is expected with SQL Server 2005 and older that if you have a source model with a time type, that we will convert that to the representative datetime since those versions of SQL Server lack a time type - this is somewhat legacy behavior as we should avoid doing type manipulation at the source model as it's more correct to introduce a view layer. For SQL Server 2008 and later the logic expects the source time to be a time value is currently putting non-bind literal timestamp values in as the JDBC escape value {t '....'} - which does work against JTDS. However the SQL Server 4.0 driver up to the latest (4.0.2206.100) will convert the time escape instead into a timestamp and cause an exception. > 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 > > 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)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-3223: ------------------------------------- SQL Server 2012, and VDB looks just like in 'Steps to Reproduce'. I do not know if jdbc driver is older or not. I am using same as we use for all tests. > 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 > > 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)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3223: --------------------------------------- If you are using an older sqljdbc4 jar, then you could see that exception as the driver will convert the time literal to a datetime value. > 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 > > 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)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3223: --------------------------------------- What source are you testing against? And what does your dynamic vdb look like? > 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 > > 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)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Juraj Duráni edited comment on TEIID-3223 at 11/18/14 9:16 AM: --------------------------------------------------------------- I have changed data type in SQL Server 2012 DB to time. Now I am getting an exception (dynamic VDB): com.microsoft.sqlserver.jdbc.SQLServerException: The data types time and datetime are incompatible in the less than operator. was (Author: jdurani): I have changed data type in SQL Server 2012 DB to time (dynamic VDB). Now I am getting an exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data types time and datetime are incompatible in the less than operator. > 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 > > 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)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Juraj Duráni edited comment on TEIID-3223 at 11/18/14 9:16 AM: --------------------------------------------------------------- I have changed data type in SQL Server 2012 DB to time (dynamic VDB). Now I am getting an exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data types time and datetime are incompatible in the less than operator. was (Author: jdurani): I have changed data type in SQL Server 2012 DB to time. Now I am getting an exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data types time and datetime are incompatible in the less than operator. > 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 > > 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)

9 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2014