Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-8090

LIMIT clause is pushed down to an invalid OFFSET-FETCH clause for MS SQL Server

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.19.0
    • 1.20.0
    • None
    • None

    Description

      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.

      Attachments

        Activity

          People

            volodymyr Vova Vysotskyi
            dzamo James Turton
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: