Bugs item #672975, was opened at 2003-01-23 11: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: None Priority: 5 Submitted By: Alexei Yudichev (sflexus) Assigned to: Nobody/Anonymous (nobody) 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). ---------------------------------------------------------------------- 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: Scholarships for Techies! Can't afford IT training? All 2003 ictp students receive scholarships. Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
