Bugs item #664373, was opened at 2003-01-08 15:23 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=664373&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: Accepted Priority: 5 Submitted By: Sacha Labourey (slaboure) Assigned to: Alexey Loubyansky (loubyansky) >Summary: "WHERE xxx IS NULL" EQL with 1-1 relationship doesn't work Initial Comment: Situation: one-to-one relationship between Customer and HomeAddress. Some Customers do have a home address (=> cust.getHomeAddress() != null) while others don't (=> cust.getHomeAddress() == null) Problem: queries such as: SELECT OBJECT ( c ) FROM Customer c WHERE c.homeAddress IS NULL or SELECT OBJECT ( c ) FROM Customer c WHERE c.homeAddress IS NOT NULL always return an empty collection. This was working under 3.0.x (maybe it still works) but it doesn't work under a fresh Branch_3_2 snapshot from this morning. ---------------------------------------------------------------------- >Comment By: Alexey Loubyansky (loubyansky) Date: 2003-01-08 17:48 Message: Logged In: YES user_id=543482 Sacha, what database are you using? I think this is due to the subquery support in IS [NOT] EMPTY as it works for me in MySql with joining. alex ---------------------------------------------------------------------- Comment By: Alexey Loubyansky (loubyansky) Date: 2003-01-08 16:29 Message: Logged In: YES user_id=543482 It could be because of Jeremy's fix for "638488: OR with IS NOT EMPTY" notExistsClause method that handles IS [NOT] EMPTY is used for IS [NOT] NULL in two cases: 1. table mapping; 2. the query is performed on the entity with CMR that has no foreign key. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=664373&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