I have completed most of the cleanups I want to do with the optimizer.
It is much improved.

It passes the regression tests.

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

Mon, 22 Feb 1999 00:34:08 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
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

Mon, 22 Feb 1999 07:05:54 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
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, Pennsylvania 19026

Mon, 22 Feb 1999 11:42:01 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] optimizer cleanup