Date: 2018-01-19 16:48:28 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-02-12 16:12:17 +0100

Comment 26105

Date: 2018-01-19 16:48:28 +0100
From: @PedroTadim

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

The following SQL query cannot be executed due to a nonexistent algebra join between BATs of different numeric atom types.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23);
3. SELECT * FROM tab2 WHERE col2 NOT IN ( - + col1, col2 * + col1, + - col0 * + + 36, + + col2, 84 * + + col0 ) AND NOT NULL IS NULL;

Actual Results:

The following MAL error:
TypeException:user.main[48]:'algebra.join' undefined in: algebra.join(X_98531:bat[:int], X_98533:bat[:lng], nil:BAT, nil:BAT, false:bit, nil:lng);

Expected Results:

An empty result set.

Comment 26107

Date: 2018-01-19 17:00:04 +0100
From: MonetDB Mercurial Repository <>

Changeset 63944bc2d4a4 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=63944bc2d4a4

Changeset description:

Added tests for bugs 6518 and 6519 (enough bugs for some time)

Comment 26112

Date: 2018-01-24 18:28:46 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bugs 6518 and 6519
added type checks in (not) in correlated case (only when needed)
in case of correlated (not) in we should add the identity column (and join on that)

Comment 26114

Date: 2018-01-24 18:45:53 +0100
From: @njnes

added missing type checks