Laszlo Pinter created HIVE-20551:
------------------------------------

             Summary: Create PreparedStatement query dynamically when IN clause 
is used
                 Key: HIVE-20551
                 URL: https://issues.apache.org/jira/browse/HIVE-20551
             Project: Hive
          Issue Type: Bug
            Reporter: Laszlo Pinter
            Assignee: Laszlo Pinter


In the MetaStoreDirectSql class when IN clause is used, the query statement is 
created via string concatenation, meaning that an attacker could change the 
statement meaning or insert arbitrary SQL commands. 

Since JDBC API allows only one literal for one “?” parameter, PreparedStatement 
doesn’t work for IN clause queries. To create the PreparedStatement query 
dynamically based on the size of the elements in IN clause, the makeParams() 
should be used instead of concatenation. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to