[
https://issues.apache.org/jira/browse/DRILL-6474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sorabh Hamirwasia updated DRILL-6474:
-------------------------------------
Labels: (was: ready-to-commit)
> Queries with ORDER BY and OFFSET (w/o LIMIT) do not return any rows
> -------------------------------------------------------------------
>
> Key: DRILL-6474
> URL: https://issues.apache.org/jira/browse/DRILL-6474
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Timothy Farkas
> Assignee: Timothy Farkas
> Priority: Major
> Fix For: 1.14.0
>
>
> This is easily reproduced with the following test
> {code}
> 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();
> }
> {code}
> That fails with
> java.lang.AssertionError:
> Expected :99900
> Actual :0
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
