Bugs item #1926074, was opened at 2008-03-26 12:14 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1926074&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: No Submitted By: Arjen de Rijke (arjenderijke) Assigned to: Niels Nes (nielsnes) Summary: SQL: Select with triple where clause error Initial Comment: I have a table with one record (see bugreport.txt): The query: SELECT BESTANDSNAAM FROM VIDEO_PRODUKTIE WHERE IMPALA_GEREED IS NOT NULL AND SQL_GEREED IS NOT NULL AND DATABASE_GEREED IS NULL should return 'cut.mpg', but it returns no records (or 'null' if you do this select inside a function) If you do a select query on the table with 0, 1 or 2 of the clauses, it gives the correct result. But if you do (2nd and 3rd clause switched) SELECT BESTANDSNAAM FROM VIDEO_PRODUKTIE WHERE IMPALA_GEREED IS NOT NULL AND DATABASE_GEREED IS NULL AND SQL_GEREED IS NOT NULL than it returns the correct result. This was tested on a stable build from today and a cvs build from yesterday. This problem existed in the MonetDB-Mars-SuperBall version and i thought it was fixed in the MonetDB-Feb2008-SuperBall version, but i was mistaken or the bug is reintroduced. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-05-22 14:40 Message: Logged In: YES user_id=43556 Originator: NO fixed .... ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2008-04-17 07:07 Message: Logged In: YES user_id=43556 Originator: NO arjen could you try with the stable cvs version? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1926074&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
