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