[castor-user] [JDO] count and distinct in OQL

[Sean Liang]

It seems Castor doesn't support the following OQL statement:
  select count(distinct t.id) from model.Test t
which will throw the exception:
  org.exolab.castor.jdo.oql.OQLSyntaxException: An inapropriate token (41) was 
encountered in an expression.

As described in OQL syntax page, http://www.castor.org/oql.html#Syntax:
  aggregateExpr ::= sum( query )
                            | min( query )
                            | max( query )
                            | avg( query )
                            | count(( query | * ))
I tried to modify the OQL to:
  select count(select distinct t.id from model.Test t)
but get the same exception (token changes to 1). Can anyone help?

Thanks,
Sean