> Why does set_recursion_pathlist think that the subquery might have> useful pathkeys? We know it must always be a UNION ALL, no?
Right. But someday we might implement "UNION" (without ALL) then wehave useful pathkeys...
Or shall I completely remove the step to generate patheys and do notpass pathkeys to create_recursion_path?
pathkeys = convert_subquery_pathkeys(root, rel, subroot->query_pathkeys);--Tatsuo IshiiSRA OSS, Inc. Japan