[teiid-issues] [JBoss JIRA] (TEIID-3671) filter on child table not working

filter on child table not working --------------------------------- Key: TEIID-3671 URL: https://issues.jboss.org/browse/TEIID-3671 Project: Teiid Issue Type: Bug Components: OData Reporter: Prashanthi Kairuppala Assignee: Johnathon Lee Priority: Critical Fix For: 8.7.5, 8.11.4, 8.12 Attachments: parent_childTables.PNG Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22'