BUG #14919: Invalid column in sub select is still a valid select

From: tanes(at)siamscan(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Cc: tanes(at)siamscan(dot)net
Subject: BUG #14919: Invalid column in sub select is still a valid select
Date: 2017-11-20 07:26:24
Message-ID: 20171120072624.1469.36777@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: 14919
Logged by: Tanes Sriviroolchai
Email address: tanes(at)siamscan(dot)net
PostgreSQL version: 9.3.18
Operating system: Ubuntu 14.04
Description:

Not sure if this is a bug or feature but when I query with sub select while
sub select has invalid column the query is still valid and running. For
example:

create temp table a ( id integer, descr text);
create temp table b ( b_id integer, descr text);

# select * from a where id=(select id from b where descr='A');

id | descr
----+-------
(0 rows)

# select id from b where descr='A';

ERROR: column "id" does not exist
LINE 1: select id from b where descr='A';
^

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2017-11-20 07:56:50 Re: 10.1: hash index size exploding on vacuum full analyze
Previous Message AP 2017-11-19 23:31:57 Re: 10.1: hash index size exploding on vacuum full analyze