Bugs item #2808409, was opened at 2009-06-18 16:19 Message generated for change (Comment added) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2808409&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: Yes Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: except breaks on date column / null Initial Comment: select naam, vestigingsplaats from anbi except select naam, vestigingsplaats, beschikking from anbi, kvk where lower(naam) = lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats); !EXCEPT: column counts (4 and 10) do not match (that is basically a typo, but see the count is only one off, not 6) select naam, vestigingsplaats from anbi except select naam, vestigingsplaats from anbi, kvk where lower(naam) = lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats); ==> 16937 tuples select naam, vestigingsplaats, beschikking from anbi except select naam, vestigingsplaats, beschikking from anbi, kvk where lower(naam) = lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats); ==> 16941 tuples select naam, vestigingsplaats, beschikking, intrekking from anbi except select naam, vestigingsplaats, beschikking, intrekking from anbi, kvk where lower(naam) = lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats); fail; column intrekking contains null values. ==> 27167 tuples ---------------------------------------------------------------------- >Comment By: Stefan de Konink (skinkie) Date: 2009-06-18 19:29 Message: additionally except doesn't respect 'limit X'; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2808409&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
