pgsql: Fix planning of SubLinks to ensure that Vars generated from - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix planning of SubLinks to ensure that Vars generated from
Date
Msg-id 20061206194001.D50409FA1DE@postgresql.org
Whole thread Raw
Responses Re: pgsql: Fix planning of SubLinks to ensure that  ("Andrew Dunstan" <andrew@dunslane.net>)
List pgsql-committers
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)

pgsql-committers by date:

Previous
From: neilc@postgresql.org (Neil Conway)
Date:
Subject: pgsql: Add a txn_start column to pg_stat_activity.
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix planning of SubLinks to ensure that Vars generated from