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