I have written a query using the Criteria API which does a multiselect()
and as part of that also includes some scalar subqueries and I've also
experimented with including exists() expressions referencing a subquery.
These queries don't cause any "parse time" exceptions but when these
queries are executed they don't always return the expected results.
I know scalar subqueries are not supported by JPQL in the select part,
but I was wondering if EclipseLink supports this at all using the
Criteria API or not.