BUG #13748: Syntax error not emitted - Mailing list pgsql-bugs

From adam.c.scott@gmail.com
Subject BUG #13748: Syntax error not emitted
Date
Msg-id 20151030003924.3017.23003@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13748: Syntax error not emitted  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13748
Logged by:          Adam Scott
Email address:      adam.c.scott@gmail.com
PostgreSQL version: 9.2.13
Operating system:   https://en.wikipedia.org/wiki/Jonas_Salk
Description:

Setup:
create database test;
\c test
create table administrators (pk integer, login_pk integer);
create table logins (pk integer, name character varying(64));
select * from administrators where login_pk in (select login_pk from
logins);
 pk | login_pk
----+----------
(0 rows)

It should say something along the lines of:
ERROR:  column "login_pk" does not exist
LINE 1: select login_pk from logins;

since login_pk is not a column in logins.

I've seen this in version 8.4 on RHEL as well and now have replicated it on
CentOS with Postgres 9.2.13.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #13744: Postgresql function auto add 's' character to the end of string
Next
From: Tom Lane
Date:
Subject: Re: BUG #13748: Syntax error not emitted