BUG #15713: Strange error with specific column name in join - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15713: Strange error with specific column name in join
Date
Msg-id 15713-aaf78ea757146b23@postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15713
Logged by:          Rainer Keuchel
Email address:      rainer.keuchel@allgeier-it.de
PostgreSQL version: 11.2
Operating system:   WIN7
Description:

-- BUILD 11.0.2.19044

create table EuropeanArticleNumbers (id int);
insert into EuropeanArticleNumbers values(1);

create table EuropeanArticleNumbersX (id int);
insert into EuropeanArticleNumbersX values(1);

create table t2 (id int);
insert into t2 values (1);

-- error: column a.id does not exist
select * from EuropeanArticleNumbers a join t2 b on a.id = b.id;
-- ok
select * from EuropeanArticleNumbersX a join t2 b on a.id = b.id;


pgsql-bugs by date:

Previous
From: Floris Van Nee
Date:
Subject: Re: parallel query hangs - impossible to cancel
Next
From: Tom Lane
Date:
Subject: Re: BUG #15703: Segfault in cancelled CALL-Statements