Excel limit combined with predicates can produce wrong results -------------------------------------------------------------- Key: TEIID-5991 URL: https://issues.redhat.com/browse/TEIID-5991 Project: Teiid Issue Type: Bug Components: Misc. Connectors Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Major Fix For: 15.0, 13.1.2, 14.0.1 Original Estimate: 4 hours Time Spent: 1 hour, 30 minutes Remaining Estimate: 2 hours, 30 minutes A query such as "select FirstName, ROW_ID from Sheet1 where ROW_ID != 15 LIMIT 1,3" against the test names.xls will produce 2 rows as a result when 3 are expected. This is because the row limit and where predicate are applied conjunctively, rather than the limit on top of the predicate result.