> In the first of Tilmanns examples he did "(...).isEmpty()", which you could
> get the equivalent of with "== null" I'd guess (without trying it).
Actually I doubt "== null" would suffice, but DataNucleus does support use of
EXISTS(subquery) internally for JPA support, so I just added basic support for
the special case of {subquery}.isEmpty() mapping across to "NOT EXISTS
(subquery)".
> In the second of Tilmanns examples he did "(...).get(num)" which you would
> have a lot of trouble translating to SQL, besides the fact that a Collection
> does not have a "get" method FWIW, only a List.
In fact the user can easily enough put a RANGE restriction on a query to get a
particular ROW, and change what is selected to return the precise object that
is needed, so there is no need for "get" to be supported.
If someone wants the equivalent of {subquery}.size() they should just make the
subquery a COUNT() subquery, which is already supported (since JDO 2.0)
Regards
--
Andy
DataNucleus (Web: http://www.datanucleus.org Twitter: @datanucleus)
