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

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!