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

Segfault in rel_optimizer (sqlsmith) #6217

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

Segfault in rel_optimizer (sqlsmith) #6217

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

Comments

@monetdb-team
Copy link

Date: 2017-02-16 17:47:12 +0100
From: @mlkersten
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @njnes

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

Comment 25030

Date: 2017-02-16 17:47:12 +0100
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:51.0) Gecko/20100101 Firefox/51.0
Build Identifier:

Found by sqlsmith

0x00007f688a1b51ce in rewrite (sql=0x7f685c12bb70,
rel=0x7f685c2b57b0,
rewriter=0x7f688a1a5281 <rel_reduce_groupby_exps>,
has_changes=0x7f6870aca8e8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8600
2 0x00007f688a1b50f8 in rewrite (sql=0x7f685c12bb70,
rel=0x7f685c2b8c80,
rewriter=0x7f688a1a5281 <rel_reduce_groupby_exps>,
has_changes=0x7f6870aca8e8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8586
3 0x00007f688a1b50f8 in rewrite (sql=0x7f685c12bb70,

Reproducible: Always

Steps to Reproduce:

select
ref_2.name as c0,
ref_2.name as c1,
ref_2.condition as c2,
90 as c3,
ref_2.condition as c4,
ref_2.id as c5
from
sys.triggers as ref_2
where 24 is NULL;

Comment 25033

Date: 2017-02-19 14:00:34 +0100
From: @njnes

fixed by creating the missing list first.

Comment 25036

Date: 2017-02-19 14:05:27 +0100
From: MonetDB Mercurial Repository <>

Changeset 53b86a794d0c 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=53b86a794d0c

Changeset description:

add tests for bugs 6216 and 6217

Comment 25106

Date: 2017-03-03 10:24:08 +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
Labels
Projects
None yet
Development

No branches or pull requests

2 participants