You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Vova Vysotskyi (Jira)" <ji...@apache.org> on 2022/05/26 18:27:00 UTC

[jira] [Created] (DRILL-8237) Limit is not pushed for MSSQL

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)