Thread: BUG #7580: repeatable test case for the BUG #7579
The following bug has been logged on the website: Bug reference: 7580 Logged by: Maxim Boguk Email address: maxim.boguk@gmail.com PostgreSQL version: 9.2.1 Operating system: Linux Description: = create table t1 as select id from generate_series(1,100000) as g(id); create table t2 as select id from generate_series(1,100000) as g(id); alter table t1 add primary key (id); alter table t2 add primary key (id); analyze t1; analyze t2; explain select * from t1 left outer join = ( select distinct t2.id from t2 = where t2.id>100 ) as _t on _t.id=3Dt1.id where (t1.id>100 or (t1.id<100 and _t.id IS NOT NULL)); The connection to the server was lost.
maxim.boguk@gmail.com writes: > create table t1 as select id from generate_series(1,100000) as g(id); > create table t2 as select id from generate_series(1,100000) as g(id); > alter table t1 add primary key (id); > alter table t2 add primary key (id); > analyze t1; > analyze t2; > explain select * from t1 > left outer join > ( > select distinct t2.id from t2 > where t2.id>100 > ) as _t on _t.id=t1.id > where > (t1.id>100 or (t1.id<100 and _t.id IS NOT NULL)); > The connection to the server was lost. Hm, I get an Assert trap in the planner, which means this is probably my fault. Will look. regards, tom lane