db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Watzek <mwa.t...@spree.de>
Subject Range queries
Date Mon, 31 Oct 2005 14:35:28 GMT
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                  Tech@Spree Engineering GmbH
mailto:mwa.tech@spree.de        Buelowstr. 66
Tel.:  ++49/30/235 520 36       10783 Berlin - Germany
Fax.:  ++49/30/217 520 12       http://www.spree.de/
-------------------------------------------------------------------

Mime
View raw message