Bugs item #1926074, was opened at 2008-03-26 13:14 Message generated for change (Comment added) made by stmane 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: 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: Stefan Manegold (stmane) Date: 2008-05-28 16:57 Message: Logged In: YES user_id=572415 Originator: NO Ok, I just saw that the bug report was closed without any test being mentioned. It's indeed there, but was not activated in the "All" file, yet. Just did that. Seems to be working fine. Closing, again. ---------------------------------------------------------------------- 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
