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

Type analysis issue (sqlsmith) #6247

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

Type analysis issue (sqlsmith) #6247

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


Copy link

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

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 as c0, as c1
sys.netcdf_vars as sample_1
inner join tmp._columns as sample_2
on ( = )
right join (select as c0, as c1,
(select table_id from tmp.idxs)
as c2
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 = )
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 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant