Re: [HACKERS] optimizer cleanup

> > I have completed most of the cleanups I want to do with the optimizer.
> > It is much improved.
> > It passes the regression tests.
>
> Are you seeing misc.sql pass in the regression test? I've got a tree
> which is a few days old, but four warnings of the form:
>
> NOTICE: Non-functional update, only first update is performed
>
> have disappeared. I'm worried that there might be some query analysis
> which is no longer happening...

misc fails here with those missing warnings, but the warnings have not
been here in a long time. My regression test logs go back to Jan 29,
and at that time the warning lines where missing too.

It is an UPDATE with a join that caused the old warnings.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026