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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: maxim(dot)boguk(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7580: repeatable test case for the BUG #7579
Date: 2012-10-03 15:46:17
Message-ID: 6004.1349279177@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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


In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2012-10-03 15:55:28
Subject: Re: BUG #7578: Not able to drop user if S/he has permission on tablespace
Previous:From: sybrainDate: 2012-10-03 15:30:35
Subject: BUG #7582: Could not run PostgreSQL service

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