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

Auto Limit Wrapping should not apply to non-select query

    XMLWordPrintableJSON

    Details

      Description

      Igor Guzenko pointed out that DRILL-6050 can cause submission of queries with incorrect syntax.
      For example, when user enters SHOW DATABASES' and after limitation wrapping SELECT * FROM (SHOW DATABASES) LIMIT 10 will be posted.
      This results into parsing errors, like:
      Query Failed: An Error Occurred org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: Encountered "( show" at line 2, column 15. Was expecting one of: <IDENTIFIER> ... .

      The fix should involve a javascript check for all non-select queries and not apply the LIMIT wrap for those queries.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kkhatua Kunal Khatua
                Reporter:
                kkhatua Kunal Khatua
                Reviewer:
                Vova Vysotskyi
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: