pgsql: Fix planning of SubLinks to ensure that Vars generated from

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix planning of SubLinks to ensure that Vars generated from
Date: 2006-12-06 19:40:01
Message-ID: 20061206194001.D50409FA1DE@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Log Message:
-----------
Fix planning of SubLinks to ensure that Vars generated from transformation of
a sublink's test expression have the correct vartypmod, rather than defaulting
to -1. There's at least one place where this is important because we're
expecting these Vars to be exactly equal() to those appearing in the subplan
itself. This is a pretty klugy solution --- it would likely be cleaner to
change Param nodes to include a typmod field --- but we can't do that in the
already-released 8.2 branch.
Per bug report from Hubert Fongarnand.

Modified Files:
--------------
pgsql/src/backend/optimizer/plan:
subselect.c (r1.112 -> r1.113)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/subselect.c.diff?r1=1.112&r2=1.113)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-12-06 19:40:08 pgsql: Fix planning of SubLinks to ensure that Vars generated from
Previous Message Neil Conway 2006-12-06 18:06:48 pgsql: Add a txn_start column to pg_stat_activity.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-12-06 19:43:05 Re: Bug in PostGreSQL 8.2
Previous Message Jeff Davis 2006-12-06 19:37:32 8.2 bug with outer join reordering