Bugs item #676533, was opened at 2003-01-28 19:15 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=676533&group_id=22866
Category: JBossCMP Group: CVS HEAD Status: Open Resolution: None Priority: 5 Submitted By: Jeremy Boynes (jboynes) Assigned to: Jeremy Boynes (jboynes) Summary: Multistep IS NULL SQL incorrect Initial Comment: With the commerce test schema, the EJB-QL query SELECT OBJECT(l) FROM LineItem l WHERE l.order.billingAddress IS NULL generates the SQL SELECT DISTINCT t0_l.id FROM LINEITEMEJB t0_l, ORDER_DATA t1_l_order WHERE (t1_l_order.BILLING_ADDRESS IS NULL) AND (t1_l_order.BILLING_ADDRESS=t1_l_order.id) which results in an SQLException because there is no ID column in ORDER_DATA but in reality it is just totally messed up. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=676533&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
