Bugs item #987304, was opened at 2004-07-08 16:01 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=987304&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 "stable" >Status: Open Resolution: Fixed >Priority: 6 Private: No Submitted By: Arjan Scherpenisse (arjan) Assigned to: Niels Nes (nielsnes) Summary: SQL: div by zero results in ascii art Initial Comment: The astronomers paper inspired me to try a division by zero in SQL: sql>select 1/0; # sql_div_single_value # name # decimal # type # 1 # tuplecount # 0 # id [ --.)*( ] whereas mil just gives a nil result (which is more correct). ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-08-13 18:47 Message: re-opened as the test fails since checkins on Thursday Aug 06 2009: the (IMHO) expected division by zero error is gone; instead, a NULL seems to be returned without comment; cf., http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugDay_2005-10-06_2.9.3/div_by_zero.SF-987304.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugDay_2005-10-06_2.9.3/div_by_zero.SF-987304.err.00.html ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2005-10-06 15:18 Message: Logged In: YES user_id=963970 BugDay_2005-10-06: CLAIMED BY meltdown BugDay_2005-10-06: TEST ADDED / SUCCESS src/test/BugDay_2005-10-06_2.9.3/Tests/div_by_zero.SF-987304.* ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2005-10-06 15:11 Message: Logged In: YES user_id=621590 BugDay_2005-10-06 REASSIGN: meltdown ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2004-07-15 08:53 Message: Logged In: YES user_id=43556 proberly handle nil's in dec_tostr ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2004-07-08 16:06 Message: Logged In: YES user_id=963970 Is this a bug or a hidden feature? the )*( could be a butter fly, but I can't seem to figure out what the rest means. A hidden message from Niels that you shouldn't try to divide by zero? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=987304&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
