diff --git a/src/backend/optimizer/prep/prepunion.c b/src/backend/optimizer/prep/prepunion.c index 30068c27a1..e3ba0d17cf 100644 --- a/src/backend/optimizer/prep/prepunion.c +++ b/src/backend/optimizer/prep/prepunion.c @@ -714,7 +714,7 @@ generate_union_paths(SetOperationStmt *op, PlannerInfo *root, List *groupList = NIL; Path *apath; Path *gpath = NULL; - bool try_sorted; + bool try_sorted = false; List *union_pathkeys = NIL; /* @@ -741,17 +741,20 @@ generate_union_paths(SetOperationStmt *op, PlannerInfo *root, *pTargetList = tlist; /* For for UNIONs (not UNION ALL), try sorting, if sorting is possible */ - try_sorted = !op->all && grouping_is_sortable(op->groupClauses); - - if (try_sorted) + if (!op->all) { /* Identify the grouping semantics */ groupList = generate_setop_grouplist(op, tlist); - /* Determine the pathkeys for sorting by the whole target list */ - union_pathkeys = make_pathkeys_for_sortclauses(root, groupList, tlist); + if (grouping_is_sortable(op->groupClauses)) + { + try_sorted = true; + /* Determine the pathkeys for sorting by the whole target list */ + union_pathkeys = make_pathkeys_for_sortclauses(root, groupList, + tlist); - root->query_pathkeys = union_pathkeys; + root->query_pathkeys = union_pathkeys; + } } /*