Bugs item #551533, was opened at 2002-05-02 13:40 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=551533&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open >Resolution: Fixed Priority: 5 Submitted By: Alexei Guevara (aguevara) Assigned to: Dain Sundstrom (dsundstrom) >Summary: EJB-QL - missing in generated SQL Initial Comment: EJB-QL: SELECT DISTINCT OBJECT(r) FROM record r, IN (r.fields) f1, IN (r.fields) f2, IN (r.assns) assn WHERE f1.attrName=?1 AND f1.attrValue=?2 AND f2.attrName=?3 AND f2.attrValue=?4 AND assn.dataSourceName<>?5 GENERATED SQL: SELECT DISTINCT t0_r.id FROM record t0_r, field t1_f1, field t2_f2, datasourcerecordassn t3_assn WHERE t1_f1.attr_name = ? AND t1_f1.attr_value = ? AND t2_f2.attr_name = ? AND t2_f2.attr_value = ? AND t3_assn.ds_name <> ? AND (t0_r.id=t3_assn.record_id AND t0_r.id=t2_f2.record_id) BUG: there is a join missing between t1_f1 and t0_r (t0_r.id=t1_f1.record_id) CORRECT SQL: SELECT DISTINCT t0_r.id FROM record t0_r, field t1_f1, field t2_f2, datasourcerecordassn t3_assn WHERE t1_f1.attr_name = ? AND t1_f1.attr_value = ? AND t2_f2.attr_name = ? AND t2_f2.attr_value = ? AND t3_assn.ds_name <> ? AND (t0_r.id=t3_assn.record_id AND t0_r.id=t2_f2.record_id AND t0_r.id=t1_f1.record_id) ---------------------------------------------------------------------- >Comment By: Dain Sundstrom (dsundstrom) Date: 2002-06-26 18:12 Message: Logged In: YES user_id=251431 Fixed in HEAD and Branch_3_0 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=551533&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by: Jabber Inc. Don't miss the IM event of the season | Special offer for OSDN members! JabberConf 2002, Aug. 20-22, Keystone, CO http://www.jabberconf.com/osdn _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development