Re: Assert failure in try_nestloop_path() - Mailing list pgsql-hackers

On Wed, Sep 9, 2026 at 11:35 PM Tom Lane <tgl@sss.pgh.pa.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