[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?focusedWorklogId=12451730&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-12451730 ]

Steven Hawkins logged work on TEIID-5991:
-----------------------------------------

                Author: Steven Hawkins
            Created on: 14/Jul/20 12:03 PM
            Start Date: 14/Jul/20 12:03 PM
    Worklog Time Spent: 1 hour, 30 minutes 

Issue Time Tracking
-------------------

    Remaining Estimate: 2 hours, 30 minutes  (was: 4 hours)
            Time Spent: 1 hour, 30 minutes
            Worklog Id:     (was: 12451730)


> 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.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)