8:59 a.m.
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate3
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
3:23 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Frédéric Donckels commented on HHH-2666:
----------------------------------------
I wonder why this has been categorized as "Improvement", "Minor". It
is obviously a bug and, basically makes the SUBSELECT fetching strategy useless.
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
7:26 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Gail Badner commented on HHH-2666:
----------------------------------
Does this happen using 3.5.1?
If so, please check to see if it is already an unresolved issue reported for 3.5.x:
http://opensource.atlassian.com/projects/hibernate/secure/IssueNavigator....
To see if it has been fixed for the next 3.5.x release:
http://opensource.atlassian.com/projects/hibernate/secure/IssueNavigator....
If this is still an issue in 3.5.1, then please attach a unit test that reproduces your
issue. You may find an existing unit test to get you started in testsuite.
Thanks,
Gail
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
3:53 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Frédéric Donckels commented on HHH-2666:
----------------------------------------
I'll check when I'm back from holidays :)
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
9:09 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Frédéric Donckels commented on HHH-2666:
----------------------------------------
This is still an issue in Hibernate-Core 3.5.3-Final.
I attached a failing test case to show the problem.
(It requires TestNG and HSQDLB jar files to be self sufficient)
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
9:11 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Frédéric Donckels updated HHH-2666:
-----------------------------------
Attachment: TestHibernateSubselect.java
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
Attachments: TestHibernateSubselect.java
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
9:13 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Frédéric Donckels commented on HHH-2666:
----------------------------------------
The OP said:
"So, it loads every single comment in the database, even though only the comments for
the top ? entries are needed. Of course, if there was no order by clause on the first
query, the sub select may not return the same results, so it should probably only do this
when there is an order by clause in the first query, and it should make sure it includes
the order by clause in the sub select."
I don't think this should depend on the presence (or absence) of the ORDER clause. If
you have a massive amount of data, the subselect query, without the maxResult, will have a
major performance impact.
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
Attachments: TestHibernateSubselect.java
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
4:40 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Gail Badner updated HHH-2666:
-----------------------------
Affects Version/s: 3.5.3
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1, 3.5.3
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
Attachments: TestHibernateSubselect.java
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
2:15 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Frédéric Donckels commented on HHH-2666:
----------------------------------------
The status says "Awaiting Test Case Awaiting Test Case ", but I provided a test
case (even though it could be improved, it will still flag the issue).
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1, 3.5.3
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
Attachments: TestHibernateSubselect.java
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
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
7:28 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
Vikram Naik commented on HHH-2666:
----------------------------------
I'm using Hibernate 3.6.3.Final, and facing the same issue.
As Gavin King puts in https://hibernate.onjira.com/browse/HHH-304
"Any limit that gets applied to a query should also get applied to the subselect of
any subsequent collection fetches."
This is a major issue for us, let us know how can I help. As Frédéric Donckels have
already provided a test case, does it need anything else to get it on priority list?
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate Core
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1, 3.5.3
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
Attachments: TestHibernateSubselect.java
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:28 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
umanath kandhallu commented on HHH-2666:
----------------------------------------
i used following as a work around
@Fetch(FetchMode.JOIN)
@BatchSize(size=200)
so the generated query was like
select * from child where parentid in (?,?,?...)
instead of
select * from child where parentid in (criteria query which used to select parent)
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate ORM
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1, 3.5.3
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
Attachments: TestHibernateSubselect.java
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:30 a.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-2666) subselect fetching ignores max results
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666?page=c...
]
umanath kandhallu edited comment on HHH-2666 at 1/19/12 11:29 PM:
------------------------------------------------------------------
i used following as a work around, where i set 200 as maxResults in parent criteria
query.
i defined parent child @OneToMany with in below fashion instead of using subselect:
@Fetch(FetchMode.JOIN)
@BatchSize(size=200)
hibernate used subquery to fetch child records like one below:
select * from child where parentid in (?,?,?...)
instead of
select * from child where parentid in (criteria query which used to select parent)
was (Author: umanathkm(a)gmail.com):
i used following as a work around
@Fetch(FetchMode.JOIN)
@BatchSize(size=200)
so the generated query was like
select * from child where parentid in (?,?,?...)
instead of
select * from child where parentid in (criteria query which used to select parent)
subselect fetching ignores max results
--------------------------------------
Key: HHH-2666
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2666
Project: Hibernate ORM
Issue Type: Improvement
Components: query-hql, query-sql
Affects Versions: 3.2.1, 3.5.3
Environment: Hibernate 3.2.1
HSQLDB 8.0
Reporter: James Roper
Priority: Minor
Attachments: TestHibernateSubselect.java
When maxResults is set for a query, the hibernate subselect fetching strategy ignores it.
For example, I have a class entry, that has a list of comments, which are configured to
use the subselect fetching strategy. You can see that in the original query, only the top
? results are fetched:
select
top ? entry0_.id as id0_,
entry0_.title as title0_,
entry0_.entry as entry0_,
entry0_.time as time0_,
entry0_.category_id as category5_0_
from
Entry entry0_
order by
entry0_.time desc
But then when it does the sub select query to lazily load the comments, this is the query
it runs:
select
comments0_.entry_id as entry5_1_,
comments0_.id as id1_,
comments0_.id as id1_0_,
comments0_.time as time1_0_,
comments0_.comment as comment1_0_,
comments0_.author as author1_0_
from
Comment comments0_
where
comments0_.entry_id in (
select
entry0_.id
from
Entry entry0_
)
order by
comments0_.time desc
So, it loads every single comment in the database, even though only the comments for the
top ? entries are needed. Of course, if there was no order by clause on the first query,
the sub select may not return the same results, so it should probably only do this when
there is an order by clause in the first query, and it should make sure it includes the
order by clause in the sub select.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4312
days inactive
6162
days old
hibernate-issues@lists.jboss.org
12 comments
6 participants
participants (6)
-
Dmitriy Barbitov (JIRA) -
Frédéric Donckels (JIRA)
-
Gail Badner (JIRA)
-
James Roper (JIRA)
-
umanath kandhallu (JIRA)
-
Vikram Naik (JIRA)