Oleg Broytmann wrote:
>
> Hello!
>
> VIEW on 6.4.2 ignores DISTINCT. Is it a bug? known?
>
It's a known missing feature (not a bug - more like a design
fault).
DISTINCT is implemented as a unique sort step taken over the
final result of a query. Views are implemented via the query
rewrite rule system. If now someone would define a DISTINCT
view and selects a join of it with another table, the rewrite
system cannot tell the planner that only the scan's resulting
from the view should be sorted unique. It could only tell
that the entire result should be DISTINCT - what's wrong - so
I left it out.
I'm planning to implement some kind of subquery rangetable
entries someday. At that time, all these problems (DISTINCT,
GROUP BY, ORDER BY) of views will disappear.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck@debis.com (Jan Wieck) #