pgsql: Fix overenthusiastic optimization of 'x IN (SELECT DISTINCT ...)'

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix overenthusiastic optimization of 'x IN (SELECT DISTINCT ...)'
Date: 2005-07-15 17:09:27
Message-ID: 20050715170927.45D6A528DD@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix overenthusiastic optimization of 'x IN (SELECT DISTINCT ...)' and related
cases: we can't just consider whether the subquery's output is unique on its
own terms, we have to check whether the set of output columns we are going to
use will be unique. Per complaint from Luca Pireddu and test case from
Michael Fuhr.

Modified Files:
--------------
pgsql/src/backend/optimizer/util:
pathnode.c (r1.122 -> r1.123)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/pathnode.c.diff?r1=1.122&r2=1.123)
pgsql/src/test/regress/expected:
subselect.out (r1.12 -> r1.13)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/subselect.out.diff?r1=1.12&r2=1.13)
pgsql/src/test/regress/sql:
subselect.sql (r1.7 -> r1.8)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/subselect.sql.diff?r1=1.7&r2=1.8)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-07-15 17:09:50 pgsql: Fix overenthusiastic optimization of 'x IN (SELECT DISTINCT ...)'
Previous Message James William Pye 2005-07-15 15:30:40 python - be: Add Python warnings.showwarning overload.