> CREATE VIEW ignores DISTINCT?
Will not be fixed in v6.5. I'll add an elog(ERROR, ...) to
reject those view definitions during CREATE VIEW.
> CREATE TABLE t1 (a int4, b int4); CREATE VIEW v1 AS SELECT b, count(b)
> FROM t1 GROUP BY b; SELECT count FROM v1; fails
Fixed.
SELECT b FROM v1; still fails with
ERROR: union_planner: query is marked hasAggs, but I don't see any
Must adjust hasAggs as final step in rewriter.
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) #