JPOX: issues with the default Unique setting for aggregate queries

• Key: JDO-383
• Type: Bug
• Status: Resolved
• Resolution: Fixed
• Priority: Minor
• Assignee: Erik Bengtson
• Reporter: Michael Bouschen
• Component/s: tck2
• Affects Version/s: JDO 2 final
• Fix Version/s: JDO 2 maintenance release 1

Description

The JDOQL query Unique flag defaults to true for a query with a single result expression and the result expression is an aggregate (COUNT, MIN, MAX, AVG, SUM). JPOX calculates the correct default value for Unique if the result expression is specified w/o any whitespaces between the aggreagte keyword and the expression in parenthesis: setResult("MIN(budget)"). However, JPOX defaults the Unqiue flag to false, if there is a blank after the aggregate keyword: setResult("MIN (budget)").

With the fix of JDO-381 the TCK test class DefaultUnique in package org.apache.jdo.tck.query.result fails, because I added some test queries having a blank after the aggregate keyword. They now return a list with the aggregate value instead of the value itself.