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

[Ray Fan (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ray Fan updated HHH-4946:
-------------------------

    Attachment: Ingres9Dialect.offsetlimit.svn.diff

Patch file for Ingres9Dialect that modifies the offset-limit syntax.

> 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, Ingres9Dialect.offsetlimit.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