Date: 2018-04-03 16:22:40 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2019-05-06 19:58:55 +0200

Comment 26333

Date: 2018-04-03 16:22:40 +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:

Despite activating FULL_IMPLEMENTATION macro in gdk_calc.c in changeset ff833040fa32 for bug #6513, the SQL compiler still generates unavailable MAL operations.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. INSERT INTO tab0 VALUES(97,1,99), (15,81,47), (87,21,10);
3. SELECT - col0 - - - col0 * + CAST ( NULL AS INTEGER ) FROM tab0;
4. SELECT ALL - col1 * - 16 * + CAST ( NULL AS INTEGER ) FROM tab0 cor0;

Actual Results:

In the first SELECT query, the following MAL exception is generated:
Semantic errors TypeException:user.sql.init[12]:'calc.-' undefined in: X_32176:hge := calc.-(X_32175:int);

In the second SELECT query:
Semantic errors TypeException:user.sql.init[14]:'calc.-' undefined in: X_32228:lng := calc.-(X_32227:int);

Expected Results:

For both SELECT queries a single column result set with 3 NULL values.

Comment 26335

Date: 2018-04-03 16:36:57 +0200
From: MonetDB Mercurial Repository <>

Changeset 549d90c8aba5 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=549d90c8aba5

Changeset description:

Added tests for bugs 6565 and 6566

Comment 27000

Date: 2019-05-06 11:22:28 +0200
From: MonetDB Mercurial Repository <>

Changeset 49fdc1899528 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=49fdc1899528

Changeset description:

Adding more sqlite tests failing queries:

Bug #6605 outputs only 3 columns out of 6 on default.
Bug #6566 crashes on both Apr2019 and default.
Bug #6579 crashes on default.

Comment 27002

Date: 2019-05-06 19:58:55 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bug #6566, ie make sure we keep atleast one expression in a groupby