BUG #10587: ERROR: variable not found in subplan target list

From: geoff(at)sea-incorporated(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10587: ERROR: variable not found in subplan target list
Date: 2014-06-09 19:16:09
Message-ID: 20140609191609.2586.95459@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: 10587
Logged by: Geoff Speicher
Email address: geoff(at)sea-incorporated(dot)com
PostgreSQL version: 9.2.8
Operating system: FreeBSD
Description:

The following SQL has been verified to yield a planner error in 9.2.2 and
9.2.8 (maybe others), but the query succeeds in 9.3.4.

create table t1 (
id int primary key,
a1 boolean,
a2 boolean
);
create table t2 (
id int primary key,
t1_id int,
b1 boolean,
b2 boolean,
foreign key (t1_id) references t1(id)
);
create table t3 (
id int primary key,
t2_id int,
c1 boolean,
foreign key (t2_id) references t2(id)
);

insert into t1 values (1,true,true);
insert into t1 values (2,true,false);
insert into t1 values (3,false,false);
insert into t2 values (1,1,true,true);
insert into t2 values (2,2,true,false);
insert into t2 values (3,3,false,false);
insert into t3 values (1,1,true);
insert into t3 values (2,2,false);
insert into t3 values (3,3,true);

select t3.id
from t3 as t3
left join
(select t2.*, (t2.b1 and t1.a3) AS b3
from t2 as t2
left join
(select t1.*, (t1.id is not null) as a3
from t1) as t1
on t1.id=t2.t1_id
) as t2
on t2.id=t3.t2_id
where t3.id=1 and t2.b3
;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2014-06-09 19:49:59 Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Previous Message Matheus de Oliveira 2014-06-09 18:58:17 Re: Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages