Hibernate version:
3.2.4
Mapping documents:
....
<set name="topics" inverse="true" cascade="all" optimistic-lock="false" batch-size="64" lazy="extra"
where="deleted='N'">
<cache usage="read-write"/>
<key column="GROUP_ID" on-delete="noaction"/>
<one-to-many class="Topic" />
</set>
....

Name and version of the database you are using:
MySQL 5.0
The generated SQL (show_sql=true):


Hibernate is returning an incorrect collection size when I enabled 'lazy="extra"'. The following query 'select count(*) from groups' is executed when performing a size() on the collection which does not include the where clause included in the mapping document. Retrieving the collection works as expected.

This looks like a bug to me, but I'm a little surprised that I would be the first to hit the problem.

Thanks

Craig Baker

Hi crbaker,

Might be the proble with jar.Take latest.For more reference have a look on.

http://opensource.atlassian.com/project ... se/HHH-783

http://opensource.atlassian.com/project ... e/HHH-1776

By problem with jar, I presume you mean I should be running the latest version of hibernate, which I am.

Appreciate the references to JIRA issues, however that don't appear to address the issue.