Re: [HACKERS] Open 6.5 items

> > resno's, sublevelsup corrupt when reaching rewrite system
> 
>     Don't  remember  exactly  how  I produced them.  Haven't seen
>     them again after the latest changes in the  rule  system.   I
>     think  it  was due to incorrect handling of unrewritten TLE's
>     from group by clauses, which are now pulled out of  the  main
>     targetlist.

Removed.  I suspected you had fixed it with your last GROUP patch,
because you were addressing this exact area.

> 
> > 3 = sum(x) in rewrite system is a problem
> 
>     Is  it?  I guess what is meant by this item is the problem of
>     the  rewriter  that  it  must  create  subqueries  for   view
>     aggregate columns if they appear in the WHERE clause.

The issue where was that aggregates can't be on the right in some cases.
Tom Lane brought this up.


> 
>     That  entire  area is a very problematic one. And for sake it
>     must wait for after v6.5. Aggregates and GROUP  BY  in  views
>     are  unsafe  and  depend  on  the  later  usage  of the view.
>     Consider the following:

Yes, I understand.

> > Future TODO items
> > -----------------
> > CREATE VIEW ignores DISTINCT
> 
>     Covered above.
> 

OK.

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