Hi Andy, Erik,

single string queries specifying range clauses fail if the "fromIncl" parameter is greater than 0. It seems that this parameter is not evaluated. For example:

There are 5 persons in the database having personids 1 to 5. The following query returns all persons, though only the last four persons are expected:

SELECT FROM org.apache.jdo.tck.pc.company.Person ORDER BY personid ASCENDING RANGE 1,5

Shall I file a JIRA?

I noticed that JPOX considers queries as valid if they specify range clauses like "RANGE 1 TO 5" instead of "RANGE 1,5". Executing such queries always return an empty result. This is just meant as a reminder in case you plan to support the "TO" syntax also.

Regards,
Michael
--
-------------------------------------------------------------------
Michael Watzek                  [EMAIL PROTECTED] Engineering GmbH
mailto:[EMAIL PROTECTED]        Buelowstr. 66
Tel.:  ++49/30/235 520 36       10783 Berlin - Germany
Fax.:  ++49/30/217 520 12       http://www.spree.de/
-------------------------------------------------------------------

Reply via email to