db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From e...@jpox.org
Subject Re: Negative [VOTE] Issue 149: Restrictions on Ordering expression used with Grouping
Date Thu, 22 Dec 2005 13:48:26 GMT
-1.

In order, I prefer adding columns in SQL (SELECT) as appropriate, but only
returning to the user the columns/fields listed in setResult.

For grouping, I'm ok with raising an exception when expressions are not declared
by user

Regards,

Quoting Craig L Russell <Craig.Russell@Sun.COM>:

> Javadogs,
>
> Please reply if you do not agree.
>
> Craig
>
> On Dec 19, 2005, at 11:25 AM, Craig L Russell wrote:
>
> > Javadogs,
> >
> > See JIRA issue JDO-243 http://issues.apache.org/jira/browse/JDO-243?
> > page=all
> > Ordering should have the same restrictions as for the Select
> > clause. That is, if grouping is used, only expressions in the
> > Grouping clause and aggregate expressions can be in the Ordering
> > clause.
> > The JDO implementation is not permitted to modify the Select
> > clause, the Grouping clause, or the Ordering clause. These are user-
> > visible and should not be changed by the implementation.
> > However, the JDO implementation is required to construct valid SQL
> > if the query is being used with a relational datastore. This means
> > that the SQL SELECT might need to have expressions added to the
> > user's Select clause to include expressions in the Grouping and
> > Ordering clauses.
> > Today in the specification there are restrictions on the
> > expressions that can be used in the Select clause if there is a
> > Grouping clause:
> > <spec 14.6.10>
> > Only expressions in the Grouping clause and aggregate expressions
> > can be in the Select clause.
> > </spec 14.6.10>
> > A similar restriction is needed for the Ordering clause.
> > <proposed>
> > Only expressions in the Grouping clause and aggregate expressions
> > can be in the Ordering clause.
> > </proposed>
> >
> > Craig Russell
> > Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
> > 408 276-5638 mailto:Craig.Russell@sun.com
> > P.S. A good JDO? O, Gasp!
> >
>
> Craig Russell
> Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
> 408 276-5638 mailto:Craig.Russell@sun.com
> P.S. A good JDO? O, Gasp!
>
>




Mime
View raw message