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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026