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

Commit7fab67a

Browse files
committed
Fix for EXISTS.
1 parente51c674 commit7fab67a

File tree

1 file changed

+21
-17
lines changed

1 file changed

+21
-17
lines changed

‎src/backend/parser/parse_expr.c

Lines changed: 21 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
*
99
* IDENTIFICATION
10-
* $Header: /cvsroot/pgsql/src/backend/parser/parse_expr.c,v 1.19 1998/02/10 16:03:28 momjian Exp $
10+
* $Header: /cvsroot/pgsql/src/backend/parser/parse_expr.c,v 1.20 1998/02/1303:41:23 vadim Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -245,39 +245,43 @@ transformExpr(ParseState *pstate, Node *expr, int precedence)
245245
List*llist;
246246

247247
pstate->p_hasSubLinks= true;
248-
249248
qtree=parse_analyze(lcons(sublink->subselect,NIL),pstate);
250-
Assert(qtree->len==1);
249+
if (qtree->len!=1||
250+
qtree->qtrees[0]->commandType!=CMD_SELECT||
251+
qtree->qtrees[0]->resultRelation!=0 )
252+
elog (ERROR,"parser: bad query in subselect");
251253
sublink->subselect= (Node*)qtree->qtrees[0];
252-
253-
foreach(llist,sublink->lefthand)
254-
lfirst(llist)=transformExpr(pstate,lfirst(llist),precedence);
255-
256-
if (length(sublink->lefthand)!=
257-
length(((Query*)sublink->subselect)->targetList))
258-
elog(ERROR,"Subselect has too many or too few fields.");
259254

260255
if (sublink->subLinkType!=EXISTS_SUBLINK)
261256
{
262257
char*op=lfirst(sublink->oper);
263258
List*left_expr=sublink->lefthand;
264-
List*right_expr= ((Query*)sublink->subselect)->targetList;
259+
List*right_expr= ((Query*)sublink->subselect)->targetList;
265260
List*elist;
266261

262+
foreach(llist,left_expr)
263+
lfirst(llist)=transformExpr(pstate,lfirst(llist),precedence);
264+
265+
if (length(left_expr)!=
266+
length(right_expr))
267+
elog(ERROR,"Subselect has too many or too few fields.");
268+
267269
sublink->oper=NIL;
268270
foreach(elist,left_expr)
269271
{
270-
Node*lexpr=lfirst(elist);
271-
Node*rexpr=lfirst(right_expr);
272-
TargetEntry*tent= (TargetEntry*)rexpr;
273-
Expr*op_expr;
272+
Node*lexpr=lfirst(elist);
273+
Node*rexpr=lfirst(right_expr);
274+
TargetEntry*tent= (TargetEntry*)rexpr;
275+
Expr*op_expr;
274276

275277
op_expr=make_op(op,lexpr,tent->expr);
276-
sublink->oper=lappend(sublink->oper,op_expr->oper);
278+
sublink->oper=lappend(sublink->oper,op_expr);
277279
right_expr=lnext(right_expr);
278280
}
279-
result= (Node*)expr;
280281
}
282+
else
283+
sublink->oper=NIL;
284+
result= (Node*)expr;
281285
break;
282286
}
283287
default:

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp