Date: 2016-11-28 16:21:26 +0100
From: Dean De Leo <>
To: SQL devs <>
Version: 11.23.13 (Jun2016-SP2)
CC: @njnes

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

Comment 24728

Date: 2016-11-28 16:21:26 +0100
From: Dean De Leo <>

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

While preparing the attached statement, the server crashes during the query semantic phase due to an unexpected null pointer.

On Linux, debug build up to 62173:60942e23e88f (default branch), empty tables.

Reproducible: Always

Steps to Reproduce:

1. See attached repro, schema included.

Actual Results:

Segmentation fault

Comment 24729

Date: 2016-11-28 16:21:45 +0100
From: Dean De Leo <>

Created attachment 518
repro1.sql

Attached file: prepare.sql (application/sql, 1114 bytes)
Description: repro1.sql

Comment 24730

Date: 2016-11-28 16:23:12 +0100
From: Dean De Leo <>

Created attachment 519
debugger backtrace (.txt)

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

Comment 24731

Date: 2016-11-28 16:27:37 +0100
From: Dean De Leo <>

Simpler repro script:

DROP TABLE test105;

CREATE TABLE test105 (A INT, B INT);

PREPARE
INSERT INTO test105
SELECT temp.t1, parent.B
FROM ( VALUES (?, ?) ) AS temp(t1, t2)
JOIN test105 parent ON (parent.A = temp.t2)
;

Comment 25025

Date: 2017-02-15 20:12:05 +0100
From: @njnes

fixed by recent changes

Comment 25026

Date: 2017-02-15 20:18:05 +0100
From: MonetDB Mercurial Repository <>

Changeset 03e3845c01e0 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=03e3845c01e0

Changeset description:

added test for bug #6133

Comment 25128

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

Dec2016-SP2 has been released, incorporating the fix.