Name resolution error (sqlsmith)

[monetdb-team]

Date: 2017-05-13 09:35:01 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.25.21 (Dec2016-SP4)
CC: @njnes

Last updated: 2017-07-17 16:07:24 +0200

Comment 25309

Date: 2017-05-13 09:35:01 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0
Build Identifier:

Name resolution of columns seems to be broken in LATERAL expressions.
!42S22!SELECT: no such column 'ref_0.message'

Reproducible: Always

Steps to Reproduce:

select
ref_0.message as c0
from
sys.rejects as ref_0,
lateral (select
(select name from sys.objects)
as c0
from
sys.args as sample_1
right join tmp._columns as ref_4
inner join sys.part as ref_6
inner join sys.types as sample_5
on (ref_6.p_comment = sample_5.systemname )
right join sys.netcdf_vars as ref_7
on (sample_5.digits = ref_7.var_id )
on (ref_4.name = sample_5.systemname )
right join sys.user_role as sample_8
inner join sys.partsupp as ref_10
on (sample_8.role_id = ref_10.ps_partkey )
on (ref_4.name = ref_10.ps_comment )
on (sample_1.name = ref_10.ps_comment )
) as subq_0;.

Comment 25310

Date: 2017-05-13 09:36:22 +0200
From: MonetDB Mercurial Repository <>

Changeset 0d7e061a84d4 made by Martin Kersten mk@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=0d7e061a84d4

Changeset description:

Test for bug #6310

Comment 25312

Date: 2017-05-13 10:02:08 +0200
From: @mlkersten

It requires the TPCH schema

Comment 25313

Date: 2017-05-13 11:00:39 +0200
From: MonetDB Mercurial Repository <>

Changeset fea5dccda850 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=fea5dccda850

Changeset description:

fix for bug #6310, ie properly use the left part of a lateral join,
when the left part isn't used in the right part.

Comment 25365

Date: 2017-05-31 17:02:27 +0200
From: @njnes

fixed