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

Auto Limit Wrapping should not apply to non-select query

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      [~IhorHuzenko] 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment