[
https://issues.apache.org/jira/browse/DRILL-8237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vova Vysotskyi updated DRILL-8237:
----------------------------------
Summary: Limit is not pushed down to scan for MSSQL (was: Limit is not
pushed for MSSQL)
> Limit is not pushed down to scan 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
> Priority: Major
>
> [~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)
