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

[Strong Liu (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=35768#action_35768 ] 

Strong Liu commented on HHH-4946:
---------------------------------

Ray,

I'd think org.hibernate.dialect.IngresDialect.useMaxForLimit() should return "false",
and after do this, this test passes,
would you please confirm this?

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

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