[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1123) Cannot put more than 1000 elements in a InExpression

[Sergey (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123?page=comments#action_23986 ] 

Sergey commented on HHH-1123:
-----------------------------

This appears to be related to an old HB-655 bug (incorrectly labeled as an enhancement). Are there plans to fix this bug?

The attached patch takes the hardcoding approach for the number of items. This goes against the tendency of Hibernate to make things as configurable as possible while providing reasonable defaults. I think that this parameter needs to be configurable as well.

I think the estimate of 1 hour is too optimistic though, because one needs to factor in the updates to the documentation etc.

> Cannot put more than 1000 elements in a InExpression
> ----------------------------------------------------
>
>          Key: HHH-1123
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.1 rc2, 3.2.0.alpha1
>  Environment: Oracle 9i
>     Reporter: Alexis Seigneurin
>  Attachments: patch.txt
>
> Original Estimate: 1 hour
>         Remaining: 1 hour
>
> The number of elements that we can put in a "in" expression is limited to a certain amount (1000 for Oracle, for instance). When creating a criteria query, the org.hibernate.criterion.InExpression class should split the expression into several smaller ones.
> Attached is a patch which splits the expression by slices of 500 elements. For example, if we have 1001 elements to put in the "in" expression, the result would be :
> (entity.field in (?, ?, ?...) or entity.field in (?, ?, ?...) or entity.field in (?))
> The surrounding parantheses are useful to avoid problems with other conditions (a "and" condition taking over the one of the "or" conditions).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira