Re: BUG #7580: repeatable test case for the BUG #7579

maxim(dot)boguk(at)gmail(dot)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