Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commite7a45c7

Browse files
committed
Repair subselect.c's occasional assignment of the wrong vartypmod to
Vars created to fill subplan args lists. This is an ancient error, goingback at least to 7.0, but is more easily triggered in 7.4 than beforebecause we no longer compare varlevelsup when deciding whether a Paramslot can be re-used. Fixes bug reported by Klint Gore.
1 parenta64846f commite7a45c7

File tree

1 file changed

+8
-2
lines changed

1 file changed

+8
-2
lines changed

‎src/backend/optimizer/plan/subselect.c

Lines changed: 8 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1994, Regents of the University of California
88
*
99
* IDENTIFICATION
10-
* $Header: /cvsroot/pgsql/src/backend/optimizer/plan/subselect.c,v 1.84 2003/11/2521:00:54 tgl Exp $
10+
* $Header: /cvsroot/pgsql/src/backend/optimizer/plan/subselect.c,v 1.85 2003/11/2523:59:12 tgl Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -118,6 +118,11 @@ replace_outer_var(Var *var)
118118
* well, I believe that this sort of aliasing will cause no trouble.
119119
* The correct field should get stored into the Param slot at
120120
* execution in each part of the tree.
121+
*
122+
* We also need to demand a match on vartypmod. This does not matter
123+
* for the Param itself, since those are not typmod-dependent, but it
124+
* does matter when make_subplan() instantiates a modified copy of the
125+
* Var for a subplan's args list.
121126
*/
122127
i=0;
123128
foreach(ppl,PlannerParamList)
@@ -129,7 +134,8 @@ replace_outer_var(Var *var)
129134

130135
if (pvar->varno==var->varno&&
131136
pvar->varattno==var->varattno&&
132-
pvar->vartype==var->vartype)
137+
pvar->vartype==var->vartype&&
138+
pvar->vartypmod==var->vartypmod)
133139
break;
134140
}
135141
i++;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp