Patches item #638520, was opened at 2002-11-14 08:58 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376687&aid=638520&group_id=22866
Category: JBossCMP Group: CVS HEAD Status: Open Resolution: None Priority: 5 Submitted By: Jeremy Boynes (jboynes) Assigned to: Nobody/Anonymous (nobody) Summary: Fix for 638488: OR with IS NOT EMPTY Initial Comment: Patch changing the SQL generated for IS [NOT] EMPTY clause. If subqueries are supported, this always generates an EXISTS clause. This is safe. If subqueries are not supported (mySQL), it always generates a LEFT JOIN and checks emptiness by seeing if the PK from the child is NULL. This requires that DISTINCT is specified for the select otherwise one row will be returned for each child. This may mean there are still some scenarios that don't work (I'm worried about a ejbSelect that is supposed to return duplicate rows and uses an IS [NOT] EMPTY clause) but they seem more contrived than the bug this is fixing. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376687&aid=638520&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by: To learn the basics of securing your web site with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate: http://www.gothawte.com/rd524.html _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
