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

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ 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

Status

closed

Product Version

3.1.1

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

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.