pgsql: Fix oversight in MIN/MAX optimization: must not return NULL - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Fix oversight in MIN/MAX optimization: must not return NULL
Date
Msg-id 20050412051129.76C1053222@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Fix oversight in MIN/MAX optimization: must not return NULL entries
from index, since the aggregates ignore NULLs.

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        createplan.c (r1.178 -> r1.179)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/createplan.c.diff?r1=1.178&r2=1.179)
        planagg.c (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planagg.c.diff?r1=1.2&r2=1.3)
    pgsql/src/include/optimizer:
        planmain.h (r1.81 -> r1.82)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/planmain.h.diff?r1=1.81&r2=1.82)

pgsql-committers by date:

Previous
From: andrewsn@pgfoundry.org (User Andrewsn)
Date:
Subject: newsysviews - newsysview: table constraints and foreign keys
Next
From: dfetter@pgfoundry.org (User Dfetter)
Date:
Subject: docbot - docbot: Fixed duplicates in queries.