Skip site navigation (1) Skip section navigation (2)

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

From: maxim(dot)boguk(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7580: repeatable test case for the BUG #7579
Date: 2012-10-03 10:32:19
Message-ID: E1TJMFX-0002Cd-7K@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7580
Logged by:          Maxim Boguk
Email address:      maxim(dot)boguk(at)gmail(dot)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.



Responses

pgsql-bugs by date

Next:From: wdauchyDate: 2012-10-03 13:06:19
Subject: BUG #7581: changing blocksize makes tests fail
Previous:From: maxim.bogukDate: 2012-10-03 10:14:36
Subject: BUG #7579: repeatable Segmentation fault on some query (even inExplain)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group