On TPCH SF1 Sqlsmith discovered a name resolution issue causing an assertion to be raised in the optimizers
could not find sample_3.majflt
sample_0.rowid
sample_0.fldid
sample_0.message
sample_0.input
Reproducible: Always
Steps to Reproduce:
insert into sys.netcdf_files values (
50,
case when 84 is NULL then case when EXISTS (
select
sample_3.majflt as c0
from
sys.rejects as sample_0
inner join sys.tracelog as sample_3
left join sys.querylog_calls as sample_4
on (sample_3.rrsmb = sample_4.tuples )
on (sample_0.rowid = sample_3.ticks )
where false)
then cast(null as char) else cast(null as char) end
else case when EXISTS (
select
sample_3.majflt as c0
from
sys.rejects as sample_0
inner join sys.tracelog as sample_3
left join sys.querylog_calls as sample_4
on (sample_3.rrsmb = sample_4.tuples )
on (sample_0.rowid = sample_3.ticks )
where false) then cast(null as char) else cast(null as char) end
end
);
Date: 2017-07-14 09:47:14 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2017-10-26 14:01:25 +0200
Comment 25465
Date: 2017-07-14 09:47:14 +0200
From: @mlkersten
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:54.0) Gecko/20100101 Firefox/54.0
Build Identifier:
On TPCH SF1 Sqlsmith discovered a name resolution issue causing an assertion to be raised in the optimizers
could not find sample_3.majflt
sample_0.rowid
sample_0.fldid
sample_0.message
sample_0.input
Reproducible: Always
Steps to Reproduce:
insert into sys.netcdf_files values (
50,
case when 84 is NULL then case when EXISTS (
select
sample_3.majflt as c0
from
sys.rejects as sample_0
inner join sys.tracelog as sample_3
left join sys.querylog_calls as sample_4
on (sample_3.rrsmb = sample_4.tuples )
on (sample_0.rowid = sample_3.ticks )
where false)
then cast(null as char) else cast(null as char) end
else case when EXISTS (
select
sample_3.majflt as c0
from
sys.rejects as sample_0
inner join sys.tracelog as sample_3
left join sys.querylog_calls as sample_4
on (sample_3.rrsmb = sample_4.tuples )
on (sample_0.rowid = sample_3.ticks )
where false) then cast(null as char) else cast(null as char) end
end
);
Comment 25519
Date: 2017-07-28 20:25:57 +0200
From: MonetDB Mercurial Repository <>
Changeset e9c19dd387e7 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=e9c19dd387e7
Changeset description:
Comment 25521
Date: 2017-07-28 20:26:18 +0200
From: @njnes
fixed, include subqueries when pushing up projections
The text was updated successfully, but these errors were encountered: