BUG #13748: Syntax error not emitted

From: adam(dot)c(dot)scott(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13748: Syntax error not emitted
Date: 2015-10-30 00:39:24
Message-ID: 20151030003924.3017.23003@wrigleys.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: 13748
Logged by: Adam Scott
Email address: adam(dot)c(dot)scott(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-10-30 01:22:51 Re: BUG #13748: Syntax error not emitted
Previous Message dtyshecky 2015-10-29 23:08:46 BUG #13747: Like clause ignoring raws with null value