Skip site navigation (1) Skip section navigation (2)

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:08
Message-ID: 20061206194008.1C5889FA380@postgresql.org (view raw or flat)
Thread:
Lists: 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.

Tags:
----
REL8_2_STABLE

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

pgsql-committers by date

Next:From: Simon RiggsDate: 2006-12-07 00:36:49
Subject: Re: pgsql: Back out mention of port success fromFAQs, per Tom, added by
Previous:From: Tom LaneDate: 2006-12-06 19:40:01
Subject: pgsql: Fix planning of SubLinks to ensure that Vars generated from

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group