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

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5991.
-----------------------------------
    Resolution: Done


The simplest solution is just to remove the translator based limit handling - at the worst there is some additional projection that is occurring.

> 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
>  Remaining Estimate: 4 hours
>
> 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)