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

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.