[DRILL-5136] Some SQL statements fail due to PreparedStatement

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.9.0
• Component/s: Client - ODBC
• Assignee: Laurent Goujon
• Reporter: Robert Hou
• Reviewer: Robert Hou
• Created: 19/Dec/16 21:57
• Updated: 15/Mar/17 04:22

Description

"show schemas" does not work.

SQL>show schemas
1: SQLPrepare = [MapR][Drill] (1040) Drill failed to execute the query: show schemas
[30029]Query execution error. Details:[
PARSE ERROR: Encountered "( show" at line 1, column 15.
Was expecting one of:
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"LATERAL" ...
"(" "WITH" ...
"(" "+" ...
"(" "-" ...
"(" <UNSIGNED_INTEGER_LITERAL> ...
"(" <DECIMAL_NUMERIC_LITERAL> ...
"(" <APPROX_NUMERIC (1040) SQLSTATE=HY000

The query profile shows this SQL statement is being executed:

SELECT * FROM (show schemas) LIMIT 0

The blue text has been added when displaying schemas

"use schema" also does not work.

Issue Links

• links to: GitHub Pull Request #698