pri1712 opened a new issue, #18701:
URL: https://github.com/apache/pinot/issues/18701

   **Issue:** The pinot java client (1.5.0) prepares faulty SQL statements when 
there are special characters like colons (:) in the parameter.
   
   **Example:**  It prepared the below query
   `select * from <table_name> where service_name = '<service_name>' and 
messageId = "123:456:789"`
   
   but this fails on Pinot with the following exception: 
   `Error Code: 710 (UnknownColumnError)
   
   UnknownColumnError: Unknown columnName '187202684:67010:0' found in the 
query`
   
   We can probably have better sanitizing to ensure this does not happen


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to