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

[Ray Fan (JIRA)]

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira