> 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 we
have useful pathkeys...
Or shall I completely remove the step to generate patheys and do not
pass pathkeys to create_recursion_path?
pathkeys = convert_subquery_pathkeys(root, rel, subroot->query_pathkeys);
--
Tatsuo Ishii
SRA OSS, Inc. Japan