Bugs item #2466725, was opened at 2008-12-25 16:48 Message generated for change (Comment added) 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: SQL/Core >Group: SQL CVS Head >Status: Closed >Resolution: Fixed 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. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-12-27 21:29 Message: fixed by proper or handling ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2008-12-27 15:45 Message: test added to src/test/BugTracker-2008/Tests/subselect_with_or.SF-2466725.sql ---------------------------------------------------------------------- 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
