Bugs item #498902, was opened at 2002-01-03 02:35 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=498902&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Jochen Cordes (jcordes) Assigned to: Nobody/Anonymous (nobody) Summary: Wrong SQL for finder-method w/ IN clause Initial Comment: System Configuration -------------------- Windows 98 MySQL 3.23.40 JDK 1.3.1 Problem Description ------------------- Im running into problems when trying to invoke a finder-method on a unidirectional one-many- relationship (Customer-Address). I defined a table- mapping and addresses get inserted accordingly. The query looks like this SELECT OBJECT(a) FROM Customer c, IN (c.addresses) AS a WHERE c.id = ?1 AND a.type='shipping' where the generated SQL is SELECT t2_a.id FROM Customer t1_c, Address t2_a, Customer_Address t3_t1_c_to_addresses WHERE (t1_c.id = ? AND t2_a.type = 'shipping') AND t1_c.id=t4_t1_c_to_addresses.customer_id AND t2_a.id=t4_t 1_c_to_addresses.address_id Known Issue ----------- t4 should be t3. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=498902&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
