| Michael Watzek 2005-10-31, 5:45 pm |
| 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/
-------------------------------------------------------------------
|