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 failure in rel_rename (Sqlsmith) #6472

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

Assertion failure in rel_rename (Sqlsmith) #6472

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

Comments

@monetdb-team
Copy link

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

Date: 2017-11-16 14:58:33 +0100
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes

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

Comment 25891

Date: 2017-11-16 14:58:33 +0100
From: @mlkersten

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

3 0x00007fe29e573dd2 in __assert_fail () from /lib64/libc.so.6
4 0x00007fe2990ab75a in rel_rename_exps (sql=0x7fe260003e20,
exps1=0x7fe260e0a7c0, exps2=0x7fe260e14030)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:1869
5 0x00007fe2990b8dde in rel_push_select_down_union (changes=0x7fe27d3688b8,
sql=0x7fe260003e20, rel=0x7fe260e0a6b0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:4739
6 0x00007fe2990ca9eb in rewrite_topdown (sql=0x7fe260003e20, rel=0x7fe260e0a6b0,
rewriter=0x7fe2990b8b4f <rel_push_select_down_union>,
has_changes=0x7fe27d3688b8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8943
7 0x00007fe2990cab3a in rewrite_topdown (sql=0x7fe260003e20, rel=0x7fe260e09890,
rewriter=0x7fe2990b8b4f <rel_push_select_down_union>,
has_changes=0x7fe27d3688b8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8972
8 0x00007fe2990cab0e in rewrite_topdown (sql=0x7fe260003e20, rel=0x7fe260e0a550,
rewriter=0x7fe2990b8b4f <rel_push_select_down_union>,
has_changes=0x7fe27d3688b8)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8965
9 0x00007fe2990cab3a in rewrite_topdown (sql=0x7fe260003e20, rel=0x7fe260df1b90,
rewriter=0x7fe2990b8b4f <rel_push_select_down_union>,

Reproducible: Always

Steps to Reproduce:

select
subq_0.c1 as c0,
subq_0.c3 as c1,
subq_0.c1 as c2
from
(select
ref_0.rrsmb as c0,
ref_0.ticks as c1,
ref_0.thread as c2,
92 as c3,
ref_0.majflt as c4,
ref_0.stmt as c5,
ref_0.minflt as c6,
ref_0.majflt as c7,
ref_0.majflt as c8,
36 as c9,
ref_0.writes as c10,
ref_0.writes as c11,
ref_0.thread as c12,
ref_0.thread as c13
from
sys.tracelog as ref_0
where ref_0.rrsmb is NULL
limit 90) as subq_0
where EXISTS (
select
subq_0.c9 as c0,
subq_0.c13 as c1,
ref_3.name as c2,
ref_3.length as c3,
ref_5.rkey as c4
from
sys.netcdf_dims as ref_3
inner join tmp._columns as ref_4
left join tmp.keys as ref_5
on (true)
on (ref_3.name = ref_5.name )
left join (select
subq_0.c1 as c0
from
sys._tables as ref_6
where ref_6.access is not NULL) as subq_1
on ((true)
or (true))
where true);

Comment 25910

Date: 2017-11-26 10:10:29 +0100
From: @njnes

merged or expressions fixed the bug

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

Successfully merging a pull request may close this issue.

None yet
1 participant