Hi Tom, hi Gordon, hi Andrei,
attached you find a fix for glassfish issue 592: UPDATE with subquery
updates too many rows.
https://glassfish.dev.java.net/issues/show_bug.cgi?id=592
During validation the query compiler calculates the set of
identification variables that need to be joined between the subquery and
the outer query. Unfortunately, this call was omitted for an update
query. Thus the set was empty and no joins were generated.
The first jar includes the fix, the second jar adds new test cases to
the entity-persistence-tests module.
Regards Michael