No results with cross source outer join and offset only ------------------------------------------------------- Key: TEIID-4463 URL: https://issues.jboss.org/browse/TEIID-4463 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 9.1, 8.13.7, 9.0.5 TEIID-3568 introduced a regression where when only an offset is used, the pushed limit will effectively prevent any results. So a query like: select ... sourcea.tbl left outer join sourceb.tbl ... offset 1 row will push a limit 1 to the sourcea.tbl query, effectively eliminating all results.