Re: [HACKERS] WITH RECURSIVE updated to CVS TIP

On Mon, Jul 07, 2008 at 04:22:21PM +0900, Yo****yuki Asaba wrote:
> Hi,
> 
> > test=# explain select count(*)
> > test-#         from ( WITH RECURSIVE t(n) AS ( SELECT 1 UNION ALL  
> > SELECT DISTINCT n+1 FROM t )
> > test(#                 SELECT * FROM t WHERE n < 5000000000) as t
> > test-#         WHERE n < 100;
> > server closed the connection unexpectedly
> >          This probably means the server terminated abnormally
> >          before or while processing the request.
> > The connection to the server was lost. Attempting reset: Failed.
> > !> \q
> > 
> > this one will kill the planner :(
> > removing the (totally stupid) distinct avoids the core dump.
> 
> Thanks. I've fixed on local repository.

Asaba-san, do you have a patch against CVS HEAD or against the
previous one?

Cheers,
David.
-- 
David Fetter <david@[EMAIL PROTECTED]
> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@[EMAIL PROTECTED]
 to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

-- 
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches