Bugs item #2466725, was opened at 2008-12-25 16:48 Message generated for change (Settings changed) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2466725&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: Yes Submitted By: z lh (zlh) >Assigned to: Niels Nes (nielsnes) Summary: SubSelect with Outer Reference, result is wrong Initial Comment: create table t1 ( a int, b int ) ; create table t2 ( a int, b int ) ; insert into t1 values ( 1, 1 ), ( 2, 2 ) ; insert into t2 values ( 1, 1 ) ; --the result of select * from t1 where exists( select * from t2 where t2.a = t1.a ) or t1.b > 0 ; --is the same as the result of select * from t1 where exists( select * from t2 where t2.a = t1.a ) and t1.b > 0 ; --but the 'OR' should return two records. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2466725&group_id=56967 ------------------------------------------------------------------------------ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
