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

Some SQL statements fail due to PreparedStatement

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.9.0
    • Fix Version/s: None
    • Component/s: Client - ODBC
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                laurent Laurent Goujon
                Reporter:
                rhou Robert Hou
                Reviewer:
                Robert Hou
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: