[DRILL-8237] Limit is not pushed down to scan for MSSQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.2
• Assignee: Vova Vysotskyi
• Reporter: Vova Vysotskyi
• Created: 26/May/22 18:26
• Updated: 27/May/22 05:39
• Resolved: 27/May/22 05:39

Description

dzamo has noticed that the following test case will fail

  @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();
  }

because the limit wasn't pushed down.