public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Rowley <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: BUG #19463: Server crash (Assertion failure) when using MERGE statement in CTE
Date: Tue, 28 Apr 2026 11:20:55 +1200
Message-ID: <CAApHDvpvGj_xt=Asmrinq3WsdXby+mxi5UQp+TwUTB=84+pm0A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Tue, 21 Apr 2026 at 02:05, PG Bug reporting form
<[email protected]> wrote:
> PostgreSQL version: 15.0

You're reporting a bug on a PostgreSQL version that's missing 3.5
years of bug fixes. 15.17 is the latest minor version for the
PostgreSQL 15 release. Please always test with the latest minor
version of the major release before submitting bug reports. If you can
reproduce in a previous minor version, but not on the latest, then
this is likely because the bug has already been fixed. You need not
report these.

> Using a MERGE statement as a Common Table Expression (CTE) causes the
> PostgreSQL server to crash with an assertion failure. The assertion in
> `transformWithClause` does not recognize `MergeStmt` as a valid
> data-modifying statement type.
>
> ## PostgreSQL Version
>
> ```
> PostgreSQL 15devel on x86_64-pc-linux-gnu, compiled by clang version 17.0.6,
> 64-bit
> ```
>
> Tested on REL_15_STABLE branch.

Looks like you must be trying that on a very outdated REL_15_STABLE.
If it's tagged as 15devel, then that's from before the 15.0 release.
Please update your git repo (git pull) and try with REL_15_17.

I tried on 15.0 and 15.17 and cannot reproduce the assert failure
you're seeing. So it looks like whatever you've found was fixed before
the 15.0 release.

David

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: BUG #19463: Server crash (Assertion failure) when using MERGE statement in CTE
  In-Reply-To: <CAApHDvpvGj_xt=Asmrinq3WsdXby+mxi5UQp+TwUTB=84+pm0A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox