[teiid-issues] [JBoss JIRA] (TEIID-5991) Excel limit combined with predicates can produce wrong results

Steven Hawkins created TEIID-5991: ------------------------------------- Summary: 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 Fix For: 15.0, 13.1.2, 14.0.1 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)