You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "pri1712 (via GitHub)" <gi...@apache.org> on 2026/06/08 11:00:29 UTC

[I] Pinot java client failing for special characters [pinot]

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: commits-unsubscribe@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


Re: [I] Pinot java client failing for special characters [pinot]

Posted by "pri1712 (via GitHub)" <gi...@apache.org>.
pri1712 commented on issue #18701:
URL: https://github.com/apache/pinot/issues/18701#issuecomment-4648195866

   pls assign this to me


-- 
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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


Re: [I] Pinot java client failing for special characters [pinot]

Posted by "pri1712 (via GitHub)" <gi...@apache.org>.
pri1712 commented on issue #18701:
URL: https://github.com/apache/pinot/issues/18701#issuecomment-4697330198

   I dont think this is an issue with Pinot, went through the code and its doing what its supposed to.


-- 
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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org


Re: [I] Pinot java client failing for special characters [pinot]

Posted by "pri1712 (via GitHub)" <gi...@apache.org>.
pri1712 closed issue #18701: Pinot java client failing for special characters
URL: https://github.com/apache/pinot/issues/18701


-- 
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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org