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

[Warren Gibson (JIRA)]

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