You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:55.0) Gecko/20100101 Firefox/55.0
Build Identifier:
0 0x00007f4b03e00ac7 in rel_find_exp_ (rel=0x7f4ab9487fe0, e=0x0) at /export/scratch1/home/mk/default//package/sql/server/rel_exp.c:1191
1 0x00007f4b03e00c9c in rel_find_exp (rel=0x7f4ab9487fe0, e=0x0) at /export/scratch1/home/mk/default//package/sql/server/rel_exp.c:1229
2 0x00007f4b03e005da in rel_has_exp (rel=0x7f4ab9487fe0, e=0x0) at /export/scratch1/home/mk/default//package/sql/server/rel_exp.c:1093
3 0x00007f4b03e1a487 in rel_push_semijoin_down (changes=0x7f4ad75f96d4, sql=0x7f4ab8003ec0, rel=0x7f4ab9499fe0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:4337
4 0x00007f4b03e2e3d5 in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab9499fe0, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8803
5 0x00007f4b03e2e25f in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab949a110, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8779
6 0x00007f4b03e2e2b2 in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab94a0e70, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8787
7 0x00007f4b03e2e286 in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab948b7d0, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8780
8 0x00007f4b03e2e2b2 in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab948cab0, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8787
9 0x00007f4b03e2ea1f in _rel_optimizer (sql=0x7f4ab8003ec0, rel=0x7f4ab948cab0, level=1)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8935
10 0x00007f4b03e2f01c in _rel_optimizer (sql=0x7f4ab8003ec0, rel=0x7f4ab948cab0, level=1)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:9033
11 0x00007f4b03e2f06f in rel_optimizer (sql=0x7f4ab8003ec0, rel=0x7f4ab948cab0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:9041
12 0x00007f4b03d0fb35 in sql_symbol2relation (c=0x7f4ab8003ec0, sym=0x7f4ab9485130)
at /export/scratch1/home/mk/default//package/sql/backends/monet5/sql.c:121
13 0x00007f4b03d2e96c in SQLparser
Reproducible: Always
Steps to Reproduce:
select
sample_4.x as c0,
sample_0.location as c1
from
sys.netcdf_files as sample_0
right join tmp.idxs as sample_1
right join sys.types as sample_2
on (sample_1.table_id = sample_2.id )
inner join sys.s as sample_4
inner join tmp.idxs as ref_0
on (false)
on (sample_2.digits = ref_0.id )
on (sample_0.file_id = sample_4.x )
left join sys.netcdf_files as sample_6
inner join sys.netcdf_dims as ref_1
inner join sys.s1 as ref_2
on (false)
on (sample_6.file_id = ref_1.dim_id )
right join bam.rg as sample_7
on (ref_2.x = sample_7.pi )
left join sys.netcdf_dims as ref_3
right join tmp._columns as ref_4
on (ref_3.length is NULL)
right join sys.triggers as sample_8
on (ref_3.name = sample_8.name )
left join sys.systemfunctions as ref_5
on (ref_3.dim_id is not NULL)
on ((false)
or (true))
on (sample_0.file_id = sample_8.id )
where case when true then ref_0.name else ref_0.name end
is NULL;
Date: 2017-10-15 21:39:45 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.27.5 (Jul2017-SP1)
CC: @njnes
Last updated: 2017-10-26 14:01:41 +0200
Comment 25729
Date: 2017-10-15 21:39:45 +0200
From: @mlkersten
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:55.0) Gecko/20100101 Firefox/55.0
Build Identifier:
0 0x00007f4b03e00ac7 in rel_find_exp_ (rel=0x7f4ab9487fe0, e=0x0) at /export/scratch1/home/mk/default//package/sql/server/rel_exp.c:1191
1 0x00007f4b03e00c9c in rel_find_exp (rel=0x7f4ab9487fe0, e=0x0) at /export/scratch1/home/mk/default//package/sql/server/rel_exp.c:1229
2 0x00007f4b03e005da in rel_has_exp (rel=0x7f4ab9487fe0, e=0x0) at /export/scratch1/home/mk/default//package/sql/server/rel_exp.c:1093
3 0x00007f4b03e1a487 in rel_push_semijoin_down (changes=0x7f4ad75f96d4, sql=0x7f4ab8003ec0, rel=0x7f4ab9499fe0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:4337
4 0x00007f4b03e2e3d5 in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab9499fe0, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8803
5 0x00007f4b03e2e25f in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab949a110, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8779
6 0x00007f4b03e2e2b2 in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab94a0e70, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8787
7 0x00007f4b03e2e286 in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab948b7d0, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8780
8 0x00007f4b03e2e2b2 in rewrite (sql=0x7f4ab8003ec0, rel=0x7f4ab948cab0, rewriter=0x7f4b03e1a0fa <rel_push_semijoin_down>,
has_changes=0x7f4ad75f9818) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8787
9 0x00007f4b03e2ea1f in _rel_optimizer (sql=0x7f4ab8003ec0, rel=0x7f4ab948cab0, level=1)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8935
10 0x00007f4b03e2f01c in _rel_optimizer (sql=0x7f4ab8003ec0, rel=0x7f4ab948cab0, level=1)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:9033
11 0x00007f4b03e2f06f in rel_optimizer (sql=0x7f4ab8003ec0, rel=0x7f4ab948cab0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:9041
12 0x00007f4b03d0fb35 in sql_symbol2relation (c=0x7f4ab8003ec0, sym=0x7f4ab9485130)
at /export/scratch1/home/mk/default//package/sql/backends/monet5/sql.c:121
13 0x00007f4b03d2e96c in SQLparser
Reproducible: Always
Steps to Reproduce:
select
sample_4.x as c0,
sample_0.location as c1
from
sys.netcdf_files as sample_0
right join tmp.idxs as sample_1
right join sys.types as sample_2
on (sample_1.table_id = sample_2.id )
inner join sys.s as sample_4
inner join tmp.idxs as ref_0
on (false)
on (sample_2.digits = ref_0.id )
on (sample_0.file_id = sample_4.x )
left join sys.netcdf_files as sample_6
inner join sys.netcdf_dims as ref_1
inner join sys.s1 as ref_2
on (false)
on (sample_6.file_id = ref_1.dim_id )
right join bam.rg as sample_7
on (ref_2.x = sample_7.pi )
left join sys.netcdf_dims as ref_3
right join tmp._columns as ref_4
on (ref_3.length is NULL)
right join sys.triggers as sample_8
on (ref_3.name = sample_8.name )
left join sys.systemfunctions as ref_5
on (ref_3.dim_id is not NULL)
on ((false)
or (true))
on (sample_0.file_id = sample_8.id )
where case when true then ref_0.name else ref_0.name end
is NULL;
Comment 25733
Date: 2017-10-16 07:42:28 +0200
From: @njnes
added missing check for proper e_cmp type expression in push join down code
Comment 25737
Date: 2017-10-16 08:20:21 +0200
From: MonetDB Mercurial Repository <>
Changeset cfa035d658b6 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=cfa035d658b6
Changeset description:
The text was updated successfully, but these errors were encountered: