Re: [PATCHES] WITH RECURSIVE updated to CVS TIP

Here is the patches he made against CVS HEAD (as of today).

According to him followings are fixed with the patches:

- fix crush with DISTINCT
- fix creating VIEW
- fix the case when recursion plan has another recursion plan under it
- fix WITH RECURSIVE ...(..) SELECT ...WHERE.. returns wrong result
- fix inifinit recursion with OUTER JOIN

Not yet fixed:

- detect certain queries those are not valid acroding to the standard
- sort query names acording to the dependency
- planner always estimate 0 cost for recursion plans
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> > - SQL:2008 に規定されているクエリ以外をエラーにする処理
> > - 依存関係の順番で評価するようにする仕組み
> > - プランナが常にコスト 0 で見積る
> >

> 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(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
> Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate