Bugs item #2798333, was opened at 2009-05-29 10:23 Message generated for change (Settings changed) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2798333&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: Works For Me Priority: 5 Private: No Submitted By: Lefteris Sidirourgos (lsidir) Assigned to: Niels Nes (nielsnes) Summary: view+except+limit Initial Comment: if the following scenario is executed: create table bug (a int, b int); insert into bug values (1,1); insert into bug values (1,2); insert into bug values (1,3); create view bug_2 as select * from bug; create view bug_3 as select * from bug_2 except select * from bug where bug.b=2; then if: select * from bug_3; +---+---+ | a | b | +===+===+ | 1 | 1 | | 1 | 3 | +---+---+ which is correct. But if: select * from bug_3 limit 1; 0 tuples which is wrong. I have only tested to the development branch, not the stable version. ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-06-09 20:38 Message: The new test seems to run correctly on the stable branch ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-06-09 20:36 Message: added test to BugTracker-2009/Tests/view-except-limit.SF-2798333 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2798333&group_id=56967 ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
