Re: Assert failure in try_nestloop_path()

Hello Richard and Tom,

10.09.2026 04:36, Richard Guo wrote:
> On Wed, Sep 9, 2026 at 11:35 PM Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> I wonder if we should leave the Assert bits out of v19. The intent to
>> have hard prevention of duplicate clauses is a brand new aspiration,
>> and I have pretty much no faith that no such cases remain. I don't
>> really want to commit to fixing all such cases in v19.
> Fair point. I kept the assertions on HEAD only, with a note in the
> commit message.
>
> I've pushed both to master and v19.

I've discovered that:
echo "geqo_threshold = 2" >/tmp/temp.config
TEMP_CONFIG=/tmp/temp.config TESTS="partition_join" make -s check-tests

triggers one of the assertions:
TRAP: failed Assert("no_duplicate_clause_serials(*restrict_clauses)"), File: "relnode.c", Line: 2079, PID: 634394

Could you have a look, please?

Best regards,
Alexander