[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2594) org.hibernate.criterion.Restrictions.in(?) should break up lists of 1000+ items, Oracle Dialect

[MG (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31308#action_31308 ] 

MG commented on HHH-2594:
-------------------------

With hibernate 3.2.5 it does query with 1000 elements in 'in (..)'.
However it returns 256 only and rest of entries in result list are simply filled with nulls.
(Internally there is out of bound exception which is not re-thrown). 
It looks like this is really a bug.

Thanks

> org.hibernate.criterion.Restrictions.in(?) should break up lists of 1000+ items, Oracle Dialect
> -----------------------------------------------------------------------------------------------
>
>                 Key: HHH-2594
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2594
>             Project: Hibernate Core
>          Issue Type: Improvement
>          Components: query-hql
>    Affects Versions: 3.2.0.cr2
>         Environment: Hibernate 3.2cr2, Oracle DB
>            Reporter: Nathan Silberman
>            Priority: Minor
>   Original Estimate: 1 day
>  Remaining Estimate: 1 day
>
> Given a Restriction criteria, if an Array or Collection is passed into the 'in' method, an error is thrown by Oracle complaining that an IN clause must contain at most 1000 items. 
> The Oracle Dialect should be able to segment these items into multiple IN clauses of at most 1000 items each.

-- 
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