[hibernate-issues] [JIRA] (BVAL-752) Automatically break large collections into chunks

[Peter Holvenstot (JIRA)]

Peter Holvenstot ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ad07cd030-113c-41eb-a09f-653610c94c52 ) *created* an issue

Bean Validation ( https://hibernate.atlassian.net/browse/BVAL?atlOrigin=eyJpIjoiNDUwMGNkZmRlNGExNDFmYmI0ZmNkNDQ3ZmExOWZjNGMiLCJwIjoiaiJ9 ) / Improvement ( https://hibernate.atlassian.net/browse/BVAL-752?atlOrigin=eyJpIjoiNDUwMGNkZmRlNGExNDFmYmI0ZmNkNDQ3ZmExOWZjNGMiLCJwIjoiaiJ9 ) BVAL-752 ( https://hibernate.atlassian.net/browse/BVAL-752?atlOrigin=eyJpIjoiNDUwMGNkZmRlNGExNDFmYmI0ZmNkNDQ3ZmExOWZjNGMiLCJwIjoiaiJ9 ) Automatically break large collections into chunks ( https://hibernate.atlassian.net/browse/BVAL-752?atlOrigin=eyJpIjoiNDUwMGNkZmRlNGExNDFmYmI0ZmNkNDQ3ZmExOWZjNGMiLCJwIjoiaiJ9 )

Issue Type: Improvement Assignee: Unassigned Created: 10/Jun/2020 13:54 PM Priority: Major Reporter: Peter Holvenstot ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ad07cd030-113c-41eb-a09f-653610c94c52 )

Oracle has a limit of 1000 elements in an 'in' clause collection. If you need to check more than 1000 elements you need to break it into two clauses.

For example: "select from Person where firstName IN (:largeCollection "

can be transformed into: "select from Person where (firstName IN :largeCollection1 or firstName IN :largeCollection2 or firstName IN largeCollection3 ...)"

Can the task of breaking the collection into sub-collections of 1000 and modifying the string be added to the Oracle dialect automatically if a collection of above 1000 elements is used as a parameter?

( https://hibernate.atlassian.net/browse/BVAL-752#add-comment?atlOrigin=eyJpIjoiNDUwMGNkZmRlNGExNDFmYmI0ZmNkNDQ3ZmExOWZjNGMiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/BVAL-752#add-comment?atlOrigin=eyJpIjoiNDUwMGNkZmRlNGExNDFmYmI0ZmNkNDQ3ZmExOWZjNGMiLCJwIjoiaiJ9 )

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#100128- sha1:0213fc8 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200610/bbdb6af0/attachment.html