[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1303) Sybase issues

Wed Oct 13 12:44:39 EDT 2010

     [ https://jira.jboss.org/browse/TEIID-1303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1303.
-----------------------------------

    Resolution: Done

updated the sybase translator.  also updated the date/time/timestamp literal syntax to work with JTDS, since their escape handling seems to only turn the value into a character string and not the appropriately typed value.

> 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