[hibernate-issues] [JIRA] (HHH-14119) IN clause parameter padding not working for criteria query in conjunction with LiteralHandlingMode.BIND

[Oliver Breidenbach (JIRA)]

Oliver Breidenbach ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A76a16e01-3537-477b-a1d1-0a9e2a6bde9d ) *created* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzJkNTBjNTYzMjlhNDE2YmE1ZDE4MzYwMWNmNGE2YjEiLCJwIjoiaiJ9 ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14119?atlOrigin=eyJpIjoiNzJkNTBjNTYzMjlhNDE2YmE1ZDE4MzYwMWNmNGE2YjEiLCJwIjoiaiJ9 ) HHH-14119 ( https://hibernate.atlassian.net/browse/HHH-14119?atlOrigin=eyJpIjoiNzJkNTBjNTYzMjlhNDE2YmE1ZDE4MzYwMWNmNGE2YjEiLCJwIjoiaiJ9 ) IN clause parameter padding not working for criteria query in conjunction with LiteralHandlingMode.BIND ( https://hibernate.atlassian.net/browse/HHH-14119?atlOrigin=eyJpIjoiNzJkNTBjNTYzMjlhNDE2YmE1ZDE4MzYwMWNmNGE2YjEiLCJwIjoiaiJ9 )

Issue Type: Bug Affects Versions: 5.4.18 Assignee: Unassigned Created: 27/Jul/2020 00:00 AM Priority: Major Reporter: Oliver Breidenbach ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A76a16e01-3537-477b-a1d1-0a9e2a6bde9d )

Having a criteria query with in literal query. The parameter padding does not happen, even when the LiteralHandlingMode.BIND is used.
That is because of handling the LiteralHandlingMode.BIND at
InPredicate and LiteralExpression. Single parameters are added to the RenderingContext. Maybe the complete List should be added, so QueryParameterBindingsImpl can take care of the padding.
The 'in_clause_parameter_padding' is handelt QueryParameterBindingsImpl and is looking for 'parameterLists'.
Do to @vladmihalcea that could be a bug:
Comment on "How to improve statement caching efficiency with IN clause parameter padding" ( https://vladmihalcea.com/improve-statement-caching-efficiency-in-clause-parameter-padding/#comment-75051 )

( https://hibernate.atlassian.net/browse/HHH-14119#add-comment?atlOrigin=eyJpIjoiNzJkNTBjNTYzMjlhNDE2YmE1ZDE4MzYwMWNmNGE2YjEiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14119#add-comment?atlOrigin=eyJpIjoiNzJkNTBjNTYzMjlhNDE2YmE1ZDE4MzYwMWNmNGE2YjEiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100140- sha1:fbb0377 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200727/9476aca2/attachment.html