BUG #14249: In FDW, variable not found in subplan target list

From: wayne(dot)warren(at)multiscalehn(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14249: In FDW, variable not found in subplan target list
Date: 2016-07-14 13:27:44
Message-ID: 20160714132744.1416.84821@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: 14249
Logged by: Wayne Warren
Email address: wayne(dot)warren(at)multiscalehn(dot)com
PostgreSQL version: 9.6beta2
Operating system: Ubuntu 14
Description:

I have written a foreign data wrapper that works with version 9.5.2. Now
with 9.6beta2 I receive "ERROR: variable not found in subplan target list"
when I refer to a column in the WHERE clause that is not also listed as a
target column:

mydb=# select record_id, addr_chg_user_id from si_ept_470
where addr_chg_instant='5441342125';
ERROR: variable not found in subplan target list

When the column is included in the target list, the correct results are
produced.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message jason 2016-07-14 13:52:33 BUG #14250: Error in subquery fails silently and parent query continues to execute
Previous Message Peter Geoghegan 2016-07-13 18:49:24 Re: BUG #14231: logical replication wal sender process spins when using error traps in function