hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shivram Mani (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1088) Escape string constants in filters being passed to PXF via X-GP-FILTER
Date Fri, 07 Oct 2016 22:01:20 GMT
Shivram Mani created HAWQ-1088:
----------------------------------

             Summary: 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: Sub-task
          Components: PXF
            Reporter: Shivram Mani
            Assignee: Lei Chang


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)

Mime
View raw message