[teiid-issues] [JBoss JIRA] (TEIID-4747) Support queries with Oracle outer join operator (+)

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13360483#comment-13360483 ] 

Steven Hawkins commented on TEIID-4747:
---------------------------------------

To make sure, what you are requesting here is for the query engine to support incoming queries using the oracle 8 outer join syntax?  Not that you want the oracle translator to support the oracle 8 syntax, correct?

If it's the former case and the generated queries are straight-forward an approach would be to install a PreParser - https://teiid.gitbooks.io/documents/content/dev/PreParser.html and convert the + to an outer join that we will understand.

> Support queries with Oracle outer join operator (+) 
> ----------------------------------------------------
>
>                 Key: TEIID-4747
>                 URL: https://issues.jboss.org/browse/TEIID-4747
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Connector
>            Reporter: Rafael Coutinho
>            Assignee: Steven Hawkins
>            Priority: Minor
>              Labels: oracle, teiid-engine
>
> Oracle defines the 
> operator \(+\) for outer joins
> http://docs.oracle.com/cd/B28359_01/server.111/b28286/queries006.htm#SQLRF52336.
> We are trying use JDV as the source of an external product (Business Object) which uses those oracle operators. We cannot change the way that product generates the queries, and it does use the \(+\) operator, failing the integration with a JDV underlying database. 
> Is there a way to parse that outer join notation?



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)