Vova Vysotskyi created DRILL-8237:
-------------------------------------
Summary: Limit is not pushed for MSSQL
Key: DRILL-8237
URL: https://issues.apache.org/jira/browse/DRILL-8237
Project: Apache Drill
Issue Type: Bug
Reporter: Vova Vysotskyi
Assignee: Vova Vysotskyi
[~dzamo] has noticed that the following test case will fail
{code:java}
@Test
public void testLimitPushDownWithOffset() throws Exception {
String query = "select person_id, first_name from mssql.dbo.person limit
100 offset 10";
queryBuilder()
.sql(query)
.planMatcher()
.include("Jdbc\\(.*SELECT TOP \\(110\\)")
.include("Limit\\(")
.match();
}
{code}
because the limit wasn't pushed down.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
