Having a CASE statement with a division and an additional arithmetic operation, when there's a 0 value in a column, results in a division by zero ArithmeticException.
Removing the additional arithmetic operation while keeping the division, makes the query produce the correct results.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t (c INT);
INSERT INTO t VALUES (0);
SELECT CASE WHEN (c = 0) THEN 0 ELSE (c / c + 1) END FROM t;
Date: 2011-06-13 15:25:58 +0200
From: Alfred Nordman <<alfred.nordman>>
To: SQL devs <>
Version: 11.3.3 (Apr2011-SP1) [obsolete]
CC: @njnes
Last updated: 2011-07-29 10:52:45 +0200
Comment 15845
Date: 2011-06-13 15:25:58 +0200
From: Alfred Nordman <<alfred.nordman>>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
Build Identifier:
Having a CASE statement with a division and an additional arithmetic operation, when there's a 0 value in a column, results in a division by zero ArithmeticException.
Removing the additional arithmetic operation while keeping the division, makes the query produce the correct results.
Reproducible: Always
Steps to Reproduce:
CREATE TABLE t (c INT);
INSERT INTO t VALUES (0);
SELECT CASE WHEN (c = 0) THEN 0 ELSE (c / c + 1) END FROM t;
Actual Results:
ArithmeticException:batcalc./:Division by zero
Expected Results:
+-----------------------+
| ifthenelse_isnull_=_c |
+=======================+
| 0 |
+-----------------------+
MonetDB 5 server v11.3.3 "Apr2011-SP1" (64-bit, 32-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved
Visit http://monetdb.cwi.nl/ for further information
Found 8.0GiB available memory
Libraries:
libpcre: 8.10 2010-06-25
openssl: OpenSSL 1.0.0a 1 Jun 2010
libxml2: 2.7.7
Compiled by: sjoerd@LAB03 (x86_64-pc-winnt)
Compilation: cl -GF -W3 -wd4273 -wd4102 -MD -nologo -Ox
Linking : cl -GF -W3 -wd4273 -wd4102 -MD -nologo -Ox
Comment 15878
Date: 2011-07-02 14:09:02 +0200
From: @njnes
Changeset 5e65f282eeab made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=5e65f282eeab
Changeset description:
Comment 15954
Date: 2011-07-17 15:01:22 +0200
From: @drstmane
Changeset b26f389978e4 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=b26f389978e4
Changeset description:
Comment 16010
Date: 2011-07-29 10:52:45 +0200
From: @sjoerdmullender
The Apr2011-SP2 bugfix release is out.
The text was updated successfully, but these errors were encountered: