You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Shivram Mani (JIRA)" <ji...@apache.org> on 2016/10/07 22:05:21 UTC

[jira] [Updated] (HAWQ-1088) Escape string constants in filters being passed to PXF via X-GP-FILTER

     [ https://issues.apache.org/jira/browse/HAWQ-1088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shivram Mani updated HAWQ-1088:
-------------------------------
    Issue Type: Bug  (was: Sub-task)
        Parent:     (was: HAWQ-964)

> Escape string constants in filters being passed to PXF via X-GP-FILTER
> ----------------------------------------------------------------------
>
>                 Key: HAWQ-1088
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1088
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: PXF
>            Reporter: Shivram Mani
>            Assignee: Lei Chang
>             Fix For: backlog
>
>
> IF a query is provided with a constant containing quotes, it messes up with the parsing logic on the java side.
> Eg: select * from nametable where name = 's"hivram';
> The filterstring being passed as X-GP-FILTER: a1c\"s"hivram\"o5
> The Filter parser now interprest the constant and the operation incorrectly and throws the below excpetion
> {code}
> ERROR:  remote component error (500) from '127.0.0.1:51200':  type  Exception report   message   unknown opcode h(104) at 6 (filter string: 'a1c&quot;s&quot;hivram&quot;o5')    description   The server encountered an internal error that prevented it from fulfilling this request.    exception   java.io.IOException: unknown opcode h(104) at 6 (filter string: 'a1c&quot;s&quot;hivram&quot;o5') (libchurl.c:884)  (seg5 localhost:40000 pid=28874)
> DETAIL:  External table hive_smallorc
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)