|
Mantis - Resin
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 1794 | minor | always | 06-11-07 21:49 | 06-15-07 11:12 | |
|
|
|||||
| Reporter: | frankhung | Platform: | |||
| Assigned To: | ferg | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | closed | Product Version: | 3.1.1 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 3.1.2 | ||
|
|
|||||
| 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: | |||||
| Relationships | |||||
| Attached Files: | |||||
| Notes | |||||
|
|
|||||
|
|
||||