Anthony Wood ([EMAIL PROTECTED]) writes:
> [ SELECT DISTINCT ON in a subquery-in-FROM misbehaves ]
Here's the patch against 7.1.2 to fix this problem. This also fixes a
related problem noted a few days ago, that outer WHERE clauses shouldn't
be pushed down into a sub-select that has a LIMIT clau
[EMAIL PROTECTED] writes:
> [ SELECT DISTINCT ON in a subquery-in-FROM misbehaves ]
Oooh, good catch! I had thought about pushing down quals into a SELECT
DISTINCT, and concluded it was OK because the qual would eliminate all
or none of a set of not-DISTINCT rows. But I forgot about DISTINCT ON
Anthony Wood ([EMAIL PROTECTED]) reports a bug with a severity
of 1
The lower the number the more severe it is.
Short Description
subquery results bypassed
Long Description
The second query in the example code should return:
a | b | c
---+---+---
(0 rows)
but actually returns
a | b | c
-
