[DRILL-6474] Queries with ORDER BY and OFFSET (w/o LIMIT) do not return any rows

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Labels: ready-to-commit
• Assignee: Timothy Farkas
• Reporter: Timothy Farkas
• Reviewer: Aman Sinha
• Created: 06/Jun/18 21:35
• Updated: 14/Jun/18 04:13
• Resolved: 14/Jun/18 04:13

Description

This is easily reproduced with the following test

    final ClusterFixtureBuilder builder = new ClusterFixtureBuilder(baseDirTestWatcher);

    try (ClusterFixture clusterFixture = builder.build();
         ClientFixture clientFixture = clusterFixture.clientFixture()) {
      clientFixture.testBuilder()
        .sqlQuery("select name_s10 from `mock`.`employees_100000` order by name_s10 offset 100")
        .expectsNumRecords(99900)
        .build()
        .run();
    }

That fails with

java.lang.AssertionError:
Expected :99900
Actual :0

Issue Links

• links to: GitHub Pull Request #1313