Re: [PATCHES] WITH RECURSIVE updated to CVS TIP

On Mon, Jul 07, 2008 at 04:22:21PM +0900, Yoshiyuki 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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate