[ https://issues.apache.org/jira/browse/DRILL-8090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vova Vysotskyi reassigned DRILL-8090: ------------------------------------- Assignee: Vova Vysotskyi > LIMIT clause is pushed down to an invalid OFFSET-FETCH clause for MS SQL > Server > -------------------------------------------------------------------------------- > > Key: DRILL-8090 > URL: https://issues.apache.org/jira/browse/DRILL-8090 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.19.0 > Reporter: James Turton > Assignee: Vova Vysotskyi > Priority: Major > > In MS SQL Server, ORDER BY is mandatory for using OFFSET and FETCH clauses. > Drill (or Calcite) does not include an ORDER BY clause in the SQL it > generates for a LIMIT clause. -- This message was sent by Atlassian Jira (v8.20.1#820001)