Bugs item #2798333, was opened at 2009-05-29 12:23 Message generated for change (Tracker Item Submitted) made by lsidir 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: Open Resolution: None 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. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2798333&group_id=56967 ------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp as they present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
