[teiid-issues] [JBoss JIRA] Updated: (TEIID-1303) Sybase issues
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Wed Oct 13 11:07:39 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-1303:
----------------------------------
Summary: Sybase issues (was: Sybase 15 Queries - Incorrect syntax on queries with FULL OUTER JOIN)
Fix Version/s: 7.1.1
Description:
The following query and error is an example of Sybase 15 queries with a FULL OUTER JOIN. Sybase does not support FULL OUTER JOIN and a Translator change is needed.
SELECT BQT2.SmallB.IntKey, y.DoubleNum FROM BQT2.SmallB FULL OUTER JOIN (SELECT IntKey, DoubleNum FROM BQT1.MediumA) AS y ON BQT2.SmallB.IntKey = y.IntKey ORDER BY IntKey, DoubleNum
- RDBMS_Test_Queries_9500_TestQuery113 Error Code:102 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:102 Message:Error Code:102 Message:'Incorrect syntax near 'FULL'.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.IntKey AS c_0, g_1.DoubleNum AS c_1 FROM SmallB g_0 FULL OUTER JOIN MediumA g_1 ON g_0.IntKey = g_1.IntKey ORDER BY c_0, c_1]
Our Sybase 15 instance also does not seem to support the 123 conversion style for datetime. We should use a different expression for the string conversion.
was:
The following query and error is an example of Sybase 15 queries with a FULL OUTER JOIN. Sybase does not support FULL OUTER JOIN and a Translator change is needed.
SELECT BQT2.SmallB.IntKey, y.DoubleNum FROM BQT2.SmallB FULL OUTER JOIN (SELECT IntKey, DoubleNum FROM BQT1.MediumA) AS y ON BQT2.SmallB.IntKey = y.IntKey ORDER BY IntKey, DoubleNum
- RDBMS_Test_Queries_9500_TestQuery113 Error Code:102 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:102 Message:Error Code:102 Message:'Incorrect syntax near 'FULL'.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.IntKey AS c_0, g_1.DoubleNum AS c_1 FROM SmallB g_0 FULL OUTER JOIN MediumA g_1 ON g_0.IntKey = g_1.IntKey ORDER BY c_0, c_1]
Component/s: JDBC Connector
> Sybase issues
> -------------
>
> Key: TEIID-1303
> URL: https://jira.jboss.org/browse/TEIID-1303
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 7.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Fix For: 7.1.1
>
>
> The following query and error is an example of Sybase 15 queries with a FULL OUTER JOIN. Sybase does not support FULL OUTER JOIN and a Translator change is needed.
> SELECT BQT2.SmallB.IntKey, y.DoubleNum FROM BQT2.SmallB FULL OUTER JOIN (SELECT IntKey, DoubleNum FROM BQT1.MediumA) AS y ON BQT2.SmallB.IntKey = y.IntKey ORDER BY IntKey, DoubleNum
> - RDBMS_Test_Queries_9500_TestQuery113 Error Code:102 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:102 Message:Error Code:102 Message:'Incorrect syntax near 'FULL'.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.IntKey AS c_0, g_1.DoubleNum AS c_1 FROM SmallB g_0 FULL OUTER JOIN MediumA g_1 ON g_0.IntKey = g_1.IntKey ORDER BY c_0, c_1]
> Our Sybase 15 instance also does not seem to support the 123 conversion style for datetime. We should use a different expression for the string conversion.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list