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=t1.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