0001794: OFFSET not work in EJB-QL of resin 3.1.1

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001794

[Resin]

minor

always

06-11-07 21:49

06-15-07 11:12

Reporter

frankhung

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.2

Product Version

3.1.1

Product Build

Summary

0001794: OFFSET not work in EJB-QL of resin 3.1.1

Description

Hi, I found that the offset value don't work in resin 3.1.1

e.g the following EJB-QL return 30 records correctly:

        <ejb-ql>
          <![CDATA[
            SELECT o FROM staffs o
            ORDER BY o.staffCode
        OFFSET 0 LIMIT 30
          ]]>
        </ejb-ql>

However, the following EJB-QL return NOTHING, provided that there are more that 30 records in the staffs table:

        <ejb-ql>
          <![CDATA[
            SELECT o FROM staffs o
            ORDER BY o.staffCode
        OFFSET 30 LIMIT 30
          ]]>
        </ejb-ql>

My Resin version is resin-3.1.1
It is connected to MySQL database, the version is mysql-5.0.22-2.1

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0002054) ferg 06-15-07 11:12	jpa/11c0

Issue History
Date Modified	Username	Field	Change
06-11-07 21:49	frankhung	New Issue
06-14-07 02:18	frankhung	Issue Monitored: frankhung
06-14-07 02:18	frankhung	Issue End Monitor: frankhung
06-15-07 11:12	ferg	Note Added: 0002054
06-15-07 11:12	ferg	Assigned To	=> ferg
06-15-07 11:12	ferg	Status	new => closed
06-15-07 11:12	ferg	Resolution	open => fixed
06-15-07 11:12	ferg	Fixed in Version	=> 3.1.2

Mantis 1.0.0rc3[^]

31 total queries executed.
26 unique queries executed.