[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-3328) Paging query error

Paging query error ------------------ Key: HHH-3328 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3328 Project: Hibernate3 Issue Type: Bug Components: query-hql Environment: Hibernate 3.2.6ga, Oracle 9.2 Reporter: Sonix Legend Assignee: Gail Badner Priority: Blocker Original Estimate: 2 days Remaining Estimate: 2 days I have two mapping files. A.hbm.xml <composite-id name="id" class="ID"> <key-property name="a1"> <column name="A1"/> </key-property> <key-property name="a2"> <column name="A2"/> </key-property> </composite-id> <set name="b"> <key> <column name="B1"/> <column name="B2"/> </key> <one-to-many class="B"/> </set> B.hbm.xml <property name="b1"> <column name="B1"/> </property> <property name="b2"> <column name="B2"/> </property> <many-to-one name="a" class="A"> <column name="B1"/> <column name="B2"/> </many-to-one> And I have a query language. "select b from B as b left outer join b.a as a" It's right when the query executed. But when I set the "max results" property, it reported a error which content is "SQL Error: 918, SQLState: 42000 ORA-00918: column ambiguously defined".