[teiid-issues] [JBoss JIRA] (TEIID-4061) OData - request is not traslated to valid SQL
RH Bugzilla Integration (JIRA)
issues at jboss.org
Thu Mar 17 18:51:04 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13178764#comment-13178764 ]
RH Bugzilla Integration commented on TEIID-4061:
------------------------------------------------
Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1316503|https://bugzilla.redhat.com/show_bug.cgi?id=1316503] from NEW to MODIFIED
> OData - request is not traslated to valid SQL
> ---------------------------------------------
>
> Key: TEIID-4061
> URL: https://issues.jboss.org/browse/TEIID-4061
> Project: Teiid
> Issue Type: Sub-task
> Components: OData
> Reporter: Juraj Duráni
> Assignee: Ramesh Reddy
> Fix For: 9.0, 8.12.5
>
>
> *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$filter=Orders_FK0/$count%20lt%202
> *Result:* TEIID31118 Element "g30.customerid" is not defined by any relevant group.
> *SQL:*
> {code:sql}
> SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.customerid = g31.idcust) < ? ORDER BY g30.idcust
> {code}
> *Correct SQL:*
> {code:sql}
> SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.idcust = g31.customerid) < ? ORDER BY g30.idcust
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list