[ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Robert Hou updated DRILL-5136: ------------------------------ Summary: Some SQL statements fail due to PreparedStatement (was: Some SQL statements fail due to Prepared Statement API) > Some SQL statements fail due to PreparedStatement > ------------------------------------------------- > > Key: DRILL-5136 > URL: https://issues.apache.org/jira/browse/DRILL-5136 > Project: Apache Drill > Issue Type: Bug > Components: Client - ODBC > Affects Versions: 1.9.0 > Reporter: Robert Hou > Assignee: Laurent Goujon > > "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 yellow highlighted syntax has been added when displaying schemas > "use schema" also does not work. -- This message was sent by Atlassian JIRA (v6.3.4#6332)