From: <glassfish_at_javadesktop.org>
Date: Wed, 17 Oct 2007 13:03:00 PDT

I suspect that there was a bug in V1 that did return a single result without a DISTINCT keyword and it has been fixed in V2.

Here is what the spec says in 4.8 SELECT Clause:

The query below is therefore not valid:
[i]SELECT o.lineItems FROM Order AS o [/i]
The DISTINCT keyword is used to specify that duplicate values must be eliminated from the query result. If DISTINCT is not specified, duplicate values are not eliminated.

-marina
[Message sent by forum member 'mvatkina' (mvatkina)]

http://forums.java.net/jive/thread.jspa?messageID=240754