Date: 2020-09-09 19:23:06 +0200
From: @swingbit
To: SQL devs <>
Version: 11.37.11 (Jun2020-SP1)
CC: @njnes

Last updated: 2020-10-19 11:06:21 +0200

Comment 28060

Date: 2020-09-09 19:23:06 +0200
From: @swingbit

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

This seems to apply to table-returning functions only.

I use sys.storage() as an example of table-returning function.

The following yields a segmentation fault:

explain select distinct sorted from sys.storage('sys');

Removing distinct makes it work.

Enabling assertions reveals that there is a problem here:

rel2bin_table: Assertion `sql->session->status == -10' failed.

Reproducible: Always

Comment 28065

Date: 2020-09-11 11:26:47 +0200
From: MonetDB Mercurial Repository <>

Changeset 618ec6381145 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=618ec6381145

Changeset description:

fixing bugs 6964 and  6965

escape functions with return statements in gnerator optimizer
make sure we don't remove the projection list of an table returning function in rel_push_project_down

Comment 28067

Date: 2020-09-11 11:29:16 +0200
From: @njnes

fixed in the jun branch.

Comment 28069

Date: 2020-09-11 12:25:33 +0200
From: MonetDB Mercurial Repository <>

Changeset 5ff6952a7069 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=5ff6952a7069

Changeset description:

Added tests for bugs 6964 and 6965