[jira] [Closed] (DRILL-8237) Limit is not pushed down to scan for MSSQL

["James Turton (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-8237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Turton closed DRILL-8237.
-------------------------------
    Fix Version/s: 1.20.2
       Resolution: Fixed

> 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
>             Fix For: 1.20.2
>
>
> [~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)