[teiid-issues] [JBoss JIRA] (TEIID-4813) Basic support for joins in OData v2
Damien B (JIRA)
issues at jboss.org
Thu Mar 16 10:17:00 EDT 2017
Damien B created TEIID-4813:
-------------------------------
Summary: Basic support for joins in OData v2
Key: TEIID-4813
URL: https://issues.jboss.org/browse/TEIID-4813
Project: Teiid
Issue Type: Bug
Components: OData
Reporter: Damien B
Assignee: Steven Hawkins
It's half a bug, half a feature request :-)
We deal with a perticular OData almost v2 server that uses system functions disguised as entitities. Basically, "/A('b')/C" works but not "/C?$filter=foo eq 'b'". In order to have that, we've enabled the joins support on the ODataTranslator, but we still haven't the right query generated. We've traced back the origin to the optimizer:
* SELECT * FROM a join b ON a.x=b.y WHERE a.x='v'
* is optimized as SELECT <columns> FROM a join b ON a.x=b.y WHERE a.x='v' AND b.y='v'
The extra induced condition "b.y = 'v'" messes up with the URL construction. Any idea about how to proceed from there?
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list