Date: 2018-04-04 17:13:20 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-06-20 11:02:15 +0200

Comment 26340

Date: 2018-04-04 17:13:20 +0200
From: @PedroTadim

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

The query bellow generates a MAL exception.

Reproducible: Always

Steps to Reproduce:

1. SELECT ALL 37 * + COALESCE ( - 65, 81 ) * - 36 / + - 36 AS col1;

Actual Results:

Semantic errors TypeException:user.update[21]:'calc.' undefined in: X_558:sht := calc.(X_555:bte, X_557:int);

Expected Results:

-2405

Comment 26343

Date: 2018-04-04 17:16:21 +0200
From: MonetDB Mercurial Repository <>

Changeset 44290b405a9f 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=44290b405a9f

Changeset description:

Added tests for bugs 6568, 6569 and 6570

Comment 26351

Date: 2018-04-08 14:22:40 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bug #6570, ie properly lookup the sql_mul function (and
return type) after rewriting math expressions