Bugs item #672975, was opened at 2003-01-23 01:14 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=672975&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: Accepted Priority: 5 Submitted By: Alexei Yudichev (sflexus) Assigned to: Jeremy Boynes (jboynes) Summary: MEMBER OF generates inner joins Initial Comment: ================== This is a bug. Please file a bug report at sourceforge. MEMBER OF should be generating a sub select or a left join. This is simmilar to the IS NULL bug we recently fixed. -dain ================== SELECT OBJECT(c) FROM StoreCategory c, Partner p WHERE c.id=?1 AND (c.partnerOwner.id=?2 OR (p.id=? 2 AND p MEMBER OF� c.partners) compiles to SELECT t0_c.id FROM storecategory t0_c, partner t2_p, partner t3_c_partners, partner_categories_stor_1cl2gdd t4_c_partners_RELATION_TABLE, partner t1_c_partnerOwner WHERE (t0_c.id = ? AND (t1_c_partnerOwner.id = ? OR (t2_p.id = ? AND (t3_c_partners.id = t2_p.id)))) AND (t0_c.id=t4_c_partners_RELATION_TABLE.StoreCategor y AND t3_c_partners.id=t4_c_partners_RELATION_TABLE.Part ner AND t0_c.partnerOwner=t1_c_partnerOwner.id); thus generating inner join which forces MEMBER OF match eliminating "c.partnerOwner.id=?2" condition (see eqbql above). ---------------------------------------------------------------------- >Comment By: Jeremy Boynes (jboynes) Date: 2003-01-24 15:47 Message: Logged In: YES user_id=378919 I have committed a fix for this to the HEAD branch which generates an EXISTS subquery for both MEMBER and NOT MEMBER assuming subqueries are supported. For MySQL it generates a LEFT JOIN+IS NOT NULL check. I will backport to 3.2 and 3.0 branches over the weekend. ---------------------------------------------------------------------- Comment By: Jeremy Boynes (jboynes) Date: 2003-01-23 21:46 Message: Logged In: YES user_id=378919 Please assign this to me (jboynes) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=672975&group_id=22866 ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
