[teiid-issues] [JBoss JIRA] (TEIID-4061) OData - request is not traslated to valid SQL

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=Order... *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}