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.
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 |