[
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"s"hivram"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"s"hivram"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)