[Apache JDO Wiki] New: QueryTests

[jd...@db.apache.org]

   Date: 2005-02-11T05:58:43
   Editor: MichaelBouschen
   Wiki: Apache JDO Wiki
   Page: QueryTests
   URL: http://wiki.apache.org/jdo/QueryTests

   First version QueryTests page (describing JDO TCK query test changes)

New Page:

= JDO TCK 1.1 Test Cases =

The current JDO TCK (as implemented in the tck11 sub-project) does not implement all the JDO TCK assertions. For some of these assertions the unimpl_tests directory of the Sun cvs repository includes test classes where the test method need to be implemented. The spreadsheet assetions/Jdo``Tck``Assertions``Table.sxc lists all the assertions.

Here are the unimpl tests for package org.apache.jdo.tck.query:

||Assertion No.||Class||Comment||
||A5.4.3-9  ||Queries``Of``Instances``With``Nondatstore``Identity||Not testable with JDO RI||
||A14.6.2-2 ||Element``Returned``In``Query``Result||prio 2, Rename class to Denote``Uniqueness``In``Filter||
||A14.6.2-4 ||Equality``And``Comparisons``Between``Date``Fields``And``Parameters||prio 2||
||A14.6.2-5 ||Equality``And``Comparisons``Between``String``Fields``And``Parameters||prio 2, String ordering is not portable||
||A14.6.2-9 ||Navigation``ThroughANull``Valued``Field||prio 2||
||A14.6.2-10||Navigation``ThroughACollection``Field||prio 3||
||A14.6.2-11||Namespace``Of``Identifiers||prio 3||
||A14.6.2-12||This``Is``Reserved``Word``For``Element``Of``Collection||Tested elsewhere => skip test case||
||A14.6.2-13||Navigation``Through``References``Uses``Dot``Operator||prio 2||
||A14.6.2-36||Comparing``Collection``Field``To``Null||prio 3||
||A14.6.2-38||Cast||prio 3||
||A14.6.2-39||Promotion``Of``Numeric``Operands``For``Comparisons||prio 3||
||A14.6.5-1 ||Scope``Of``Variable``Not``Named``In``Contains``Clause||JDO 2.0 test case||
||A14.6.5-2 ||Scope``Of``Variable``Not``Named``In``Contains``Clause``And``No``Extent||JDO 2.0 test case||

Here are the unimpl tests for package org.apache.jdo.tck.query.operators:

||Assertion No.||Class||Comment||
||A14.6.2-20||Boolean``Logical``AND||prio 2||
||A14.6.2-21||Conditional``AND||prio 1||
||A14.6.2-22||Boolean``Logical``OR||prio 2||
||A14.6.2-23||Conditional``OR||prio 1||
||A14.6.2-24||Bitwise``Complement||prio 3||
||A14.6.2-25||Unary``Addition||prio 3, rename class to Unary``Plus||
||A14.6.2-27||String``Concatentation||prio 3||
||A14.6.2-28||Binary``Subtraction||prio 3||
||A14.6.2-29||Sign``Inversion||prio 3||
||A14.6.2-30||Multiplication||prio 3||
||A14.6.2-31||Division||prio 3||
||A14.6.2-32||Logical``Complement|||prio 2||
||A14.6.2-33||Starts``With``And``Ends``With||prio 3||
||A14.6.2-34||Null``Collections``And``Is``Empty||prio 3||
||A14.6.2-35||Null``Collections``And``Contains``Method||prio 3||

These are JDO 1.0 assertions w/o test class in the unimpl_tests directory.

||Assertion No.||Comment||
||N14.4-5||Multiple identical imports||
||N14.6-15||Query.setXXX method repalce previous values||
||N14.6.1-7||Changing query resukt collection fails||
||N14.6.1-8 ||pc parameter bound to different pm fails||
||N14.6.1-10||Query with ignoreCache=false||
||A14.6.2-11||Identifier name space||

= JDO TCK 2.0 Test Cases =

JDO 2.0 extends the Query API and the Query language JDOQL. 

== Query API ==

The spreadsheet lists the following assertions for JDK TCK 2.0 that make sure a JDO 2.0 implementation supports the new Query API methods:

||Assertion No.||Comment||
||N2-14.6-16||Query.setResult||
||N2-14.6-17||Query.setGrouping||
||N2-14.6-18||Query.setUnique||
||N2-14.6-19||Query.setResultClass||
||N2-14.6-20||Query.setRange||
||N2-14.6-18||Query.setUnique||

JDO adds the following methods to the Query API, but there are no assertions for these methods yet:
 * void setUnmodifiable()
 * boolean isUnmodifiable()
 * void setExtensions(Map extensions)
 * void addExtension(String key, Object value)

== JDOQL 2.0 ==

JDO 2.0 extensions of the JDO query language JDOQL:

 * Single string JDOQL
 * Result specification
   * Projections of fields and relationships
   * One or more result expressions
   * Distinct results
   * Unique query result
   * Default result class for one or more result expressions
   * User defined result class
   * Naming of result expressions
 * Aggregate functions MIN, MAX, SUM, AVG, and COUNT
 * Grouping of query result
   * One or more grouing expressions
   * Having clause
 * New methods in Query filters:
   * Map support: get(Object), containsKey(Object), containsValue(Object), isEmpty()
   * Additional string methods: toLowerCase(), toUpperCase(), indexOf(String), indexOf(String, int), matches(String), substring(int), substring(int, int)
   * Support for other methods: Math.abs(numeric), Math.sqrt(numeric), JDOHelper.getObjectId(Object)
 * New operators %(modulo) and instanceof
 * Support for implicit parameters
 * Support for implicit variables
 * Deletion by query