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

[Amir Pashazadeh (JIRA)]

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