> > 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