On Tue, Sep 8, 2026 at 12:13 PM Richard Guo <[email protected]> wrote: > Hmm, I don't think bizarre join orderings are required. The duplicate > arises whenever the qual pushed down into the parameterized path is > not affected by the commuting outer join, which seems quite a common > case. Here is an example where the duplicate shows up in the selected > plan, with the joins performed just in syntactic order:
... and here is a patch to fix it. Now we have three patches fixing three duplicate-clause issues. - Richard
v1-0001-Fix-duplicate-enforcement-of-identical-clone-clau.patch
Description: Binary data
