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

- Tom

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, Pennsylvania 19026