1 /*-------------------------------------------------------------------------
4 * Equality functions to compare node trees.
6 * NOTE: we currently support comparing all node types found in parse
7 * trees. We do not support comparing executor state trees; there
8 * is no need for that, and no point in maintaining all the code that
9 * would be needed. We also do not support comparing Path trees, mainly
10 * because the circular linkages between RelOptInfo and Path nodes can't
11 * be handled easily in a simple depth-first traversal.
13 * Currently, in fact, equal() doesn't know how to compare Plan trees
14 * either. This might need to be fixed someday.
16 * NOTE: it is intentional that parse location fields (in nodes that have
17 * one) are not compared. This is because we want, for example, a variable
18 * "x" to be considered equal() to another reference to "x" in the query.
21 * Portions Copyright (c) 1996-2012, PostgreSQL Global Development Group
22 * Portions Copyright (c) 1994, Regents of the University of California
25 * src/backend/nodes/equalfuncs.c
27 *-------------------------------------------------------------------------
32 #include "nodes/relation.h"
33 #include "utils/datum.h"
37 * Macros to simplify comparison of different kinds of fields. Use these
38 * wherever possible to reduce the chance for silly typos. Note that these
39 * hard-wire the convention that the local variables in an Equal routine are
43 /* Compare a simple scalar field (int, float, bool, enum, etc) */
44 #define COMPARE_SCALAR_FIELD(fldname) \
46 if (a->fldname != b->fldname) \
50 /* Compare a field that is a pointer to some kind of Node or Node tree */
51 #define COMPARE_NODE_FIELD(fldname) \
53 if (!equal(a->fldname, b->fldname)) \
57 /* Compare a field that is a pointer to a Bitmapset */
58 #define COMPARE_BITMAPSET_FIELD(fldname) \
60 if (!bms_equal(a->fldname, b->fldname)) \
64 /* Compare a field that is a pointer to a C string, or perhaps NULL */
65 #define COMPARE_STRING_FIELD(fldname) \
67 if (!equalstr(a->fldname, b->fldname)) \
71 /* Macro for comparing string fields that might be NULL */
72 #define equalstr(a, b) \
73 (((a) != NULL && (b) != NULL) ? (strcmp(a, b) == 0) : (a) == (b))
75 /* Compare a field that is a pointer to a simple palloc'd object of size sz */
76 #define COMPARE_POINTER_FIELD(fldname, sz) \
78 if (memcmp(a->fldname, b->fldname, (sz)) != 0) \
82 /* Compare a parse location field (this is a no-op, per note above) */
83 #define COMPARE_LOCATION_FIELD(fldname) \
88 * Stuff from primnodes.h
92 _equalAlias(const Alias *a, const Alias *b)
94 COMPARE_STRING_FIELD(aliasname);
95 COMPARE_NODE_FIELD(colnames);
101 _equalRangeVar(const RangeVar *a, const RangeVar *b)
103 COMPARE_STRING_FIELD(catalogname);
104 COMPARE_STRING_FIELD(schemaname);
105 COMPARE_STRING_FIELD(relname);
106 COMPARE_SCALAR_FIELD(inhOpt);
107 COMPARE_SCALAR_FIELD(relpersistence);
108 COMPARE_NODE_FIELD(alias);
109 COMPARE_LOCATION_FIELD(location);
115 _equalIntoClause(const IntoClause *a, const IntoClause *b)
117 COMPARE_NODE_FIELD(rel);
118 COMPARE_NODE_FIELD(colNames);
119 COMPARE_NODE_FIELD(options);
120 COMPARE_SCALAR_FIELD(onCommit);
121 COMPARE_STRING_FIELD(tableSpaceName);
122 COMPARE_SCALAR_FIELD(skipData);
128 * We don't need an _equalExpr because Expr is an abstract supertype which
129 * should never actually get instantiated. Also, since it has no common
130 * fields except NodeTag, there's no need for a helper routine to factor
131 * out comparing the common fields...
135 _equalVar(const Var *a, const Var *b)
137 COMPARE_SCALAR_FIELD(varno);
138 COMPARE_SCALAR_FIELD(varattno);
139 COMPARE_SCALAR_FIELD(vartype);
140 COMPARE_SCALAR_FIELD(vartypmod);
141 COMPARE_SCALAR_FIELD(varcollid);
142 COMPARE_SCALAR_FIELD(varlevelsup);
143 COMPARE_SCALAR_FIELD(varnoold);
144 COMPARE_SCALAR_FIELD(varoattno);
145 COMPARE_LOCATION_FIELD(location);
151 _equalConst(const Const *a, const Const *b)
153 COMPARE_SCALAR_FIELD(consttype);
154 COMPARE_SCALAR_FIELD(consttypmod);
155 COMPARE_SCALAR_FIELD(constcollid);
156 COMPARE_SCALAR_FIELD(constlen);
157 COMPARE_SCALAR_FIELD(constisnull);
158 COMPARE_SCALAR_FIELD(constbyval);
159 COMPARE_LOCATION_FIELD(location);
162 * We treat all NULL constants of the same type as equal. Someday this
163 * might need to change? But datumIsEqual doesn't work on nulls, so...
167 return datumIsEqual(a->constvalue, b->constvalue,
168 a->constbyval, a->constlen);
172 _equalParam(const Param *a, const Param *b)
174 COMPARE_SCALAR_FIELD(paramkind);
175 COMPARE_SCALAR_FIELD(paramid);
176 COMPARE_SCALAR_FIELD(paramtype);
177 COMPARE_SCALAR_FIELD(paramtypmod);
178 COMPARE_SCALAR_FIELD(paramcollid);
179 COMPARE_LOCATION_FIELD(location);
185 _equalAggref(const Aggref *a, const Aggref *b)
187 COMPARE_SCALAR_FIELD(aggfnoid);
188 COMPARE_SCALAR_FIELD(aggtype);
189 COMPARE_SCALAR_FIELD(aggcollid);
190 COMPARE_SCALAR_FIELD(inputcollid);
191 COMPARE_NODE_FIELD(args);
192 COMPARE_NODE_FIELD(aggorder);
193 COMPARE_NODE_FIELD(aggdistinct);
194 COMPARE_SCALAR_FIELD(aggstar);
195 COMPARE_SCALAR_FIELD(agglevelsup);
196 COMPARE_LOCATION_FIELD(location);
202 _equalWindowFunc(const WindowFunc *a, const WindowFunc *b)
204 COMPARE_SCALAR_FIELD(winfnoid);
205 COMPARE_SCALAR_FIELD(wintype);
206 COMPARE_SCALAR_FIELD(wincollid);
207 COMPARE_SCALAR_FIELD(inputcollid);
208 COMPARE_NODE_FIELD(args);
209 COMPARE_SCALAR_FIELD(winref);
210 COMPARE_SCALAR_FIELD(winstar);
211 COMPARE_SCALAR_FIELD(winagg);
212 COMPARE_LOCATION_FIELD(location);
218 _equalArrayRef(const ArrayRef *a, const ArrayRef *b)
220 COMPARE_SCALAR_FIELD(refarraytype);
221 COMPARE_SCALAR_FIELD(refelemtype);
222 COMPARE_SCALAR_FIELD(reftypmod);
223 COMPARE_SCALAR_FIELD(refcollid);
224 COMPARE_NODE_FIELD(refupperindexpr);
225 COMPARE_NODE_FIELD(reflowerindexpr);
226 COMPARE_NODE_FIELD(refexpr);
227 COMPARE_NODE_FIELD(refassgnexpr);
233 _equalFuncExpr(const FuncExpr *a, const FuncExpr *b)
235 COMPARE_SCALAR_FIELD(funcid);
236 COMPARE_SCALAR_FIELD(funcresulttype);
237 COMPARE_SCALAR_FIELD(funcretset);
240 * Special-case COERCE_DONTCARE, so that planner can build coercion nodes
241 * that are equal() to both explicit and implicit coercions.
243 if (a->funcformat != b->funcformat &&
244 a->funcformat != COERCE_DONTCARE &&
245 b->funcformat != COERCE_DONTCARE)
248 COMPARE_SCALAR_FIELD(funccollid);
249 COMPARE_SCALAR_FIELD(inputcollid);
250 COMPARE_NODE_FIELD(args);
251 COMPARE_LOCATION_FIELD(location);
257 _equalNamedArgExpr(const NamedArgExpr *a, const NamedArgExpr *b)
259 COMPARE_NODE_FIELD(arg);
260 COMPARE_STRING_FIELD(name);
261 COMPARE_SCALAR_FIELD(argnumber);
262 COMPARE_LOCATION_FIELD(location);
268 _equalOpExpr(const OpExpr *a, const OpExpr *b)
270 COMPARE_SCALAR_FIELD(opno);
273 * Special-case opfuncid: it is allowable for it to differ if one node
274 * contains zero and the other doesn't. This just means that the one node
275 * isn't as far along in the parse/plan pipeline and hasn't had the
276 * opfuncid cache filled yet.
278 if (a->opfuncid != b->opfuncid &&
283 COMPARE_SCALAR_FIELD(opresulttype);
284 COMPARE_SCALAR_FIELD(opretset);
285 COMPARE_SCALAR_FIELD(opcollid);
286 COMPARE_SCALAR_FIELD(inputcollid);
287 COMPARE_NODE_FIELD(args);
288 COMPARE_LOCATION_FIELD(location);
294 _equalDistinctExpr(const DistinctExpr *a, const DistinctExpr *b)
296 COMPARE_SCALAR_FIELD(opno);
299 * Special-case opfuncid: it is allowable for it to differ if one node
300 * contains zero and the other doesn't. This just means that the one node
301 * isn't as far along in the parse/plan pipeline and hasn't had the
302 * opfuncid cache filled yet.
304 if (a->opfuncid != b->opfuncid &&
309 COMPARE_SCALAR_FIELD(opresulttype);
310 COMPARE_SCALAR_FIELD(opretset);
311 COMPARE_SCALAR_FIELD(opcollid);
312 COMPARE_SCALAR_FIELD(inputcollid);
313 COMPARE_NODE_FIELD(args);
314 COMPARE_LOCATION_FIELD(location);
320 _equalNullIfExpr(const NullIfExpr *a, const NullIfExpr *b)
322 COMPARE_SCALAR_FIELD(opno);
325 * Special-case opfuncid: it is allowable for it to differ if one node
326 * contains zero and the other doesn't. This just means that the one node
327 * isn't as far along in the parse/plan pipeline and hasn't had the
328 * opfuncid cache filled yet.
330 if (a->opfuncid != b->opfuncid &&
335 COMPARE_SCALAR_FIELD(opresulttype);
336 COMPARE_SCALAR_FIELD(opretset);
337 COMPARE_SCALAR_FIELD(opcollid);
338 COMPARE_SCALAR_FIELD(inputcollid);
339 COMPARE_NODE_FIELD(args);
340 COMPARE_LOCATION_FIELD(location);
346 _equalScalarArrayOpExpr(const ScalarArrayOpExpr *a, const ScalarArrayOpExpr *b)
348 COMPARE_SCALAR_FIELD(opno);
351 * Special-case opfuncid: it is allowable for it to differ if one node
352 * contains zero and the other doesn't. This just means that the one node
353 * isn't as far along in the parse/plan pipeline and hasn't had the
354 * opfuncid cache filled yet.
356 if (a->opfuncid != b->opfuncid &&
361 COMPARE_SCALAR_FIELD(useOr);
362 COMPARE_SCALAR_FIELD(inputcollid);
363 COMPARE_NODE_FIELD(args);
364 COMPARE_LOCATION_FIELD(location);
370 _equalBoolExpr(const BoolExpr *a, const BoolExpr *b)
372 COMPARE_SCALAR_FIELD(boolop);
373 COMPARE_NODE_FIELD(args);
374 COMPARE_LOCATION_FIELD(location);
380 _equalSubLink(const SubLink *a, const SubLink *b)
382 COMPARE_SCALAR_FIELD(subLinkType);
383 COMPARE_NODE_FIELD(testexpr);
384 COMPARE_NODE_FIELD(operName);
385 COMPARE_NODE_FIELD(subselect);
386 COMPARE_LOCATION_FIELD(location);
392 _equalSubPlan(const SubPlan *a, const SubPlan *b)
394 COMPARE_SCALAR_FIELD(subLinkType);
395 COMPARE_NODE_FIELD(testexpr);
396 COMPARE_NODE_FIELD(paramIds);
397 COMPARE_SCALAR_FIELD(plan_id);
398 COMPARE_STRING_FIELD(plan_name);
399 COMPARE_SCALAR_FIELD(firstColType);
400 COMPARE_SCALAR_FIELD(firstColTypmod);
401 COMPARE_SCALAR_FIELD(firstColCollation);
402 COMPARE_SCALAR_FIELD(useHashTable);
403 COMPARE_SCALAR_FIELD(unknownEqFalse);
404 COMPARE_NODE_FIELD(setParam);
405 COMPARE_NODE_FIELD(parParam);
406 COMPARE_NODE_FIELD(args);
407 COMPARE_SCALAR_FIELD(startup_cost);
408 COMPARE_SCALAR_FIELD(per_call_cost);
414 _equalAlternativeSubPlan(const AlternativeSubPlan *a, const AlternativeSubPlan *b)
416 COMPARE_NODE_FIELD(subplans);
422 _equalFieldSelect(const FieldSelect *a, const FieldSelect *b)
424 COMPARE_NODE_FIELD(arg);
425 COMPARE_SCALAR_FIELD(fieldnum);
426 COMPARE_SCALAR_FIELD(resulttype);
427 COMPARE_SCALAR_FIELD(resulttypmod);
428 COMPARE_SCALAR_FIELD(resultcollid);
434 _equalFieldStore(const FieldStore *a, const FieldStore *b)
436 COMPARE_NODE_FIELD(arg);
437 COMPARE_NODE_FIELD(newvals);
438 COMPARE_NODE_FIELD(fieldnums);
439 COMPARE_SCALAR_FIELD(resulttype);
445 _equalRelabelType(const RelabelType *a, const RelabelType *b)
447 COMPARE_NODE_FIELD(arg);
448 COMPARE_SCALAR_FIELD(resulttype);
449 COMPARE_SCALAR_FIELD(resulttypmod);
450 COMPARE_SCALAR_FIELD(resultcollid);
453 * Special-case COERCE_DONTCARE, so that planner can build coercion nodes
454 * that are equal() to both explicit and implicit coercions.
456 if (a->relabelformat != b->relabelformat &&
457 a->relabelformat != COERCE_DONTCARE &&
458 b->relabelformat != COERCE_DONTCARE)
461 COMPARE_LOCATION_FIELD(location);
467 _equalCoerceViaIO(const CoerceViaIO *a, const CoerceViaIO *b)
469 COMPARE_NODE_FIELD(arg);
470 COMPARE_SCALAR_FIELD(resulttype);
471 COMPARE_SCALAR_FIELD(resultcollid);
474 * Special-case COERCE_DONTCARE, so that planner can build coercion nodes
475 * that are equal() to both explicit and implicit coercions.
477 if (a->coerceformat != b->coerceformat &&
478 a->coerceformat != COERCE_DONTCARE &&
479 b->coerceformat != COERCE_DONTCARE)
482 COMPARE_LOCATION_FIELD(location);
488 _equalArrayCoerceExpr(const ArrayCoerceExpr *a, const ArrayCoerceExpr *b)
490 COMPARE_NODE_FIELD(arg);
491 COMPARE_SCALAR_FIELD(elemfuncid);
492 COMPARE_SCALAR_FIELD(resulttype);
493 COMPARE_SCALAR_FIELD(resulttypmod);
494 COMPARE_SCALAR_FIELD(resultcollid);
495 COMPARE_SCALAR_FIELD(isExplicit);
498 * Special-case COERCE_DONTCARE, so that planner can build coercion nodes
499 * that are equal() to both explicit and implicit coercions.
501 if (a->coerceformat != b->coerceformat &&
502 a->coerceformat != COERCE_DONTCARE &&
503 b->coerceformat != COERCE_DONTCARE)
506 COMPARE_LOCATION_FIELD(location);
512 _equalConvertRowtypeExpr(const ConvertRowtypeExpr *a, const ConvertRowtypeExpr *b)
514 COMPARE_NODE_FIELD(arg);
515 COMPARE_SCALAR_FIELD(resulttype);
518 * Special-case COERCE_DONTCARE, so that planner can build coercion nodes
519 * that are equal() to both explicit and implicit coercions.
521 if (a->convertformat != b->convertformat &&
522 a->convertformat != COERCE_DONTCARE &&
523 b->convertformat != COERCE_DONTCARE)
526 COMPARE_LOCATION_FIELD(location);
532 _equalCollateExpr(const CollateExpr *a, const CollateExpr *b)
534 COMPARE_NODE_FIELD(arg);
535 COMPARE_SCALAR_FIELD(collOid);
536 COMPARE_LOCATION_FIELD(location);
542 _equalCaseExpr(const CaseExpr *a, const CaseExpr *b)
544 COMPARE_SCALAR_FIELD(casetype);
545 COMPARE_SCALAR_FIELD(casecollid);
546 COMPARE_NODE_FIELD(arg);
547 COMPARE_NODE_FIELD(args);
548 COMPARE_NODE_FIELD(defresult);
549 COMPARE_LOCATION_FIELD(location);
555 _equalCaseWhen(const CaseWhen *a, const CaseWhen *b)
557 COMPARE_NODE_FIELD(expr);
558 COMPARE_NODE_FIELD(result);
559 COMPARE_LOCATION_FIELD(location);
565 _equalCaseTestExpr(const CaseTestExpr *a, const CaseTestExpr *b)
567 COMPARE_SCALAR_FIELD(typeId);
568 COMPARE_SCALAR_FIELD(typeMod);
569 COMPARE_SCALAR_FIELD(collation);
575 _equalArrayExpr(const ArrayExpr *a, const ArrayExpr *b)
577 COMPARE_SCALAR_FIELD(array_typeid);
578 COMPARE_SCALAR_FIELD(array_collid);
579 COMPARE_SCALAR_FIELD(element_typeid);
580 COMPARE_NODE_FIELD(elements);
581 COMPARE_SCALAR_FIELD(multidims);
582 COMPARE_LOCATION_FIELD(location);
588 _equalRowExpr(const RowExpr *a, const RowExpr *b)
590 COMPARE_NODE_FIELD(args);
591 COMPARE_SCALAR_FIELD(row_typeid);
594 * Special-case COERCE_DONTCARE, so that planner can build coercion nodes
595 * that are equal() to both explicit and implicit coercions.
597 if (a->row_format != b->row_format &&
598 a->row_format != COERCE_DONTCARE &&
599 b->row_format != COERCE_DONTCARE)
602 COMPARE_NODE_FIELD(colnames);
603 COMPARE_LOCATION_FIELD(location);
609 _equalRowCompareExpr(const RowCompareExpr *a, const RowCompareExpr *b)
611 COMPARE_SCALAR_FIELD(rctype);
612 COMPARE_NODE_FIELD(opnos);
613 COMPARE_NODE_FIELD(opfamilies);
614 COMPARE_NODE_FIELD(inputcollids);
615 COMPARE_NODE_FIELD(largs);
616 COMPARE_NODE_FIELD(rargs);
622 _equalCoalesceExpr(const CoalesceExpr *a, const CoalesceExpr *b)
624 COMPARE_SCALAR_FIELD(coalescetype);
625 COMPARE_SCALAR_FIELD(coalescecollid);
626 COMPARE_NODE_FIELD(args);
627 COMPARE_LOCATION_FIELD(location);
633 _equalMinMaxExpr(const MinMaxExpr *a, const MinMaxExpr *b)
635 COMPARE_SCALAR_FIELD(minmaxtype);
636 COMPARE_SCALAR_FIELD(minmaxcollid);
637 COMPARE_SCALAR_FIELD(inputcollid);
638 COMPARE_SCALAR_FIELD(op);
639 COMPARE_NODE_FIELD(args);
640 COMPARE_LOCATION_FIELD(location);
646 _equalXmlExpr(const XmlExpr *a, const XmlExpr *b)
648 COMPARE_SCALAR_FIELD(op);
649 COMPARE_STRING_FIELD(name);
650 COMPARE_NODE_FIELD(named_args);
651 COMPARE_NODE_FIELD(arg_names);
652 COMPARE_NODE_FIELD(args);
653 COMPARE_SCALAR_FIELD(xmloption);
654 COMPARE_SCALAR_FIELD(type);
655 COMPARE_SCALAR_FIELD(typmod);
656 COMPARE_LOCATION_FIELD(location);
662 _equalNullTest(const NullTest *a, const NullTest *b)
664 COMPARE_NODE_FIELD(arg);
665 COMPARE_SCALAR_FIELD(nulltesttype);
666 COMPARE_SCALAR_FIELD(argisrow);
672 _equalBooleanTest(const BooleanTest *a, const BooleanTest *b)
674 COMPARE_NODE_FIELD(arg);
675 COMPARE_SCALAR_FIELD(booltesttype);
681 _equalCoerceToDomain(const CoerceToDomain *a, const CoerceToDomain *b)
683 COMPARE_NODE_FIELD(arg);
684 COMPARE_SCALAR_FIELD(resulttype);
685 COMPARE_SCALAR_FIELD(resulttypmod);
686 COMPARE_SCALAR_FIELD(resultcollid);
689 * Special-case COERCE_DONTCARE, so that planner can build coercion nodes
690 * that are equal() to both explicit and implicit coercions.
692 if (a->coercionformat != b->coercionformat &&
693 a->coercionformat != COERCE_DONTCARE &&
694 b->coercionformat != COERCE_DONTCARE)
697 COMPARE_LOCATION_FIELD(location);
703 _equalCoerceToDomainValue(const CoerceToDomainValue *a, const CoerceToDomainValue *b)
705 COMPARE_SCALAR_FIELD(typeId);
706 COMPARE_SCALAR_FIELD(typeMod);
707 COMPARE_SCALAR_FIELD(collation);
708 COMPARE_LOCATION_FIELD(location);
714 _equalSetToDefault(const SetToDefault *a, const SetToDefault *b)
716 COMPARE_SCALAR_FIELD(typeId);
717 COMPARE_SCALAR_FIELD(typeMod);
718 COMPARE_SCALAR_FIELD(collation);
719 COMPARE_LOCATION_FIELD(location);
725 _equalCurrentOfExpr(const CurrentOfExpr *a, const CurrentOfExpr *b)
727 COMPARE_SCALAR_FIELD(cvarno);
728 COMPARE_STRING_FIELD(cursor_name);
729 COMPARE_SCALAR_FIELD(cursor_param);
735 _equalTargetEntry(const TargetEntry *a, const TargetEntry *b)
737 COMPARE_NODE_FIELD(expr);
738 COMPARE_SCALAR_FIELD(resno);
739 COMPARE_STRING_FIELD(resname);
740 COMPARE_SCALAR_FIELD(ressortgroupref);
741 COMPARE_SCALAR_FIELD(resorigtbl);
742 COMPARE_SCALAR_FIELD(resorigcol);
743 COMPARE_SCALAR_FIELD(resjunk);
749 _equalRangeTblRef(const RangeTblRef *a, const RangeTblRef *b)
751 COMPARE_SCALAR_FIELD(rtindex);
757 _equalJoinExpr(const JoinExpr *a, const JoinExpr *b)
759 COMPARE_SCALAR_FIELD(jointype);
760 COMPARE_SCALAR_FIELD(isNatural);
761 COMPARE_NODE_FIELD(larg);
762 COMPARE_NODE_FIELD(rarg);
763 COMPARE_NODE_FIELD(usingClause);
764 COMPARE_NODE_FIELD(quals);
765 COMPARE_NODE_FIELD(alias);
766 COMPARE_SCALAR_FIELD(rtindex);
772 _equalFromExpr(const FromExpr *a, const FromExpr *b)
774 COMPARE_NODE_FIELD(fromlist);
775 COMPARE_NODE_FIELD(quals);
782 * Stuff from relation.h
786 _equalPathKey(const PathKey *a, const PathKey *b)
789 * This is normally used on non-canonicalized PathKeys, so must chase up
790 * to the topmost merged EquivalenceClass and see if those are the same
791 * (by pointer equality).
793 EquivalenceClass *a_eclass;
794 EquivalenceClass *b_eclass;
796 a_eclass = a->pk_eclass;
797 while (a_eclass->ec_merged)
798 a_eclass = a_eclass->ec_merged;
799 b_eclass = b->pk_eclass;
800 while (b_eclass->ec_merged)
801 b_eclass = b_eclass->ec_merged;
802 if (a_eclass != b_eclass)
804 COMPARE_SCALAR_FIELD(pk_opfamily);
805 COMPARE_SCALAR_FIELD(pk_strategy);
806 COMPARE_SCALAR_FIELD(pk_nulls_first);
812 _equalRestrictInfo(const RestrictInfo *a, const RestrictInfo *b)
814 COMPARE_NODE_FIELD(clause);
815 COMPARE_SCALAR_FIELD(is_pushed_down);
816 COMPARE_SCALAR_FIELD(outerjoin_delayed);
817 COMPARE_BITMAPSET_FIELD(required_relids);
818 COMPARE_BITMAPSET_FIELD(outer_relids);
819 COMPARE_BITMAPSET_FIELD(nullable_relids);
822 * We ignore all the remaining fields, since they may not be set yet, and
823 * should be derivable from the clause anyway.
830 _equalPlaceHolderVar(const PlaceHolderVar *a, const PlaceHolderVar *b)
833 * We intentionally do not compare phexpr. Two PlaceHolderVars with the
834 * same ID and levelsup should be considered equal even if the contained
835 * expressions have managed to mutate to different states. One way in
836 * which that can happen is that initplan sublinks would get replaced by
837 * differently-numbered Params when sublink folding is done. (The end
838 * result of such a situation would be some unreferenced initplans, which
839 * is annoying but not really a problem.)
841 * COMPARE_NODE_FIELD(phexpr);
843 COMPARE_BITMAPSET_FIELD(phrels);
844 COMPARE_SCALAR_FIELD(phid);
845 COMPARE_SCALAR_FIELD(phlevelsup);
851 _equalSpecialJoinInfo(const SpecialJoinInfo *a, const SpecialJoinInfo *b)
853 COMPARE_BITMAPSET_FIELD(min_lefthand);
854 COMPARE_BITMAPSET_FIELD(min_righthand);
855 COMPARE_BITMAPSET_FIELD(syn_lefthand);
856 COMPARE_BITMAPSET_FIELD(syn_righthand);
857 COMPARE_SCALAR_FIELD(jointype);
858 COMPARE_SCALAR_FIELD(lhs_strict);
859 COMPARE_SCALAR_FIELD(delay_upper_joins);
860 COMPARE_NODE_FIELD(join_quals);
866 _equalLateralJoinInfo(const LateralJoinInfo *a, const LateralJoinInfo *b)
868 COMPARE_SCALAR_FIELD(lateral_rhs);
869 COMPARE_BITMAPSET_FIELD(lateral_lhs);
875 _equalAppendRelInfo(const AppendRelInfo *a, const AppendRelInfo *b)
877 COMPARE_SCALAR_FIELD(parent_relid);
878 COMPARE_SCALAR_FIELD(child_relid);
879 COMPARE_SCALAR_FIELD(parent_reltype);
880 COMPARE_SCALAR_FIELD(child_reltype);
881 COMPARE_NODE_FIELD(translated_vars);
882 COMPARE_SCALAR_FIELD(parent_reloid);
888 _equalPlaceHolderInfo(const PlaceHolderInfo *a, const PlaceHolderInfo *b)
890 COMPARE_SCALAR_FIELD(phid);
891 COMPARE_NODE_FIELD(ph_var);
892 COMPARE_BITMAPSET_FIELD(ph_eval_at);
893 COMPARE_BITMAPSET_FIELD(ph_needed);
894 COMPARE_BITMAPSET_FIELD(ph_may_need);
895 COMPARE_SCALAR_FIELD(ph_width);
902 * Stuff from parsenodes.h
906 _equalQuery(const Query *a, const Query *b)
908 COMPARE_SCALAR_FIELD(commandType);
909 COMPARE_SCALAR_FIELD(querySource);
910 /* we intentionally ignore queryId, since it might not be set */
911 COMPARE_SCALAR_FIELD(canSetTag);
912 COMPARE_NODE_FIELD(utilityStmt);
913 COMPARE_SCALAR_FIELD(resultRelation);
914 COMPARE_SCALAR_FIELD(hasAggs);
915 COMPARE_SCALAR_FIELD(hasWindowFuncs);
916 COMPARE_SCALAR_FIELD(hasSubLinks);
917 COMPARE_SCALAR_FIELD(hasDistinctOn);
918 COMPARE_SCALAR_FIELD(hasRecursive);
919 COMPARE_SCALAR_FIELD(hasModifyingCTE);
920 COMPARE_SCALAR_FIELD(hasForUpdate);
921 COMPARE_NODE_FIELD(cteList);
922 COMPARE_NODE_FIELD(rtable);
923 COMPARE_NODE_FIELD(jointree);
924 COMPARE_NODE_FIELD(targetList);
925 COMPARE_NODE_FIELD(returningList);
926 COMPARE_NODE_FIELD(groupClause);
927 COMPARE_NODE_FIELD(havingQual);
928 COMPARE_NODE_FIELD(windowClause);
929 COMPARE_NODE_FIELD(distinctClause);
930 COMPARE_NODE_FIELD(sortClause);
931 COMPARE_NODE_FIELD(limitOffset);
932 COMPARE_NODE_FIELD(limitCount);
933 COMPARE_NODE_FIELD(rowMarks);
934 COMPARE_NODE_FIELD(setOperations);
935 COMPARE_NODE_FIELD(constraintDeps);
941 _equalInsertStmt(const InsertStmt *a, const InsertStmt *b)
943 COMPARE_NODE_FIELD(relation);
944 COMPARE_NODE_FIELD(cols);
945 COMPARE_NODE_FIELD(selectStmt);
946 COMPARE_NODE_FIELD(returningList);
947 COMPARE_NODE_FIELD(withClause);
953 _equalDeleteStmt(const DeleteStmt *a, const DeleteStmt *b)
955 COMPARE_NODE_FIELD(relation);
956 COMPARE_NODE_FIELD(usingClause);
957 COMPARE_NODE_FIELD(whereClause);
958 COMPARE_NODE_FIELD(returningList);
959 COMPARE_NODE_FIELD(withClause);
965 _equalUpdateStmt(const UpdateStmt *a, const UpdateStmt *b)
967 COMPARE_NODE_FIELD(relation);
968 COMPARE_NODE_FIELD(targetList);
969 COMPARE_NODE_FIELD(whereClause);
970 COMPARE_NODE_FIELD(fromClause);
971 COMPARE_NODE_FIELD(returningList);
972 COMPARE_NODE_FIELD(withClause);
978 _equalSelectStmt(const SelectStmt *a, const SelectStmt *b)
980 COMPARE_NODE_FIELD(distinctClause);
981 COMPARE_NODE_FIELD(intoClause);
982 COMPARE_NODE_FIELD(targetList);
983 COMPARE_NODE_FIELD(fromClause);
984 COMPARE_NODE_FIELD(whereClause);
985 COMPARE_NODE_FIELD(groupClause);
986 COMPARE_NODE_FIELD(havingClause);
987 COMPARE_NODE_FIELD(windowClause);
988 COMPARE_NODE_FIELD(valuesLists);
989 COMPARE_NODE_FIELD(sortClause);
990 COMPARE_NODE_FIELD(limitOffset);
991 COMPARE_NODE_FIELD(limitCount);
992 COMPARE_NODE_FIELD(lockingClause);
993 COMPARE_NODE_FIELD(withClause);
994 COMPARE_SCALAR_FIELD(op);
995 COMPARE_SCALAR_FIELD(all);
996 COMPARE_NODE_FIELD(larg);
997 COMPARE_NODE_FIELD(rarg);
1003 _equalSetOperationStmt(const SetOperationStmt *a, const SetOperationStmt *b)
1005 COMPARE_SCALAR_FIELD(op);
1006 COMPARE_SCALAR_FIELD(all);
1007 COMPARE_NODE_FIELD(larg);
1008 COMPARE_NODE_FIELD(rarg);
1009 COMPARE_NODE_FIELD(colTypes);
1010 COMPARE_NODE_FIELD(colTypmods);
1011 COMPARE_NODE_FIELD(colCollations);
1012 COMPARE_NODE_FIELD(groupClauses);
1018 _equalAlterTableStmt(const AlterTableStmt *a, const AlterTableStmt *b)
1020 COMPARE_NODE_FIELD(relation);
1021 COMPARE_NODE_FIELD(cmds);
1022 COMPARE_SCALAR_FIELD(relkind);
1023 COMPARE_SCALAR_FIELD(missing_ok);
1029 _equalAlterTableCmd(const AlterTableCmd *a, const AlterTableCmd *b)
1031 COMPARE_SCALAR_FIELD(subtype);
1032 COMPARE_STRING_FIELD(name);
1033 COMPARE_NODE_FIELD(def);
1034 COMPARE_SCALAR_FIELD(behavior);
1035 COMPARE_SCALAR_FIELD(missing_ok);
1041 _equalAlterDomainStmt(const AlterDomainStmt *a, const AlterDomainStmt *b)
1043 COMPARE_SCALAR_FIELD(subtype);
1044 COMPARE_NODE_FIELD(typeName);
1045 COMPARE_STRING_FIELD(name);
1046 COMPARE_NODE_FIELD(def);
1047 COMPARE_SCALAR_FIELD(behavior);
1048 COMPARE_SCALAR_FIELD(missing_ok);
1054 _equalGrantStmt(const GrantStmt *a, const GrantStmt *b)
1056 COMPARE_SCALAR_FIELD(is_grant);
1057 COMPARE_SCALAR_FIELD(targtype);
1058 COMPARE_SCALAR_FIELD(objtype);
1059 COMPARE_NODE_FIELD(objects);
1060 COMPARE_NODE_FIELD(privileges);
1061 COMPARE_NODE_FIELD(grantees);
1062 COMPARE_SCALAR_FIELD(grant_option);
1063 COMPARE_SCALAR_FIELD(behavior);
1069 _equalPrivGrantee(const PrivGrantee *a, const PrivGrantee *b)
1071 COMPARE_STRING_FIELD(rolname);
1077 _equalFuncWithArgs(const FuncWithArgs *a, const FuncWithArgs *b)
1079 COMPARE_NODE_FIELD(funcname);
1080 COMPARE_NODE_FIELD(funcargs);
1086 _equalAccessPriv(const AccessPriv *a, const AccessPriv *b)
1088 COMPARE_STRING_FIELD(priv_name);
1089 COMPARE_NODE_FIELD(cols);
1095 _equalGrantRoleStmt(const GrantRoleStmt *a, const GrantRoleStmt *b)
1097 COMPARE_NODE_FIELD(granted_roles);
1098 COMPARE_NODE_FIELD(grantee_roles);
1099 COMPARE_SCALAR_FIELD(is_grant);
1100 COMPARE_SCALAR_FIELD(admin_opt);
1101 COMPARE_STRING_FIELD(grantor);
1102 COMPARE_SCALAR_FIELD(behavior);
1108 _equalAlterDefaultPrivilegesStmt(const AlterDefaultPrivilegesStmt *a, const AlterDefaultPrivilegesStmt *b)
1110 COMPARE_NODE_FIELD(options);
1111 COMPARE_NODE_FIELD(action);
1117 _equalDeclareCursorStmt(const DeclareCursorStmt *a, const DeclareCursorStmt *b)
1119 COMPARE_STRING_FIELD(portalname);
1120 COMPARE_SCALAR_FIELD(options);
1121 COMPARE_NODE_FIELD(query);
1127 _equalClosePortalStmt(const ClosePortalStmt *a, const ClosePortalStmt *b)
1129 COMPARE_STRING_FIELD(portalname);
1135 _equalClusterStmt(const ClusterStmt *a, const ClusterStmt *b)
1137 COMPARE_NODE_FIELD(relation);
1138 COMPARE_STRING_FIELD(indexname);
1139 COMPARE_SCALAR_FIELD(verbose);
1145 _equalCopyStmt(const CopyStmt *a, const CopyStmt *b)
1147 COMPARE_NODE_FIELD(relation);
1148 COMPARE_NODE_FIELD(query);
1149 COMPARE_NODE_FIELD(attlist);
1150 COMPARE_SCALAR_FIELD(is_from);
1151 COMPARE_STRING_FIELD(filename);
1152 COMPARE_NODE_FIELD(options);
1158 _equalCreateStmt(const CreateStmt *a, const CreateStmt *b)
1160 COMPARE_NODE_FIELD(relation);
1161 COMPARE_NODE_FIELD(tableElts);
1162 COMPARE_NODE_FIELD(inhRelations);
1163 COMPARE_NODE_FIELD(ofTypename);
1164 COMPARE_NODE_FIELD(constraints);
1165 COMPARE_NODE_FIELD(options);
1166 COMPARE_SCALAR_FIELD(oncommit);
1167 COMPARE_STRING_FIELD(tablespacename);
1168 COMPARE_SCALAR_FIELD(if_not_exists);
1174 _equalTableLikeClause(const TableLikeClause *a, const TableLikeClause *b)
1176 COMPARE_NODE_FIELD(relation);
1177 COMPARE_SCALAR_FIELD(options);
1183 _equalDefineStmt(const DefineStmt *a, const DefineStmt *b)
1185 COMPARE_SCALAR_FIELD(kind);
1186 COMPARE_SCALAR_FIELD(oldstyle);
1187 COMPARE_NODE_FIELD(defnames);
1188 COMPARE_NODE_FIELD(args);
1189 COMPARE_NODE_FIELD(definition);
1195 _equalDropStmt(const DropStmt *a, const DropStmt *b)
1197 COMPARE_NODE_FIELD(objects);
1198 COMPARE_NODE_FIELD(arguments);
1199 COMPARE_SCALAR_FIELD(removeType);
1200 COMPARE_SCALAR_FIELD(behavior);
1201 COMPARE_SCALAR_FIELD(missing_ok);
1202 COMPARE_SCALAR_FIELD(concurrent);
1208 _equalTruncateStmt(const TruncateStmt *a, const TruncateStmt *b)
1210 COMPARE_NODE_FIELD(relations);
1211 COMPARE_SCALAR_FIELD(restart_seqs);
1212 COMPARE_SCALAR_FIELD(behavior);
1218 _equalCommentStmt(const CommentStmt *a, const CommentStmt *b)
1220 COMPARE_SCALAR_FIELD(objtype);
1221 COMPARE_NODE_FIELD(objname);
1222 COMPARE_NODE_FIELD(objargs);
1223 COMPARE_STRING_FIELD(comment);
1229 _equalSecLabelStmt(const SecLabelStmt *a, const SecLabelStmt *b)
1231 COMPARE_SCALAR_FIELD(objtype);
1232 COMPARE_NODE_FIELD(objname);
1233 COMPARE_NODE_FIELD(objargs);
1234 COMPARE_STRING_FIELD(provider);
1235 COMPARE_STRING_FIELD(label);
1241 _equalFetchStmt(const FetchStmt *a, const FetchStmt *b)
1243 COMPARE_SCALAR_FIELD(direction);
1244 COMPARE_SCALAR_FIELD(howMany);
1245 COMPARE_STRING_FIELD(portalname);
1246 COMPARE_SCALAR_FIELD(ismove);
1252 _equalIndexStmt(const IndexStmt *a, const IndexStmt *b)
1254 COMPARE_STRING_FIELD(idxname);
1255 COMPARE_NODE_FIELD(relation);
1256 COMPARE_STRING_FIELD(accessMethod);
1257 COMPARE_STRING_FIELD(tableSpace);
1258 COMPARE_NODE_FIELD(indexParams);
1259 COMPARE_NODE_FIELD(options);
1260 COMPARE_NODE_FIELD(whereClause);
1261 COMPARE_NODE_FIELD(excludeOpNames);
1262 COMPARE_STRING_FIELD(idxcomment);
1263 COMPARE_SCALAR_FIELD(indexOid);
1264 COMPARE_SCALAR_FIELD(oldNode);
1265 COMPARE_SCALAR_FIELD(unique);
1266 COMPARE_SCALAR_FIELD(primary);
1267 COMPARE_SCALAR_FIELD(isconstraint);
1268 COMPARE_SCALAR_FIELD(deferrable);
1269 COMPARE_SCALAR_FIELD(initdeferred);
1270 COMPARE_SCALAR_FIELD(concurrent);
1276 _equalCreateFunctionStmt(const CreateFunctionStmt *a, const CreateFunctionStmt *b)
1278 COMPARE_SCALAR_FIELD(replace);
1279 COMPARE_NODE_FIELD(funcname);
1280 COMPARE_NODE_FIELD(parameters);
1281 COMPARE_NODE_FIELD(returnType);
1282 COMPARE_NODE_FIELD(options);
1283 COMPARE_NODE_FIELD(withClause);
1289 _equalFunctionParameter(const FunctionParameter *a, const FunctionParameter *b)
1291 COMPARE_STRING_FIELD(name);
1292 COMPARE_NODE_FIELD(argType);
1293 COMPARE_SCALAR_FIELD(mode);
1294 COMPARE_NODE_FIELD(defexpr);
1300 _equalAlterFunctionStmt(const AlterFunctionStmt *a, const AlterFunctionStmt *b)
1302 COMPARE_NODE_FIELD(func);
1303 COMPARE_NODE_FIELD(actions);
1309 _equalDoStmt(const DoStmt *a, const DoStmt *b)
1311 COMPARE_NODE_FIELD(args);
1317 _equalRenameStmt(const RenameStmt *a, const RenameStmt *b)
1319 COMPARE_SCALAR_FIELD(renameType);
1320 COMPARE_SCALAR_FIELD(relationType);
1321 COMPARE_NODE_FIELD(relation);
1322 COMPARE_NODE_FIELD(object);
1323 COMPARE_NODE_FIELD(objarg);
1324 COMPARE_STRING_FIELD(subname);
1325 COMPARE_STRING_FIELD(newname);
1326 COMPARE_SCALAR_FIELD(behavior);
1327 COMPARE_SCALAR_FIELD(missing_ok);
1333 _equalAlterObjectSchemaStmt(const AlterObjectSchemaStmt *a, const AlterObjectSchemaStmt *b)
1335 COMPARE_SCALAR_FIELD(objectType);
1336 COMPARE_NODE_FIELD(relation);
1337 COMPARE_NODE_FIELD(object);
1338 COMPARE_NODE_FIELD(objarg);
1339 COMPARE_STRING_FIELD(newschema);
1340 COMPARE_SCALAR_FIELD(missing_ok);
1346 _equalAlterOwnerStmt(const AlterOwnerStmt *a, const AlterOwnerStmt *b)
1348 COMPARE_SCALAR_FIELD(objectType);
1349 COMPARE_NODE_FIELD(relation);
1350 COMPARE_NODE_FIELD(object);
1351 COMPARE_NODE_FIELD(objarg);
1352 COMPARE_STRING_FIELD(newowner);
1358 _equalRuleStmt(const RuleStmt *a, const RuleStmt *b)
1360 COMPARE_NODE_FIELD(relation);
1361 COMPARE_STRING_FIELD(rulename);
1362 COMPARE_NODE_FIELD(whereClause);
1363 COMPARE_SCALAR_FIELD(event);
1364 COMPARE_SCALAR_FIELD(instead);
1365 COMPARE_NODE_FIELD(actions);
1366 COMPARE_SCALAR_FIELD(replace);
1372 _equalNotifyStmt(const NotifyStmt *a, const NotifyStmt *b)
1374 COMPARE_STRING_FIELD(conditionname);
1375 COMPARE_STRING_FIELD(payload);
1381 _equalListenStmt(const ListenStmt *a, const ListenStmt *b)
1383 COMPARE_STRING_FIELD(conditionname);
1389 _equalUnlistenStmt(const UnlistenStmt *a, const UnlistenStmt *b)
1391 COMPARE_STRING_FIELD(conditionname);
1397 _equalTransactionStmt(const TransactionStmt *a, const TransactionStmt *b)
1399 COMPARE_SCALAR_FIELD(kind);
1400 COMPARE_NODE_FIELD(options);
1401 COMPARE_STRING_FIELD(gid);
1407 _equalCompositeTypeStmt(const CompositeTypeStmt *a, const CompositeTypeStmt *b)
1409 COMPARE_NODE_FIELD(typevar);
1410 COMPARE_NODE_FIELD(coldeflist);
1416 _equalCreateEnumStmt(const CreateEnumStmt *a, const CreateEnumStmt *b)
1418 COMPARE_NODE_FIELD(typeName);
1419 COMPARE_NODE_FIELD(vals);
1425 _equalCreateRangeStmt(const CreateRangeStmt *a, const CreateRangeStmt *b)
1427 COMPARE_NODE_FIELD(typeName);
1428 COMPARE_NODE_FIELD(params);
1434 _equalAlterEnumStmt(const AlterEnumStmt *a, const AlterEnumStmt *b)
1436 COMPARE_NODE_FIELD(typeName);
1437 COMPARE_STRING_FIELD(newVal);
1438 COMPARE_STRING_FIELD(newValNeighbor);
1439 COMPARE_SCALAR_FIELD(newValIsAfter);
1440 COMPARE_SCALAR_FIELD(skipIfExists);
1446 _equalViewStmt(const ViewStmt *a, const ViewStmt *b)
1448 COMPARE_NODE_FIELD(view);
1449 COMPARE_NODE_FIELD(aliases);
1450 COMPARE_NODE_FIELD(query);
1451 COMPARE_SCALAR_FIELD(replace);
1452 COMPARE_NODE_FIELD(options);
1458 _equalLoadStmt(const LoadStmt *a, const LoadStmt *b)
1460 COMPARE_STRING_FIELD(filename);
1466 _equalCreateDomainStmt(const CreateDomainStmt *a, const CreateDomainStmt *b)
1468 COMPARE_NODE_FIELD(domainname);
1469 COMPARE_NODE_FIELD(typeName);
1470 COMPARE_NODE_FIELD(collClause);
1471 COMPARE_NODE_FIELD(constraints);
1477 _equalCreateOpClassStmt(const CreateOpClassStmt *a, const CreateOpClassStmt *b)
1479 COMPARE_NODE_FIELD(opclassname);
1480 COMPARE_NODE_FIELD(opfamilyname);
1481 COMPARE_STRING_FIELD(amname);
1482 COMPARE_NODE_FIELD(datatype);
1483 COMPARE_NODE_FIELD(items);
1484 COMPARE_SCALAR_FIELD(isDefault);
1490 _equalCreateOpClassItem(const CreateOpClassItem *a, const CreateOpClassItem *b)
1492 COMPARE_SCALAR_FIELD(itemtype);
1493 COMPARE_NODE_FIELD(name);
1494 COMPARE_NODE_FIELD(args);
1495 COMPARE_SCALAR_FIELD(number);
1496 COMPARE_NODE_FIELD(order_family);
1497 COMPARE_NODE_FIELD(class_args);
1498 COMPARE_NODE_FIELD(storedtype);
1504 _equalCreateOpFamilyStmt(const CreateOpFamilyStmt *a, const CreateOpFamilyStmt *b)
1506 COMPARE_NODE_FIELD(opfamilyname);
1507 COMPARE_STRING_FIELD(amname);
1513 _equalAlterOpFamilyStmt(const AlterOpFamilyStmt *a, const AlterOpFamilyStmt *b)
1515 COMPARE_NODE_FIELD(opfamilyname);
1516 COMPARE_STRING_FIELD(amname);
1517 COMPARE_SCALAR_FIELD(isDrop);
1518 COMPARE_NODE_FIELD(items);
1524 _equalCreatedbStmt(const CreatedbStmt *a, const CreatedbStmt *b)
1526 COMPARE_STRING_FIELD(dbname);
1527 COMPARE_NODE_FIELD(options);
1533 _equalAlterDatabaseStmt(const AlterDatabaseStmt *a, const AlterDatabaseStmt *b)
1535 COMPARE_STRING_FIELD(dbname);
1536 COMPARE_NODE_FIELD(options);
1542 _equalAlterDatabaseSetStmt(const AlterDatabaseSetStmt *a, const AlterDatabaseSetStmt *b)
1544 COMPARE_STRING_FIELD(dbname);
1545 COMPARE_NODE_FIELD(setstmt);
1551 _equalDropdbStmt(const DropdbStmt *a, const DropdbStmt *b)
1553 COMPARE_STRING_FIELD(dbname);
1554 COMPARE_SCALAR_FIELD(missing_ok);
1560 _equalVacuumStmt(const VacuumStmt *a, const VacuumStmt *b)
1562 COMPARE_SCALAR_FIELD(options);
1563 COMPARE_SCALAR_FIELD(freeze_min_age);
1564 COMPARE_SCALAR_FIELD(freeze_table_age);
1565 COMPARE_NODE_FIELD(relation);
1566 COMPARE_NODE_FIELD(va_cols);
1572 _equalExplainStmt(const ExplainStmt *a, const ExplainStmt *b)
1574 COMPARE_NODE_FIELD(query);
1575 COMPARE_NODE_FIELD(options);
1581 _equalCreateTableAsStmt(const CreateTableAsStmt *a, const CreateTableAsStmt *b)
1583 COMPARE_NODE_FIELD(query);
1584 COMPARE_NODE_FIELD(into);
1585 COMPARE_SCALAR_FIELD(is_select_into);
1591 _equalCreateSeqStmt(const CreateSeqStmt *a, const CreateSeqStmt *b)
1593 COMPARE_NODE_FIELD(sequence);
1594 COMPARE_NODE_FIELD(options);
1595 COMPARE_SCALAR_FIELD(ownerId);
1601 _equalAlterSeqStmt(const AlterSeqStmt *a, const AlterSeqStmt *b)
1603 COMPARE_NODE_FIELD(sequence);
1604 COMPARE_NODE_FIELD(options);
1605 COMPARE_SCALAR_FIELD(missing_ok);
1611 _equalVariableSetStmt(const VariableSetStmt *a, const VariableSetStmt *b)
1613 COMPARE_SCALAR_FIELD(kind);
1614 COMPARE_STRING_FIELD(name);
1615 COMPARE_NODE_FIELD(args);
1616 COMPARE_SCALAR_FIELD(is_local);
1622 _equalVariableShowStmt(const VariableShowStmt *a, const VariableShowStmt *b)
1624 COMPARE_STRING_FIELD(name);
1630 _equalDiscardStmt(const DiscardStmt *a, const DiscardStmt *b)
1632 COMPARE_SCALAR_FIELD(target);
1638 _equalCreateTableSpaceStmt(const CreateTableSpaceStmt *a, const CreateTableSpaceStmt *b)
1640 COMPARE_STRING_FIELD(tablespacename);
1641 COMPARE_STRING_FIELD(owner);
1642 COMPARE_STRING_FIELD(location);
1648 _equalDropTableSpaceStmt(const DropTableSpaceStmt *a, const DropTableSpaceStmt *b)
1650 COMPARE_STRING_FIELD(tablespacename);
1651 COMPARE_SCALAR_FIELD(missing_ok);
1657 _equalAlterTableSpaceOptionsStmt(const AlterTableSpaceOptionsStmt *a,
1658 const AlterTableSpaceOptionsStmt *b)
1660 COMPARE_STRING_FIELD(tablespacename);
1661 COMPARE_NODE_FIELD(options);
1662 COMPARE_SCALAR_FIELD(isReset);
1668 _equalCreateExtensionStmt(const CreateExtensionStmt *a, const CreateExtensionStmt *b)
1670 COMPARE_STRING_FIELD(extname);
1671 COMPARE_SCALAR_FIELD(if_not_exists);
1672 COMPARE_NODE_FIELD(options);
1678 _equalAlterExtensionStmt(const AlterExtensionStmt *a, const AlterExtensionStmt *b)
1680 COMPARE_STRING_FIELD(extname);
1681 COMPARE_NODE_FIELD(options);
1687 _equalAlterExtensionContentsStmt(const AlterExtensionContentsStmt *a, const AlterExtensionContentsStmt *b)
1689 COMPARE_STRING_FIELD(extname);
1690 COMPARE_SCALAR_FIELD(action);
1691 COMPARE_SCALAR_FIELD(objtype);
1692 COMPARE_NODE_FIELD(objname);
1693 COMPARE_NODE_FIELD(objargs);
1699 _equalCreateFdwStmt(const CreateFdwStmt *a, const CreateFdwStmt *b)
1701 COMPARE_STRING_FIELD(fdwname);
1702 COMPARE_NODE_FIELD(func_options);
1703 COMPARE_NODE_FIELD(options);
1709 _equalAlterFdwStmt(const AlterFdwStmt *a, const AlterFdwStmt *b)
1711 COMPARE_STRING_FIELD(fdwname);
1712 COMPARE_NODE_FIELD(func_options);
1713 COMPARE_NODE_FIELD(options);
1719 _equalCreateForeignServerStmt(const CreateForeignServerStmt *a, const CreateForeignServerStmt *b)
1721 COMPARE_STRING_FIELD(servername);
1722 COMPARE_STRING_FIELD(servertype);
1723 COMPARE_STRING_FIELD(version);
1724 COMPARE_STRING_FIELD(fdwname);
1725 COMPARE_NODE_FIELD(options);
1731 _equalAlterForeignServerStmt(const AlterForeignServerStmt *a, const AlterForeignServerStmt *b)
1733 COMPARE_STRING_FIELD(servername);
1734 COMPARE_STRING_FIELD(version);
1735 COMPARE_NODE_FIELD(options);
1736 COMPARE_SCALAR_FIELD(has_version);
1742 _equalCreateUserMappingStmt(const CreateUserMappingStmt *a, const CreateUserMappingStmt *b)
1744 COMPARE_STRING_FIELD(username);
1745 COMPARE_STRING_FIELD(servername);
1746 COMPARE_NODE_FIELD(options);
1752 _equalAlterUserMappingStmt(const AlterUserMappingStmt *a, const AlterUserMappingStmt *b)
1754 COMPARE_STRING_FIELD(username);
1755 COMPARE_STRING_FIELD(servername);
1756 COMPARE_NODE_FIELD(options);
1762 _equalDropUserMappingStmt(const DropUserMappingStmt *a, const DropUserMappingStmt *b)
1764 COMPARE_STRING_FIELD(username);
1765 COMPARE_STRING_FIELD(servername);
1766 COMPARE_SCALAR_FIELD(missing_ok);
1772 _equalCreateForeignTableStmt(const CreateForeignTableStmt *a, const CreateForeignTableStmt *b)
1774 if (!_equalCreateStmt(&a->base, &b->base))
1777 COMPARE_STRING_FIELD(servername);
1778 COMPARE_NODE_FIELD(options);
1784 _equalCreateTrigStmt(const CreateTrigStmt *a, const CreateTrigStmt *b)
1786 COMPARE_STRING_FIELD(trigname);
1787 COMPARE_NODE_FIELD(relation);
1788 COMPARE_NODE_FIELD(funcname);
1789 COMPARE_NODE_FIELD(args);
1790 COMPARE_SCALAR_FIELD(row);
1791 COMPARE_SCALAR_FIELD(timing);
1792 COMPARE_SCALAR_FIELD(events);
1793 COMPARE_NODE_FIELD(columns);
1794 COMPARE_NODE_FIELD(whenClause);
1795 COMPARE_SCALAR_FIELD(isconstraint);
1796 COMPARE_SCALAR_FIELD(deferrable);
1797 COMPARE_SCALAR_FIELD(initdeferred);
1798 COMPARE_NODE_FIELD(constrrel);
1804 _equalCreateEventTrigStmt(const CreateEventTrigStmt *a, const CreateEventTrigStmt *b)
1806 COMPARE_STRING_FIELD(trigname);
1807 COMPARE_SCALAR_FIELD(eventname);
1808 COMPARE_NODE_FIELD(funcname);
1809 COMPARE_NODE_FIELD(whenclause);
1815 _equalAlterEventTrigStmt(const AlterEventTrigStmt *a, const AlterEventTrigStmt *b)
1817 COMPARE_STRING_FIELD(trigname);
1818 COMPARE_SCALAR_FIELD(tgenabled);
1824 _equalCreatePLangStmt(const CreatePLangStmt *a, const CreatePLangStmt *b)
1826 COMPARE_SCALAR_FIELD(replace);
1827 COMPARE_STRING_FIELD(plname);
1828 COMPARE_NODE_FIELD(plhandler);
1829 COMPARE_NODE_FIELD(plinline);
1830 COMPARE_NODE_FIELD(plvalidator);
1831 COMPARE_SCALAR_FIELD(pltrusted);
1837 _equalCreateRoleStmt(const CreateRoleStmt *a, const CreateRoleStmt *b)
1839 COMPARE_SCALAR_FIELD(stmt_type);
1840 COMPARE_STRING_FIELD(role);
1841 COMPARE_NODE_FIELD(options);
1847 _equalAlterRoleStmt(const AlterRoleStmt *a, const AlterRoleStmt *b)
1849 COMPARE_STRING_FIELD(role);
1850 COMPARE_NODE_FIELD(options);
1851 COMPARE_SCALAR_FIELD(action);
1857 _equalAlterRoleSetStmt(const AlterRoleSetStmt *a, const AlterRoleSetStmt *b)
1859 COMPARE_STRING_FIELD(role);
1860 COMPARE_STRING_FIELD(database);
1861 COMPARE_NODE_FIELD(setstmt);
1867 _equalDropRoleStmt(const DropRoleStmt *a, const DropRoleStmt *b)
1869 COMPARE_NODE_FIELD(roles);
1870 COMPARE_SCALAR_FIELD(missing_ok);
1876 _equalLockStmt(const LockStmt *a, const LockStmt *b)
1878 COMPARE_NODE_FIELD(relations);
1879 COMPARE_SCALAR_FIELD(mode);
1880 COMPARE_SCALAR_FIELD(nowait);
1886 _equalConstraintsSetStmt(const ConstraintsSetStmt *a, const ConstraintsSetStmt *b)
1888 COMPARE_NODE_FIELD(constraints);
1889 COMPARE_SCALAR_FIELD(deferred);
1895 _equalReindexStmt(const ReindexStmt *a, const ReindexStmt *b)
1897 COMPARE_SCALAR_FIELD(kind);
1898 COMPARE_NODE_FIELD(relation);
1899 COMPARE_STRING_FIELD(name);
1900 COMPARE_SCALAR_FIELD(do_system);
1901 COMPARE_SCALAR_FIELD(do_user);
1907 _equalCreateSchemaStmt(const CreateSchemaStmt *a, const CreateSchemaStmt *b)
1909 COMPARE_STRING_FIELD(schemaname);
1910 COMPARE_STRING_FIELD(authid);
1911 COMPARE_NODE_FIELD(schemaElts);
1912 COMPARE_SCALAR_FIELD(if_not_exists);
1918 _equalCreateConversionStmt(const CreateConversionStmt *a, const CreateConversionStmt *b)
1920 COMPARE_NODE_FIELD(conversion_name);
1921 COMPARE_STRING_FIELD(for_encoding_name);
1922 COMPARE_STRING_FIELD(to_encoding_name);
1923 COMPARE_NODE_FIELD(func_name);
1924 COMPARE_SCALAR_FIELD(def);
1930 _equalCreateCastStmt(const CreateCastStmt *a, const CreateCastStmt *b)
1932 COMPARE_NODE_FIELD(sourcetype);
1933 COMPARE_NODE_FIELD(targettype);
1934 COMPARE_NODE_FIELD(func);
1935 COMPARE_SCALAR_FIELD(context);
1936 COMPARE_SCALAR_FIELD(inout);
1942 _equalPrepareStmt(const PrepareStmt *a, const PrepareStmt *b)
1944 COMPARE_STRING_FIELD(name);
1945 COMPARE_NODE_FIELD(argtypes);
1946 COMPARE_NODE_FIELD(query);
1952 _equalExecuteStmt(const ExecuteStmt *a, const ExecuteStmt *b)
1954 COMPARE_STRING_FIELD(name);
1955 COMPARE_NODE_FIELD(params);
1961 _equalDeallocateStmt(const DeallocateStmt *a, const DeallocateStmt *b)
1963 COMPARE_STRING_FIELD(name);
1969 _equalDropOwnedStmt(const DropOwnedStmt *a, const DropOwnedStmt *b)
1971 COMPARE_NODE_FIELD(roles);
1972 COMPARE_SCALAR_FIELD(behavior);
1978 _equalReassignOwnedStmt(const ReassignOwnedStmt *a, const ReassignOwnedStmt *b)
1980 COMPARE_NODE_FIELD(roles);
1981 COMPARE_STRING_FIELD(newrole);
1987 _equalAlterTSDictionaryStmt(const AlterTSDictionaryStmt *a, const AlterTSDictionaryStmt *b)
1989 COMPARE_NODE_FIELD(dictname);
1990 COMPARE_NODE_FIELD(options);
1996 _equalAlterTSConfigurationStmt(const AlterTSConfigurationStmt *a,
1997 const AlterTSConfigurationStmt *b)
1999 COMPARE_NODE_FIELD(cfgname);
2000 COMPARE_NODE_FIELD(tokentype);
2001 COMPARE_NODE_FIELD(dicts);
2002 COMPARE_SCALAR_FIELD(override);
2003 COMPARE_SCALAR_FIELD(replace);
2004 COMPARE_SCALAR_FIELD(missing_ok);
2010 _equalAExpr(const A_Expr *a, const A_Expr *b)
2012 COMPARE_SCALAR_FIELD(kind);
2013 COMPARE_NODE_FIELD(name);
2014 COMPARE_NODE_FIELD(lexpr);
2015 COMPARE_NODE_FIELD(rexpr);
2016 COMPARE_LOCATION_FIELD(location);
2022 _equalColumnRef(const ColumnRef *a, const ColumnRef *b)
2024 COMPARE_NODE_FIELD(fields);
2025 COMPARE_LOCATION_FIELD(location);
2031 _equalParamRef(const ParamRef *a, const ParamRef *b)
2033 COMPARE_SCALAR_FIELD(number);
2034 COMPARE_LOCATION_FIELD(location);
2040 _equalAConst(const A_Const *a, const A_Const *b)
2042 if (!equal(&a->val, &b->val)) /* hack for in-line Value field */
2044 COMPARE_LOCATION_FIELD(location);
2050 _equalFuncCall(const FuncCall *a, const FuncCall *b)
2052 COMPARE_NODE_FIELD(funcname);
2053 COMPARE_NODE_FIELD(args);
2054 COMPARE_NODE_FIELD(agg_order);
2055 COMPARE_SCALAR_FIELD(agg_star);
2056 COMPARE_SCALAR_FIELD(agg_distinct);
2057 COMPARE_SCALAR_FIELD(func_variadic);
2058 COMPARE_NODE_FIELD(over);
2059 COMPARE_LOCATION_FIELD(location);
2065 _equalAStar(const A_Star *a, const A_Star *b)
2071 _equalAIndices(const A_Indices *a, const A_Indices *b)
2073 COMPARE_NODE_FIELD(lidx);
2074 COMPARE_NODE_FIELD(uidx);
2080 _equalA_Indirection(const A_Indirection *a, const A_Indirection *b)
2082 COMPARE_NODE_FIELD(arg);
2083 COMPARE_NODE_FIELD(indirection);
2089 _equalA_ArrayExpr(const A_ArrayExpr *a, const A_ArrayExpr *b)
2091 COMPARE_NODE_FIELD(elements);
2092 COMPARE_LOCATION_FIELD(location);
2098 _equalResTarget(const ResTarget *a, const ResTarget *b)
2100 COMPARE_STRING_FIELD(name);
2101 COMPARE_NODE_FIELD(indirection);
2102 COMPARE_NODE_FIELD(val);
2103 COMPARE_LOCATION_FIELD(location);
2109 _equalTypeName(const TypeName *a, const TypeName *b)
2111 COMPARE_NODE_FIELD(names);
2112 COMPARE_SCALAR_FIELD(typeOid);
2113 COMPARE_SCALAR_FIELD(setof);
2114 COMPARE_SCALAR_FIELD(pct_type);
2115 COMPARE_NODE_FIELD(typmods);
2116 COMPARE_SCALAR_FIELD(typemod);
2117 COMPARE_NODE_FIELD(arrayBounds);
2118 COMPARE_LOCATION_FIELD(location);
2124 _equalTypeCast(const TypeCast *a, const TypeCast *b)
2126 COMPARE_NODE_FIELD(arg);
2127 COMPARE_NODE_FIELD(typeName);
2128 COMPARE_LOCATION_FIELD(location);
2134 _equalCollateClause(const CollateClause *a, const CollateClause *b)
2136 COMPARE_NODE_FIELD(arg);
2137 COMPARE_NODE_FIELD(collname);
2138 COMPARE_LOCATION_FIELD(location);
2144 _equalSortBy(const SortBy *a, const SortBy *b)
2146 COMPARE_NODE_FIELD(node);
2147 COMPARE_SCALAR_FIELD(sortby_dir);
2148 COMPARE_SCALAR_FIELD(sortby_nulls);
2149 COMPARE_NODE_FIELD(useOp);
2150 COMPARE_LOCATION_FIELD(location);
2156 _equalWindowDef(const WindowDef *a, const WindowDef *b)
2158 COMPARE_STRING_FIELD(name);
2159 COMPARE_STRING_FIELD(refname);
2160 COMPARE_NODE_FIELD(partitionClause);
2161 COMPARE_NODE_FIELD(orderClause);
2162 COMPARE_SCALAR_FIELD(frameOptions);
2163 COMPARE_NODE_FIELD(startOffset);
2164 COMPARE_NODE_FIELD(endOffset);
2165 COMPARE_LOCATION_FIELD(location);
2171 _equalRangeSubselect(const RangeSubselect *a, const RangeSubselect *b)
2173 COMPARE_SCALAR_FIELD(lateral);
2174 COMPARE_NODE_FIELD(subquery);
2175 COMPARE_NODE_FIELD(alias);
2181 _equalRangeFunction(const RangeFunction *a, const RangeFunction *b)
2183 COMPARE_SCALAR_FIELD(lateral);
2184 COMPARE_NODE_FIELD(funccallnode);
2185 COMPARE_NODE_FIELD(alias);
2186 COMPARE_NODE_FIELD(coldeflist);
2192 _equalIndexElem(const IndexElem *a, const IndexElem *b)
2194 COMPARE_STRING_FIELD(name);
2195 COMPARE_NODE_FIELD(expr);
2196 COMPARE_STRING_FIELD(indexcolname);
2197 COMPARE_NODE_FIELD(collation);
2198 COMPARE_NODE_FIELD(opclass);
2199 COMPARE_SCALAR_FIELD(ordering);
2200 COMPARE_SCALAR_FIELD(nulls_ordering);
2206 _equalColumnDef(const ColumnDef *a, const ColumnDef *b)
2208 COMPARE_STRING_FIELD(colname);
2209 COMPARE_NODE_FIELD(typeName);
2210 COMPARE_SCALAR_FIELD(inhcount);
2211 COMPARE_SCALAR_FIELD(is_local);
2212 COMPARE_SCALAR_FIELD(is_not_null);
2213 COMPARE_SCALAR_FIELD(is_from_type);
2214 COMPARE_SCALAR_FIELD(storage);
2215 COMPARE_NODE_FIELD(raw_default);
2216 COMPARE_NODE_FIELD(cooked_default);
2217 COMPARE_NODE_FIELD(collClause);
2218 COMPARE_SCALAR_FIELD(collOid);
2219 COMPARE_NODE_FIELD(constraints);
2220 COMPARE_NODE_FIELD(fdwoptions);
2226 _equalConstraint(const Constraint *a, const Constraint *b)
2228 COMPARE_SCALAR_FIELD(contype);
2229 COMPARE_STRING_FIELD(conname);
2230 COMPARE_SCALAR_FIELD(deferrable);
2231 COMPARE_SCALAR_FIELD(initdeferred);
2232 COMPARE_LOCATION_FIELD(location);
2233 COMPARE_SCALAR_FIELD(is_no_inherit);
2234 COMPARE_NODE_FIELD(raw_expr);
2235 COMPARE_STRING_FIELD(cooked_expr);
2236 COMPARE_NODE_FIELD(keys);
2237 COMPARE_NODE_FIELD(exclusions);
2238 COMPARE_NODE_FIELD(options);
2239 COMPARE_STRING_FIELD(indexname);
2240 COMPARE_STRING_FIELD(indexspace);
2241 COMPARE_STRING_FIELD(access_method);
2242 COMPARE_NODE_FIELD(where_clause);
2243 COMPARE_NODE_FIELD(pktable);
2244 COMPARE_NODE_FIELD(fk_attrs);
2245 COMPARE_NODE_FIELD(pk_attrs);
2246 COMPARE_SCALAR_FIELD(fk_matchtype);
2247 COMPARE_SCALAR_FIELD(fk_upd_action);
2248 COMPARE_SCALAR_FIELD(fk_del_action);
2249 COMPARE_NODE_FIELD(old_conpfeqop);
2250 COMPARE_SCALAR_FIELD(skip_validation);
2251 COMPARE_SCALAR_FIELD(initially_valid);
2257 _equalDefElem(const DefElem *a, const DefElem *b)
2259 COMPARE_STRING_FIELD(defnamespace);
2260 COMPARE_STRING_FIELD(defname);
2261 COMPARE_NODE_FIELD(arg);
2262 COMPARE_SCALAR_FIELD(defaction);
2268 _equalLockingClause(const LockingClause *a, const LockingClause *b)
2270 COMPARE_NODE_FIELD(lockedRels);
2271 COMPARE_SCALAR_FIELD(forUpdate);
2272 COMPARE_SCALAR_FIELD(noWait);
2278 _equalRangeTblEntry(const RangeTblEntry *a, const RangeTblEntry *b)
2280 COMPARE_SCALAR_FIELD(rtekind);
2281 COMPARE_SCALAR_FIELD(relid);
2282 COMPARE_SCALAR_FIELD(relkind);
2283 COMPARE_NODE_FIELD(subquery);
2284 COMPARE_SCALAR_FIELD(security_barrier);
2285 COMPARE_SCALAR_FIELD(jointype);
2286 COMPARE_NODE_FIELD(joinaliasvars);
2287 COMPARE_NODE_FIELD(funcexpr);
2288 COMPARE_NODE_FIELD(funccoltypes);
2289 COMPARE_NODE_FIELD(funccoltypmods);
2290 COMPARE_NODE_FIELD(funccolcollations);
2291 COMPARE_NODE_FIELD(values_lists);
2292 COMPARE_NODE_FIELD(values_collations);
2293 COMPARE_STRING_FIELD(ctename);
2294 COMPARE_SCALAR_FIELD(ctelevelsup);
2295 COMPARE_SCALAR_FIELD(self_reference);
2296 COMPARE_NODE_FIELD(ctecoltypes);
2297 COMPARE_NODE_FIELD(ctecoltypmods);
2298 COMPARE_NODE_FIELD(ctecolcollations);
2299 COMPARE_NODE_FIELD(alias);
2300 COMPARE_NODE_FIELD(eref);
2301 COMPARE_SCALAR_FIELD(lateral);
2302 COMPARE_SCALAR_FIELD(inh);
2303 COMPARE_SCALAR_FIELD(inFromCl);
2304 COMPARE_SCALAR_FIELD(requiredPerms);
2305 COMPARE_SCALAR_FIELD(checkAsUser);
2306 COMPARE_BITMAPSET_FIELD(selectedCols);
2307 COMPARE_BITMAPSET_FIELD(modifiedCols);
2313 _equalSortGroupClause(const SortGroupClause *a, const SortGroupClause *b)
2315 COMPARE_SCALAR_FIELD(tleSortGroupRef);
2316 COMPARE_SCALAR_FIELD(eqop);
2317 COMPARE_SCALAR_FIELD(sortop);
2318 COMPARE_SCALAR_FIELD(nulls_first);
2319 COMPARE_SCALAR_FIELD(hashable);
2325 _equalWindowClause(const WindowClause *a, const WindowClause *b)
2327 COMPARE_STRING_FIELD(name);
2328 COMPARE_STRING_FIELD(refname);
2329 COMPARE_NODE_FIELD(partitionClause);
2330 COMPARE_NODE_FIELD(orderClause);
2331 COMPARE_SCALAR_FIELD(frameOptions);
2332 COMPARE_NODE_FIELD(startOffset);
2333 COMPARE_NODE_FIELD(endOffset);
2334 COMPARE_SCALAR_FIELD(winref);
2335 COMPARE_SCALAR_FIELD(copiedOrder);
2341 _equalRowMarkClause(const RowMarkClause *a, const RowMarkClause *b)
2343 COMPARE_SCALAR_FIELD(rti);
2344 COMPARE_SCALAR_FIELD(forUpdate);
2345 COMPARE_SCALAR_FIELD(noWait);
2346 COMPARE_SCALAR_FIELD(pushedDown);
2352 _equalWithClause(const WithClause *a, const WithClause *b)
2354 COMPARE_NODE_FIELD(ctes);
2355 COMPARE_SCALAR_FIELD(recursive);
2356 COMPARE_LOCATION_FIELD(location);
2362 _equalCommonTableExpr(const CommonTableExpr *a, const CommonTableExpr *b)
2364 COMPARE_STRING_FIELD(ctename);
2365 COMPARE_NODE_FIELD(aliascolnames);
2366 COMPARE_NODE_FIELD(ctequery);
2367 COMPARE_LOCATION_FIELD(location);
2368 COMPARE_SCALAR_FIELD(cterecursive);
2369 COMPARE_SCALAR_FIELD(cterefcount);
2370 COMPARE_NODE_FIELD(ctecolnames);
2371 COMPARE_NODE_FIELD(ctecoltypes);
2372 COMPARE_NODE_FIELD(ctecoltypmods);
2373 COMPARE_NODE_FIELD(ctecolcollations);
2379 _equalXmlSerialize(const XmlSerialize *a, const XmlSerialize *b)
2381 COMPARE_SCALAR_FIELD(xmloption);
2382 COMPARE_NODE_FIELD(expr);
2383 COMPARE_NODE_FIELD(typeName);
2384 COMPARE_LOCATION_FIELD(location);
2390 * Stuff from pg_list.h
2394 _equalList(const List *a, const List *b)
2396 const ListCell *item_a;
2397 const ListCell *item_b;
2400 * Try to reject by simple scalar checks before grovelling through all the
2403 COMPARE_SCALAR_FIELD(type);
2404 COMPARE_SCALAR_FIELD(length);
2407 * We place the switch outside the loop for the sake of efficiency; this
2408 * may not be worth doing...
2413 forboth(item_a, a, item_b, b)
2415 if (!equal(lfirst(item_a), lfirst(item_b)))
2420 forboth(item_a, a, item_b, b)
2422 if (lfirst_int(item_a) != lfirst_int(item_b))
2427 forboth(item_a, a, item_b, b)
2429 if (lfirst_oid(item_a) != lfirst_oid(item_b))
2434 elog(ERROR, "unrecognized list node type: %d",
2436 return false; /* keep compiler quiet */
2440 * If we got here, we should have run out of elements of both lists
2442 Assert(item_a == NULL);
2443 Assert(item_b == NULL);
2449 * Stuff from value.h
2453 _equalValue(const Value *a, const Value *b)
2455 COMPARE_SCALAR_FIELD(type);
2460 COMPARE_SCALAR_FIELD(val.ival);
2465 COMPARE_STRING_FIELD(val.str);
2471 elog(ERROR, "unrecognized node type: %d", (int) a->type);
2480 * returns whether two nodes are equal
2483 equal(const void *a, const void *b)
2491 * note that a!=b, so only one of them can be NULL
2493 if (a == NULL || b == NULL)
2497 * are they the same type of nodes?
2499 if (nodeTag(a) != nodeTag(b))
2508 retval = _equalAlias(a, b);
2511 retval = _equalRangeVar(a, b);
2514 retval = _equalIntoClause(a, b);
2517 retval = _equalVar(a, b);
2520 retval = _equalConst(a, b);
2523 retval = _equalParam(a, b);
2526 retval = _equalAggref(a, b);
2529 retval = _equalWindowFunc(a, b);
2532 retval = _equalArrayRef(a, b);
2535 retval = _equalFuncExpr(a, b);
2537 case T_NamedArgExpr:
2538 retval = _equalNamedArgExpr(a, b);
2541 retval = _equalOpExpr(a, b);
2543 case T_DistinctExpr:
2544 retval = _equalDistinctExpr(a, b);
2547 retval = _equalNullIfExpr(a, b);
2549 case T_ScalarArrayOpExpr:
2550 retval = _equalScalarArrayOpExpr(a, b);
2553 retval = _equalBoolExpr(a, b);
2556 retval = _equalSubLink(a, b);
2559 retval = _equalSubPlan(a, b);
2561 case T_AlternativeSubPlan:
2562 retval = _equalAlternativeSubPlan(a, b);
2565 retval = _equalFieldSelect(a, b);
2568 retval = _equalFieldStore(a, b);
2571 retval = _equalRelabelType(a, b);
2574 retval = _equalCoerceViaIO(a, b);
2576 case T_ArrayCoerceExpr:
2577 retval = _equalArrayCoerceExpr(a, b);
2579 case T_ConvertRowtypeExpr:
2580 retval = _equalConvertRowtypeExpr(a, b);
2583 retval = _equalCollateExpr(a, b);
2586 retval = _equalCaseExpr(a, b);
2589 retval = _equalCaseWhen(a, b);
2591 case T_CaseTestExpr:
2592 retval = _equalCaseTestExpr(a, b);
2595 retval = _equalArrayExpr(a, b);
2598 retval = _equalRowExpr(a, b);
2600 case T_RowCompareExpr:
2601 retval = _equalRowCompareExpr(a, b);
2603 case T_CoalesceExpr:
2604 retval = _equalCoalesceExpr(a, b);
2607 retval = _equalMinMaxExpr(a, b);
2610 retval = _equalXmlExpr(a, b);
2613 retval = _equalNullTest(a, b);
2616 retval = _equalBooleanTest(a, b);
2618 case T_CoerceToDomain:
2619 retval = _equalCoerceToDomain(a, b);
2621 case T_CoerceToDomainValue:
2622 retval = _equalCoerceToDomainValue(a, b);
2624 case T_SetToDefault:
2625 retval = _equalSetToDefault(a, b);
2627 case T_CurrentOfExpr:
2628 retval = _equalCurrentOfExpr(a, b);
2631 retval = _equalTargetEntry(a, b);
2634 retval = _equalRangeTblRef(a, b);
2637 retval = _equalFromExpr(a, b);
2640 retval = _equalJoinExpr(a, b);
2647 retval = _equalPathKey(a, b);
2649 case T_RestrictInfo:
2650 retval = _equalRestrictInfo(a, b);
2652 case T_PlaceHolderVar:
2653 retval = _equalPlaceHolderVar(a, b);
2655 case T_SpecialJoinInfo:
2656 retval = _equalSpecialJoinInfo(a, b);
2658 case T_LateralJoinInfo:
2659 retval = _equalLateralJoinInfo(a, b);
2661 case T_AppendRelInfo:
2662 retval = _equalAppendRelInfo(a, b);
2664 case T_PlaceHolderInfo:
2665 retval = _equalPlaceHolderInfo(a, b);
2671 retval = _equalList(a, b);
2679 retval = _equalValue(a, b);
2686 retval = _equalQuery(a, b);
2689 retval = _equalInsertStmt(a, b);
2692 retval = _equalDeleteStmt(a, b);
2695 retval = _equalUpdateStmt(a, b);
2698 retval = _equalSelectStmt(a, b);
2700 case T_SetOperationStmt:
2701 retval = _equalSetOperationStmt(a, b);
2703 case T_AlterTableStmt:
2704 retval = _equalAlterTableStmt(a, b);
2706 case T_AlterTableCmd:
2707 retval = _equalAlterTableCmd(a, b);
2709 case T_AlterDomainStmt:
2710 retval = _equalAlterDomainStmt(a, b);
2713 retval = _equalGrantStmt(a, b);
2715 case T_GrantRoleStmt:
2716 retval = _equalGrantRoleStmt(a, b);
2718 case T_AlterDefaultPrivilegesStmt:
2719 retval = _equalAlterDefaultPrivilegesStmt(a, b);
2721 case T_DeclareCursorStmt:
2722 retval = _equalDeclareCursorStmt(a, b);
2724 case T_ClosePortalStmt:
2725 retval = _equalClosePortalStmt(a, b);
2728 retval = _equalClusterStmt(a, b);
2731 retval = _equalCopyStmt(a, b);
2734 retval = _equalCreateStmt(a, b);
2736 case T_TableLikeClause:
2737 retval = _equalTableLikeClause(a, b);
2740 retval = _equalDefineStmt(a, b);
2743 retval = _equalDropStmt(a, b);
2745 case T_TruncateStmt:
2746 retval = _equalTruncateStmt(a, b);
2749 retval = _equalCommentStmt(a, b);
2751 case T_SecLabelStmt:
2752 retval = _equalSecLabelStmt(a, b);
2755 retval = _equalFetchStmt(a, b);
2758 retval = _equalIndexStmt(a, b);
2760 case T_CreateFunctionStmt:
2761 retval = _equalCreateFunctionStmt(a, b);
2763 case T_FunctionParameter:
2764 retval = _equalFunctionParameter(a, b);
2766 case T_AlterFunctionStmt:
2767 retval = _equalAlterFunctionStmt(a, b);
2770 retval = _equalDoStmt(a, b);
2773 retval = _equalRenameStmt(a, b);
2775 case T_AlterObjectSchemaStmt:
2776 retval = _equalAlterObjectSchemaStmt(a, b);
2778 case T_AlterOwnerStmt:
2779 retval = _equalAlterOwnerStmt(a, b);
2782 retval = _equalRuleStmt(a, b);
2785 retval = _equalNotifyStmt(a, b);
2788 retval = _equalListenStmt(a, b);
2790 case T_UnlistenStmt:
2791 retval = _equalUnlistenStmt(a, b);
2793 case T_TransactionStmt:
2794 retval = _equalTransactionStmt(a, b);
2796 case T_CompositeTypeStmt:
2797 retval = _equalCompositeTypeStmt(a, b);
2799 case T_CreateEnumStmt:
2800 retval = _equalCreateEnumStmt(a, b);
2802 case T_CreateRangeStmt:
2803 retval = _equalCreateRangeStmt(a, b);
2805 case T_AlterEnumStmt:
2806 retval = _equalAlterEnumStmt(a, b);
2809 retval = _equalViewStmt(a, b);
2812 retval = _equalLoadStmt(a, b);
2814 case T_CreateDomainStmt:
2815 retval = _equalCreateDomainStmt(a, b);
2817 case T_CreateOpClassStmt:
2818 retval = _equalCreateOpClassStmt(a, b);
2820 case T_CreateOpClassItem:
2821 retval = _equalCreateOpClassItem(a, b);
2823 case T_CreateOpFamilyStmt:
2824 retval = _equalCreateOpFamilyStmt(a, b);
2826 case T_AlterOpFamilyStmt:
2827 retval = _equalAlterOpFamilyStmt(a, b);
2829 case T_CreatedbStmt:
2830 retval = _equalCreatedbStmt(a, b);
2832 case T_AlterDatabaseStmt:
2833 retval = _equalAlterDatabaseStmt(a, b);
2835 case T_AlterDatabaseSetStmt:
2836 retval = _equalAlterDatabaseSetStmt(a, b);
2839 retval = _equalDropdbStmt(a, b);
2842 retval = _equalVacuumStmt(a, b);
2845 retval = _equalExplainStmt(a, b);
2847 case T_CreateTableAsStmt:
2848 retval = _equalCreateTableAsStmt(a, b);
2850 case T_CreateSeqStmt:
2851 retval = _equalCreateSeqStmt(a, b);
2853 case T_AlterSeqStmt:
2854 retval = _equalAlterSeqStmt(a, b);
2856 case T_VariableSetStmt:
2857 retval = _equalVariableSetStmt(a, b);
2859 case T_VariableShowStmt:
2860 retval = _equalVariableShowStmt(a, b);
2863 retval = _equalDiscardStmt(a, b);
2865 case T_CreateTableSpaceStmt:
2866 retval = _equalCreateTableSpaceStmt(a, b);
2868 case T_DropTableSpaceStmt:
2869 retval = _equalDropTableSpaceStmt(a, b);
2871 case T_AlterTableSpaceOptionsStmt:
2872 retval = _equalAlterTableSpaceOptionsStmt(a, b);
2874 case T_CreateExtensionStmt:
2875 retval = _equalCreateExtensionStmt(a, b);
2877 case T_AlterExtensionStmt:
2878 retval = _equalAlterExtensionStmt(a, b);
2880 case T_AlterExtensionContentsStmt:
2881 retval = _equalAlterExtensionContentsStmt(a, b);
2883 case T_CreateFdwStmt:
2884 retval = _equalCreateFdwStmt(a, b);
2886 case T_AlterFdwStmt:
2887 retval = _equalAlterFdwStmt(a, b);
2889 case T_CreateForeignServerStmt:
2890 retval = _equalCreateForeignServerStmt(a, b);
2892 case T_AlterForeignServerStmt:
2893 retval = _equalAlterForeignServerStmt(a, b);
2895 case T_CreateUserMappingStmt:
2896 retval = _equalCreateUserMappingStmt(a, b);
2898 case T_AlterUserMappingStmt:
2899 retval = _equalAlterUserMappingStmt(a, b);
2901 case T_DropUserMappingStmt:
2902 retval = _equalDropUserMappingStmt(a, b);
2904 case T_CreateForeignTableStmt:
2905 retval = _equalCreateForeignTableStmt(a, b);
2907 case T_CreateTrigStmt:
2908 retval = _equalCreateTrigStmt(a, b);
2910 case T_CreateEventTrigStmt:
2911 retval = _equalCreateEventTrigStmt(a, b);
2913 case T_AlterEventTrigStmt:
2914 retval = _equalAlterEventTrigStmt(a, b);
2916 case T_CreatePLangStmt:
2917 retval = _equalCreatePLangStmt(a, b);
2919 case T_CreateRoleStmt:
2920 retval = _equalCreateRoleStmt(a, b);
2922 case T_AlterRoleStmt:
2923 retval = _equalAlterRoleStmt(a, b);
2925 case T_AlterRoleSetStmt:
2926 retval = _equalAlterRoleSetStmt(a, b);
2928 case T_DropRoleStmt:
2929 retval = _equalDropRoleStmt(a, b);
2932 retval = _equalLockStmt(a, b);
2934 case T_ConstraintsSetStmt:
2935 retval = _equalConstraintsSetStmt(a, b);
2938 retval = _equalReindexStmt(a, b);
2940 case T_CheckPointStmt:
2943 case T_CreateSchemaStmt:
2944 retval = _equalCreateSchemaStmt(a, b);
2946 case T_CreateConversionStmt:
2947 retval = _equalCreateConversionStmt(a, b);
2949 case T_CreateCastStmt:
2950 retval = _equalCreateCastStmt(a, b);
2953 retval = _equalPrepareStmt(a, b);
2956 retval = _equalExecuteStmt(a, b);
2958 case T_DeallocateStmt:
2959 retval = _equalDeallocateStmt(a, b);
2961 case T_DropOwnedStmt:
2962 retval = _equalDropOwnedStmt(a, b);
2964 case T_ReassignOwnedStmt:
2965 retval = _equalReassignOwnedStmt(a, b);
2967 case T_AlterTSDictionaryStmt:
2968 retval = _equalAlterTSDictionaryStmt(a, b);
2970 case T_AlterTSConfigurationStmt:
2971 retval = _equalAlterTSConfigurationStmt(a, b);
2975 retval = _equalAExpr(a, b);
2978 retval = _equalColumnRef(a, b);
2981 retval = _equalParamRef(a, b);
2984 retval = _equalAConst(a, b);
2987 retval = _equalFuncCall(a, b);
2990 retval = _equalAStar(a, b);
2993 retval = _equalAIndices(a, b);
2995 case T_A_Indirection:
2996 retval = _equalA_Indirection(a, b);
2999 retval = _equalA_ArrayExpr(a, b);
3002 retval = _equalResTarget(a, b);
3005 retval = _equalTypeCast(a, b);
3007 case T_CollateClause:
3008 retval = _equalCollateClause(a, b);
3011 retval = _equalSortBy(a, b);
3014 retval = _equalWindowDef(a, b);
3016 case T_RangeSubselect:
3017 retval = _equalRangeSubselect(a, b);
3019 case T_RangeFunction:
3020 retval = _equalRangeFunction(a, b);
3023 retval = _equalTypeName(a, b);
3026 retval = _equalIndexElem(a, b);
3029 retval = _equalColumnDef(a, b);
3032 retval = _equalConstraint(a, b);
3035 retval = _equalDefElem(a, b);
3037 case T_LockingClause:
3038 retval = _equalLockingClause(a, b);
3040 case T_RangeTblEntry:
3041 retval = _equalRangeTblEntry(a, b);
3043 case T_SortGroupClause:
3044 retval = _equalSortGroupClause(a, b);
3046 case T_WindowClause:
3047 retval = _equalWindowClause(a, b);
3049 case T_RowMarkClause:
3050 retval = _equalRowMarkClause(a, b);
3053 retval = _equalWithClause(a, b);
3055 case T_CommonTableExpr:
3056 retval = _equalCommonTableExpr(a, b);
3059 retval = _equalPrivGrantee(a, b);
3061 case T_FuncWithArgs:
3062 retval = _equalFuncWithArgs(a, b);
3065 retval = _equalAccessPriv(a, b);
3067 case T_XmlSerialize:
3068 retval = _equalXmlSerialize(a, b);
3072 elog(ERROR, "unrecognized node type: %d",
3074 retval = false; /* keep compiler quiet */