[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2594) org.hibernate.criterion.Restrictions.in(?) should break up lists of 1000+ items, Oracle Dialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2594?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira