[hibernate-issues] [Hibernate-JIRA] Moved: (HHH-3913) paging bug when search by interface

[DingWeilong (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

DingWeilong moved HSEARCH-368 to HHH-3913:
------------------------------------------

    Component/s:     (was: query)
                 query-hql
            Key: HHH-3913  (was: HSEARCH-368)
        Project: Hibernate Core  (was: Hibernate Search)

> paging bug when search by interface 
> ------------------------------------
>
>                 Key: HHH-3913
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3913
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: query-hql
>         Environment: 3.2.5ga and other versons, mysql 5, windows xp
>            Reporter: DingWeilong
>            Priority: Critical
>
> this is the test case:
> public interface Resource
> {
>    ....
> }
> this interface have 4 realized classes: Service,Solution, Product, System
> I build my HQL script and search as follwows:
> String hql="from Resource where ... "
> Query query = session.createQuery(hql);
> query.setFirstResult(firstResult);
> query.setMaxResults(maxSize);
> But the search result size is ALWAYS ZERO！
>  I did know number of the data in my database is not zero, and could be count and get by other client tools like MYSQL Administrator.
> I reviewed my code and debug, and found if I commented the two line of paging(setFirstResult and setMaxResults), it works right. 
> I track in the source code and find the paging bug when query by superclass/interface:
> take 3.2.5GA from example,
>  the  method performList (line 146~203)of class org.hibernate.engine.query.HQLQueryPlan,
>  is the reason for my problem:
> the line 184 
>    if ( distinction.add( result ) ) {
> continue;
> }
> you see,
>  the method add will return true if distinction don't have the result object, but if do as the former code, no result will be processed but at once do the next loop.
> So, none of the results will be returned.
> the line 184 SHOULD be 
> if (! distinction.add( result ) ) {
> and this should be right for that case
> Glad to see all your ideas about it. Thanks!

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