[JBoss-dev] [ jboss-Bugs-664373 ] WHERE xxx IS NULL EQL with 1-1 relationship doesn't work
Bugs item #664373, was opened at 2003-01-08 14:23 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=664373group_id=22866 Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Sacha Labourey (slaboure) Assigned to: Nobody/Anonymous (nobody) 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. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=664373group_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
[JBoss-dev] [ jboss-Bugs-664373 ] WHERE xxx IS NULL EQL with 1-1 relationship doesn't work
Bugs item #664373, was opened at 2003-01-08 15:23 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=664373group_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 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=detailatid=376685aid=664373group_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
[JBoss-dev] [ jboss-Bugs-664373 ] WHERE xxx IS NULL EQL with 1-1 relationship doesn't work
Bugs item #664373, was opened at 2003-01-08 15:23 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=664373group_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=detailatid=376685aid=664373group_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
[JBoss-dev] [ jboss-Bugs-664373 ] WHERE xxx IS NULL EQL with 1-1 relationship doesn't work
Bugs item #664373, was opened at 2003-01-08 14:23 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=664373group_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: Sacha Labourey (slaboure) Date: 2003-01-08 16:54 Message: Logged In: YES user_id=95900 I am using hypersonic (embedded DB) and it was working under 3.0. If you want a testcase, you can use run example 8.2g (run.client_82g) from the O'reilly JBoss workbook: it does exactly that and was working under 3.0. See here for download: http://www.jboss.org/forums/thread.jsp? forum=152thread=21861 -- Comment By: Alexey Loubyansky (loubyansky) Date: 2003-01-08 16: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 15: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=detailatid=376685aid=664373group_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
[JBoss-dev] [ jboss-Bugs-664373 ] WHERE xxx IS NULL EQL with 1-1 relationship doesn't work
Bugs item #664373, was opened at 2003-01-08 14:23 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=664373group_id=22866 Category: JBossCMP Group: v3.2 Status: Closed Resolution: Fixed 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: Sacha Labourey (slaboure) Date: 2003-01-08 19:43 Message: Logged In: YES user_id=95900 Alexey's recent commit fixes the bug -- Comment By: Sacha Labourey (slaboure) Date: 2003-01-08 16:54 Message: Logged In: YES user_id=95900 I am using hypersonic (embedded DB) and it was working under 3.0. If you want a testcase, you can use run example 8.2g (run.client_82g) from the O'reilly JBoss workbook: it does exactly that and was working under 3.0. See here for download: http://www.jboss.org/forums/thread.jsp? forum=152thread=21861 -- Comment By: Alexey Loubyansky (loubyansky) Date: 2003-01-08 16: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 15: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=detailatid=376685aid=664373group_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
