Description of problem: *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:* 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 *Correct 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
Ramesh Reddy <rareddy> updated the status of jira TEIID-4061 to Coding In Progress
Ramesh Reddy <rareddy> updated the status of jira TEIID-4061 to Resolved
Verified. Teiid returns correct result.
Steven Hawkins <shawkins> updated the status of jira TEIID-4061 to Closed