Date: 2015-10-21 17:26:56 +0200
From: Kevin Boulain <<kevin.boulain>>
To: SQL devs <>
Version: 11.21.5 (Jul2015)
CC: @njnes

Last updated: 2015-11-03 10:17:59 +0100

Comment 21374

Date: 2015-10-21 17:26:56 +0200
From: Kevin Boulain <<kevin.boulain>>

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:39.0) Gecko/20100101 Firefox/39.0
Build Identifier:

A coalesce may influence the result of the following coalesce(s).

Reproducible: Always

Steps to Reproduce:

Execute these two queries, the order matters:
sql>select coalesce(0, false);
sql>select coalesce(null, false);

Actual Results:

sql>select coalesce(0, false);
+---------------------+
| isnull_single_value |
+=====================+
| 0 |
+---------------------+
1 tuple (0.729ms)
sql>select coalesce(null, false);
+---------------------+
| isnull_single_value |
+=====================+
| 0 |
+---------------------+
1 tuple (0.188ms)

Expected Results:

sql>select coalesce(0, false);
+---------------------+
| isnull_single_value |
+=====================+
| 0 |
+---------------------+
1 tuple (0.729ms)
sql>select coalesce(null, false);
+---------------------+
| isnull_single_value |
+=====================+
| false |
+---------------------+
1 tuple (0.637ms)

Comment 21382

Date: 2015-10-22 13:29:55 +0200
From: MonetDB Mercurial Repository <>

Changeset 44e70b629f50 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=44e70b629f50

Changeset description:

Added test for bug #3830.

Comment 21385

Date: 2015-10-23 13:27:28 +0200
From: MonetDB Mercurial Repository <>

Changeset 35628f1c15c0 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=35628f1c15c0

Changeset description:

fixed coalesce(null, ...) with query cache bug #3830

Comment 21386

Date: 2015-10-23 13:30:28 +0200
From: @njnes

fixed. Was a bug in the query cache matching algo

Comment 21431

Date: 2015-11-03 10:17:59 +0100
From: @sjoerdmullender

Jul2015 SP1 has been released.