[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4946) org.hibernate.test.legacy.FooBarTests testLimit failure with Ingres

org.hibernate.test.legacy.FooBarTests testLimit failure with Ingres ------------------------------------------------------------------- Key: HHH-4946 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4946 Project: Hibernate Core Issue Type: Bug Components: testsuite Affects Versions: 3.5.0-Beta-4 Environment: Hibernate 3.5.0-Beta-4, Ingres 9.3.1 (int.lnx/106) Reporter: Ray Fan Assignee: Strong Liu Priority: Minor Attachments: FooBarTest.svn.diff, IngresOffsetLimitTest.java, limit.zip Assertion failure during testLimit test in legacy testsuite. {noformat} <failure type="junit.framework.AssertionFailedError">junit.framework.AssertionFailedError at junit.framework.Assert.fail(Assert.java:47) at junit.framework.Assert.assertTrue(Assert.java:20) at junit.framework.Assert.assertTrue(Assert.java:27) at org.hibernate.test.legacy.FooBarTest.testLimit(FooBarTest.java:1614) </failure> {noformat} According to the generated SQL queries the returned result set row count is 6. The behaviour of "first n" "offset m" is to move the starting row before applying the cardinality limit. I believe that test is assuming that the "offset m" is applied to the returned row set.