Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1238

Unparsing LIMIT without ORDER BY generates invalid SQL after validation

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.0
    • 1.8.0
    • core
    • None

    Description

      The context of the problem is the validation of queries with a LIMIT clause but no ORDER BY, e.g. "SELECT c FROM t LIMIT 2".

      The problem does not show up at parsing time but when running a validator. The generated AST includes an ORDER BY operand with an empty column list.

      When building a SQL query out of the validated AST, an ORDER BY clause is inserted before the LIMIT/FETCH clause, e.g "SELECT c FROM t ORDER BY LIMIT 2". This SQL query is not valid.

      Attachments

        Activity

          People

            ebastien Emmanuel Bastien (Inactive)
            ebastien Emmanuel Bastien (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: