Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5991

Excel limit combined with predicates can produce wrong results

    XMLWordPrintable

Details

    • DV Sprint 66
    • 0.5

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 4 hours
                4h
                Remaining:
                Time Spent - 1 hour, 30 minutes Remaining Estimate - 2 hours, 30 minutes
                2h 30m
                Logged:
                Time Spent - 1 hour, 30 minutes Remaining Estimate - 2 hours, 30 minutes
                1h 30m