Bugs item #1911991, was opened at 2008-03-11 17:06 Message generated for change (Comment added) made by stmane 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 5.4 >Status: Closed >Resolution: Fixed 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. ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2008-03-19 18:17 Message: Logged In: YES user_id=572415 Originator: NO fixed in CVS (MonetDB_5-4 release branch; propagation to development trunk pending): re-aligned (and hence fixed) property propagation in M5's batcalc.mx with M4's bat_arith.mx added test in sql/src/test/BugTracker/Tests/BETWEEN_error.SF-1911991.* ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2008-03-11 17:11 Message: Logged In: YES user_id=572415 Originator: NO Most probably, this one works fine with M4/SQL ;-) I assume this fails due to a property propagation bug in M5's batcalc, which has already been fix in M4's bat_arith, but could now simply by propagated to M5's batcalc by diff|patch due to code incompatibilities. I'll re-align batcalc with bat_arith, and hence, fix the property propagation, once I find time for this "hobby"... ---------------------------------------------------------------------- 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
