Mserver5 crashes on nested SELECT

[monetdb-team]

Date: 2017-07-04 14:22:06 +0200
From: @joerivanruth
To: SQL devs <>
Version: 11.25.23 (Dec2016-SP5)
CC: @njnes

Last updated: 2017-08-02 10:21:23 +0200

Comment 25408

Date: 2017-07-04 14:22:06 +0200
From: @joerivanruth

The SQL script

 CREATE TABLE t(a INT);

 CREATE TABLE x(b INT, c1 INT);

 SELECT * FROM
      (SELECT c1, (SELECT COUNT(a) FROM t WHERE a = b) AS c2 FROM x) AS dummy
 WHERE c1 = c2;

makes mserver5 crash with

 sql/server/rel_optimizer.c:5494: rel_push_project_up: Assertion `e' failed.

This happens both on Dec2016_SP5 and on the Jul2017 branch.

Comment 25412

Date: 2017-07-05 18:32:03 +0200
From: MonetDB Mercurial Repository <>

Changeset 6a7ff140ae05 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=6a7ff140ae05

Changeset description:

fixed bug #6339, ie fixed problem in column lookup in combination with
the apply operator

Comment 25535

Date: 2017-08-02 10:21:23 +0200
From: @sjoerdmullender

Fixed in Jul2017-SP1 release.