Sqlitelogictest division by zero on COALESCE call

[monetdb-team]

Date: 2018-03-14 13:44:18 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-08-31 13:23:10 +0200

Comment 26266

Date: 2018-03-14 13:44:18 +0100
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.146 Safari/537.36
Build Identifier:

MonetDB gets a division by zero while processing the query bellow. From my finds it comes from the COALESCE function call. The error happens by just typing:

SELECT COALESCE ( + 55, + 71 * - 23 + 20 + 74 / - 1 / + 75 );

Reproducible: Always

Steps to Reproduce:

1. SELECT COALESCE ( + 55, + 71 * - 23 + 20 + 74 / - COUNT ( ALL - 0 ) / + 75, - 85 / - 71 ) - + - 62 + - - CAST ( + 88 AS INTEGER ) * + + 83 AS col0;

Actual Results:

Division by zero error.

Expected Results:

A result set with the single value 7421.

Comment 26280

Date: 2018-03-23 20:21:06 +0100
From: MonetDB Mercurial Repository <>

Changeset 1e3453a67fe1 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=1e3453a67fe1

Changeset description:

fixe bug #6556, ie push conditional code into the batcalc operators
(scalar case is handled by mal barriers)

Comment 26283

Date: 2018-03-24 10:29:08 +0100
From: @njnes

fixed in default