[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2592) force hibernate to generate use offset qeury when offset is zero

[Max Rydahl Andersen (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_26828 ] 

Max Rydahl Andersen commented on HHH-2592:
------------------------------------------

please provide a testcase (your textual explanation sounds ambigious) and please do the fix as a patch (not full files)

> force hibernate to generate use offset qeury when offset is zero
> ----------------------------------------------------------------
>
>                 Key: HHH-2592
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2592
>             Project: Hibernate3
>          Issue Type: Improvement
>          Components: query-criteria, query-hql, query-sql
>    Affects Versions: 3.2.3
>         Environment: Hibernate Core 3.2.3 + Hibernate Annotations 3.3.0
> JDK 5.0
> Oracle 10g r2
>            Reporter: Amir Pashazadeh
>         Attachments: patch.zip
>
>
> I know this is mostly an Oracle issue, but believe me it is harder to fix it in Oracle!
> when the offset of a paged query is zero, Hibernate does not append offset part to query, but the result which is returned by oracle without the offset part, and result returned when offset is zero is different.
> so some records are retrieved in different pages, and some records (which must be in first page) are not retrieved at all.
> ----
> the patch is included.
> (I've only included Oracle9Dialect which I used)

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