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

Assertion error in rel_rename_exps (sqlsmith) #6453

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

Assertion error in rel_rename_exps (sqlsmith) #6453

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working major SQL

Comments

@monetdb-team
Copy link

Date: 2017-10-27 11:03:31 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2017-12-14 14:46:05 +0100

Comment 25815

Date: 2017-10-27 11:03:31 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:54.0) Gecko/20100101 Firefox/54.0
Build Identifier:

On the mergedb example database

4 0x00007fbd13aa1f0b in rel_rename_exps (sql=0x7fbcc810afe0, exps1=0x7fbcc8796680,
exps2=0x7fbcc87971b0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:1869
5 0x00007fbd13aafb31 in rel_push_project_down_union (changes=0x7fbce73f88b8,
sql=0x7fbcc810afe0, rel=0x7fbcc866c950)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:4798
6 0x00007fbd13ac113e in rewrite_topdown (sql=0x7fbcc810afe0, rel=0x7fbcc866c950,
rewriter=0x7fbd13aaf7b0 <rel_push_project_down_union>,
has_changes=0x7fbce73f88b8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8835
7 0x00007fbd13ac1261 in rewrite_topdown (sql=0x7fbcc810afe0, rel=0x7fbcc8796550,
rewriter=0x7fbd13aaf7b0 <rel_push_project_down_union>,
has_changes=0x7fbce73f88b8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8857
8 0x00007fbd13ac128d in rewrite_topdown (sql=0x7fbcc810afe0, rel=0x7fbcc865ce50,
rewriter=0x7fbd13aaf7b0 <rel_push_project_down_union>,
has_changes=0x7fbce73f88b8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8864
9 0x00007fbd13ac128d in rewrite_topdown (sql=0x7fbcc810afe0, rel=0x7fbcc865dbf0,
rewriter=0x7fbd13aaf7b0 <rel_push_project_down_union>,
has_changes=0x7fbce73f88b8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8864
10 0x00007fbd13ac128d in rewrite_topdown

Reproducible: Always

Steps to Reproduce:

select
cast(nullif(subq_0.c3,
subq_0.c3) as int) as c0
from
(select
ref_0.x as c0,
ref_0.y as c1,
ref_0.z as c2,
ref_0.x as c3,
ref_0.y as c4
from
sys.s2 as ref_0
where (ref_0.z is NULL)
and (EXISTS (
select
ref_1.role_id as c0,
ref_0.z as c1,
ref_1.role_id as c2,
ref_1.role_id as c3,
ref_0.z as c4,
ref_1.login_id as c5,
ref_0.z as c6,
ref_0.y as c7
from
sys.user_role as ref_1
where (EXISTS (
select
ref_0.y as c0,
ref_1.login_id as c1,
ref_0.x as c2,
ref_0.x as c3,
ref_0.x as c4,
77 as c5,
ref_1.role_id as c6,
ref_1.login_id as c7,
ref_0.x as c8,
ref_0.x as c9,
ref_2.name as c10,
ref_0.y as c11,
ref_2.file_id as c12,
ref_2.vartype as c13
from
sys.netcdf_vars as ref_2
where ref_0.x is not NULL))
or (ref_0.y is NULL)))
limit 109) as subq_0
where (EXISTS (
select
ref_3.z as c0,
subq_0.c2 as c1,
ref_3.z as c2,
ref_3.x as c3,
100 as c4,
ref_3.x as c5,
ref_3.z as c6
from
sys.r as ref_3
where ref_3.x is not NULL))
or (subq_0.c2 is NULL)
limit 141;

Comment 25830

Date: 2017-11-01 16:14:56 +0100
From: MonetDB Mercurial Repository <>

Changeset 860ca030d222 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=860ca030d222

Changeset description:

fixes for bugs 6451, 6453 and 6455

fixed bug in apply expression name conflict resolution

fixed naming of relations with correlations

also added tests and stable output

Comment 25832

Date: 2017-11-01 16:21:07 +0100
From: @njnes

fixed problem with naming relations with correlated sub queries

@monetdb-team monetdb-team added bug Something isn't working major SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working major SQL
Projects
None yet
Development

No branches or pull requests

2 participants