Bugs item #2808409, was opened at 2009-06-18 14:19 Message generated for change (Comment added) made by nielsnes 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: Closed >Resolution: Fixed Priority: 3 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: Niels Nes (nielsnes) Date: 2009-08-07 14:46 Message: added test to src/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.sql fixed error message. ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2009-08-06 14:01 Message: To be investigated when a scaled down version of this problem provided. ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2009-06-18 17: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 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
