Bugs item #1926074, was opened at 2008-03-26 13:14 Message generated for change (Comment added) made by arjenderijke 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: Open Resolution: Fixed Priority: 6 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: Arjen de Rijke (arjenderijke) Date: 2008-05-28 16:40 Message: Logged In: YES user_id=1836138 Originator: YES The test is there, it was added some time ago: sql/src/test/BugTracker/Tests/select_multiple_not_null_constraints.SF-1926074.sql But maybe not in all the branches ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2008-05-28 16:12 Message: Logged In: YES user_id=572415 Originator: NO Re-opened as we should consider adding a test (also) for this one ... ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2008-05-22 16:40 Message: Logged In: YES user_id=43556 Originator: NO fixed .... ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2008-04-17 09: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
