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
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: