BUG #10587: ERROR: variable not found in subplan target list
От | geoff@sea-incorporated.com |
---|---|
Тема | BUG #10587: ERROR: variable not found in subplan target list |
Дата | |
Msg-id | 20140609191609.2586.95459@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #10587: ERROR: variable not found in subplan target list
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 10587 Logged by: Geoff Speicher Email address: geoff@sea-incorporated.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 ;
В списке pgsql-bugs по дате отправления: