Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Duplicate
-
1.16.0
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
- is caused by
-
DRILL-6050 Provide a limit to number of rows fetched for a query in UI
-
- Resolved
-
- is required by
-
DRILL-7048 Implement JDBC Statement.setMaxRows() with System Option
-
- Resolved
-
- links to