From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | rainer(dot)keuchel(at)allgeier-it(dot)de |
Subject: | BUG #15713: Strange error with specific column name in join |
Date: | 2019-03-25 14:38:30 |
Message-ID: | 15713-aaf78ea757146b23@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15713
Logged by: Rainer Keuchel
Email address: rainer(dot)keuchel(at)allgeier-it(dot)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;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-03-25 17:36:14 | Re: BUG #15703: Segfault in cancelled CALL-Statements |
Previous Message | Floris Van Nee | 2019-03-25 13:17:20 | Re: parallel query hangs - impossible to cancel |