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

Scope resolution problem (sqlsmith) #6352

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

Scope resolution problem (sqlsmith) #6352

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working major SQL

Comments

@monetdb-team
Copy link

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:

fixed bug #6348, only rename non constant expressions
fixed bug #6352, when pushing projects up, we should include subqueries.

Comment 25521

Date: 2017-07-28 20:26:18 +0200
From: @njnes

fixed, include subqueries when pushing up projections

@monetdb-team monetdb-team added bug Something isn't working major SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working major SQL
Projects
None yet
Development

No branches or pull requests

2 participants