[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=13360818#comment-13360818 ] 

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

Yes, it was added with TEIID-3369 in 8.11.  There was also a thought at some point to allow a PreParsers to be VDB scoped as well, but that has not been added yet.

> 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)