Date: 2017-03-21 00:31:28 +0100
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2017-03-31 13:28:52 +0200

Comment 25164

Date: 2017-03-21 00:31:28 +0100
From: @mlkersten

Comment 25165

Date: 2017-03-21 00:33:04 +0100
From: @mlkersten

Type error in code generation?
!TypeException:user.s4_0[130]:'bat.append' undefined in: bat.append(X_185:bat[:str], X_159:bat[:int], true:bit);

select
sample_2.storage as c0,
sample_25.name as c1
from
sys.netcdf_vars as sample_1
inner join tmp._columns as sample_2
on (sample_1.name = sample_2.name )
right join (select
sample_21.name as c0,
sample_21.id as c1,
(select table_id from tmp.idxs)
as c2
from
sys.keys as sample_21
where ((select pu from bam.rg)
is not NULL)
or ((select depend_id from sys.dependencies)
is not NULL)) as subq_0
right join sys.netcdf_files as sample_24
right join sys.nation as ref_25
on (sample_24.location = ref_25.n_name )
on (subq_0.c1 = sample_24.file_id )
on (sample_2.type_scale = subq_0.c1 )
left join tmp.objects as sample_25
on (ref_25.n_nationkey = sample_25.id )
where (sample_1.vartype is NULL)
or (sample_1.ndim is not NULL)

Comment 25169

Date: 2017-03-22 14:40:55 +0100
From: @njnes

Added missing type check

Comment 25171

Date: 2017-03-22 19:37:05 +0100
From: MonetDB Mercurial Repository <>

Changeset 0040aa1b780b 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=0040aa1b780b

Changeset description:

fixed bug #6247

fixed problems with rewrite like