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

Excel limit combined with predicates can produce wrong results

XMLWordPrintable

    • DV Sprint 66
    • 0.5

      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.

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

                Created:
                Updated:
                Resolved:

                  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