drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5136) Some SQL statements fail due to Prepared Statement API
Date Mon, 19 Dec 2016 23:11:58 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15762586#comment-15762586
] 

ASF GitHub Bot commented on DRILL-5136:
---------------------------------------

GitHub user superbstreak opened a pull request:

    https://github.com/apache/drill/pull/698

    DRILL-5136: Server unable to prepare non SELECT queries

    Currently, the server makes every incoming queries a limit 0 query during server prepare.
This is causing some non select queries to fail.
    
    We need to add an additional check to determine if the query is a SELECT query before
wrapping it with LIMIT 0.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/superbstreak/drill DRILL-5136

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/drill/pull/698.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #698
    
----
commit 1856ca01c68ae841d90f8ed27ec577c708cec4f7
Author: Rob Wu <superbstreak@users.noreply.github.com>
Date:   2016-12-19T22:58:20Z

    DRILL-5136: Server unable to prepare some non SELECT queries
    
    Currently, the server makes every incoming queries a limit 0 query during server prepare.
This is causing some non select queries to fail.
    
    We need to add an additional check to determine if the query is a SELECT query before
wrapping it with LIMIT 0.

----


> Some SQL statements fail due to Prepared Statement API
> ------------------------------------------------------
>
>                 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)

Mime
View raw message