Bugs item #1911991, was opened at 2008-03-11 17:06 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1911991&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: MonetDB5 CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Arjen de Rijke (arjenderijke) Assigned to: Stefan Manegold (stmane) Summary: BETWEEN returns wrong results Initial Comment: If you have a table with a column ID with consecutive numbers say 1..100, the query SELECT ID FROM TABLE WHERE (ID - 10) BETWEEN 0 AND 10; gives the correct result but the query SELECT ID FROM TABLE WHERE (10 - ID) BETWEEN 0 AND 10; gives the wrong results. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1911991&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
