[hibernate-issues] [JIRA] (HHH-14109) IN Clause Parameter Padding not working if parameter count is between last valid power of 2 number and 'in expression limit'

[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=eyJpIjoiOTFlNTdiNTNhYjQ0NDAwYjg0NGRlYWU1MDkyMTE3NWMiLCJwIjoiaiJ9 ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14109?atlOrigin=eyJpIjoiOTFlNTdiNTNhYjQ0NDAwYjg0NGRlYWU1MDkyMTE3NWMiLCJwIjoiaiJ9 ) HHH-14109 ( https://hibernate.atlassian.net/browse/HHH-14109?atlOrigin=eyJpIjoiOTFlNTdiNTNhYjQ0NDAwYjg0NGRlYWU1MDkyMTE3NWMiLCJwIjoiaiJ9 ) IN Clause Parameter Padding not working if parameter count is between last valid power of 2 number and 'in expression limit' ( https://hibernate.atlassian.net/browse/HHH-14109?atlOrigin=eyJpIjoiOTFlNTdiNTNhYjQ0NDAwYjg0NGRlYWU1MDkyMTE3NWMiLCJwIjoiaiJ9 )

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

The 'in parameter papping' feature is using power of 2 numbers. Unless these is large as the 'in expression count limit'. Then no padding will happen.
For Oracle with a limit of 1000 parameters that means there will be no padding between 512 and 1000 parameters.
It would be better if instead of discarding the padding completly, the 'in expression count limit' would be used as padding value.

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

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#100133- sha1:d093d11 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200717/da3b327f/attachment.html