[
https://issues.jboss.org/browse/TEIID-4747?page=com.atlassian.jira.plugin...
]
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#SQLR....
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)