Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query rewriter crashes on a NULL pointer when having a correlated subquery #6130

monetdb-team opened this issue Nov 30, 2020 · 0 comments


Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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

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

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 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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant