I dont understand what spec is talking about here.
it says (have to type it out, dont know how to copy+paste for pdf)
"The collection designated by the collection-valued path expression used in an empty collection comparison expression must not be used in the FROM clause for the declaration of an identification variable. An identificaition variable declared as a memeber of a collection implicitly designates the existence of a non-empty relationship;
testing whether the same collection is empty is contradictory. "
And why is the example given is invalid?
SELECT OBJECT (o)
FROM Order o, IN(o.lineItems) l, WHERE o.lineItems IS EMPTY
hmm.. l isnt used..
Thanks.
[ August 08, 2004: Message edited by: Ryan Wong ]