Date: 2018-03-05 11:03:11 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-03-29 15:38:59 +0200

Comment 26242

Date: 2018-03-05 11:03:11 +0100
From: @PedroTadim

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

In the SQL query bellow, by providing the + sign before the 77, changes the semantics of the query returning 0 instead of NULL.

Reproducible: Always

Steps to Reproduce:

1. SELECT 0 * + 77 * CAST ( NULL AS INTEGER ) AS col2;

Expected Results:

NULL

Comment 26244

Date: 2018-03-05 11:05:12 +0100
From: MonetDB Mercurial Repository <>

Changeset 7582f0753563 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Added tests for bugs 6550 and 6551

Comment 26247

Date: 2018-03-10 15:09:43 +0100
From: MonetDB Mercurial Repository <>

Changeset d6b55762ae95 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=d6b55762ae95

Changeset description:

fixes for bug #6551, ie make sure we detect NULL better, when rewriting simple math expressions.

Comment 26248

Date: 2018-03-10 17:05:49 +0100
From: @njnes

fixed by handling null;s better in optimizer

Comment 26296

Date: 2018-03-29 15:38:59 +0200
From: @sjoerdmullender

The Mar2018 version has been released.