[teiid-issues] [JBoss JIRA] Created: (TEIID-1303) Sybase 15 Queries - Incorrect syntax on queries with FULL OUTER JOIN

Sybase 15 Queries - Incorrect syntax on queries with FULL OUTER JOIN -------------------------------------------------------------------- Key: TEIID-1303 URL: https://jira.jboss.org/browse/TEIID-1303 Project: Teiid Issue Type: Bug Affects Versions: 7.1 Reporter: Warren Gibson Assignee: Steven Hawkins 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] -- 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