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
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;.
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:
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:
Comment 25365
Date: 2017-05-31 17:02:27 +0200
From: @njnes
fixed
The text was updated successfully, but these errors were encountered: