Date: 2018-05-10 15:41:48 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.29.3 (Mar2018)
CC: @njnes

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

Comment 26431

Date: 2018-05-10 15:41:48 +0200
From: @PedroTadim

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

Run the queries bellow for compilation errors in MonetDB. The same errors occur in default branch.

Reproducible: Always

Steps to Reproduce:

1. SELECT ALL + 60 * - NULLIF ( - CAST ( NULL AS INTEGER ), 51 * 70 * 62 / + 52 * + 58 / 90 - CAST ( + 44 AS INTEGER ) ) AS col2, 35;
2. SELECT ALL 11 * COUNT ( * ) * + 2 * 6;
3. SELECT ALL - 9 * NULLIF ( + 30, + 64 ) * + 46 * 1;

Actual Results:

1. division by zero
2. overflow in calculation 11*12
3. !Semantic errors TypeException:user.sql.init[24]:'calc.-' undefined in: X_31503:int := calc.-(X_31502:sht).

Expected Results:

1. NULL, 35
2. 132
3. -12420

Comment 26432

Date: 2018-05-10 15:43:23 +0200
From: MonetDB Mercurial Repository <>

Changeset 9428a9b2be0a 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=9428a9b2be0a

Changeset description:

Added test for bug #6600

Comment 26435

Date: 2018-05-11 10:18:52 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bug #6577 and 6600

Comment 26439

Date: 2018-05-11 13:14:32 +0200
From: @njnes

fixed the 3 problem (ie compilation issue)

Comment 26443

Date: 2018-05-11 19:36:32 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixed precedence of +- unary operator, fixes part 1 of bug #6600

Comment 26444

Date: 2018-05-12 13:11:49 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixed last part of bug #6600, ie correct digits (bits) in atom_mul