Date: 2016-11-23 16:44:29 +0100
From: Dean De Leo <>
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2017-03-03 10:24:58 +0100

Comment 24711

Date: 2016-11-23 16:44:29 +0100
From: Dean De Leo <>

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

The DBMS crashes on the attached due to an unexpected NULL pointer. Possibly related to bug #6114

On Linux, tip of the default branch, debug build, empty tables.

Reproducible: Always

Steps to Reproduce:

1. Load the attached schema
2. Issue the attached query
3. Server crash

Actual Results:

Segmentation fault while attempting to read the memory address 0x20.

Comment 24712

Date: 2016-11-23 16:45:30 +0100
From: Dean De Leo <>

Created attachment 513
schema.sql

Attached file: schema.sql (application/sql, 8571 bytes)
Description: schema.sql

Comment 24713

Date: 2016-11-23 16:46:37 +0100
From: Dean De Leo <>

Created attachment 514
query.sql

Attached file: Q04.sql (application/sql, 996 bytes)
Description: query.sql

Comment 24714

Date: 2016-11-23 16:48:18 +0100
From: Dean De Leo <>

Created attachment 515
debugger backtrace (.txt)

Attached file: backtrace.txt (text/plain, 5085 bytes)
Description: debugger backtrace (.txt)

Comment 25014

Date: 2017-02-12 14:18:43 +0100
From: @njnes

fixed by changes to deadcode optimizer

Comment 25015

Date: 2017-02-12 14:19:48 +0100
From: MonetDB Mercurial Repository <>

Changeset 1bb2f68b79ef made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=1bb2f68b79ef

Changeset description:

fixes for bug #6130

Comment 25133

Date: 2017-03-03 10:24:58 +0100
From: @sjoerdmullender

Dec2016-SP2 has been released, incorporating the fix.