public inbox for [email protected]  
help / color / mirror / Atom feed
From: Sergey Shinderuk <[email protected]>
To: Richard Guo <[email protected]>
Cc: [email protected]
Cc: David Rowley <[email protected]>
Cc: Tom Lane <[email protected]>
Subject: Re: BUG #19412: Wrong query result with not null constraint
Date: Fri, 20 Feb 2026 13:54:10 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMbWs4-Mv2jkyTj0VYNCVxVBJkr5NAzOsaDvAvFGe97B6eEStQ@mail.gmail.com>
References: <[email protected]>
	<CAApHDvpXarz-D6tP-7y4ZrtnhXtdbRY0kQxRDQTVc3Z9DckYVw@mail.gmail.com>
	<CAMbWs49kVgb_wS4VFuQpfZ+Re4tWVn7vmheR6HqKppnNuEaH-g@mail.gmail.com>
	<CAMbWs49NVUNpQPwGb56SCSQL-bkjtxnkCb6Ot7dBxGndJoA3Pw@mail.gmail.com>
	<[email protected]>
	<CAMbWs481y0EmS7fFJE9DEjjHGJO4mh9nPmusPDQ77Psxgo96ww@mail.gmail.com>
	<[email protected]>
	<CAMbWs4-Mv2jkyTj0VYNCVxVBJkr5NAzOsaDvAvFGe97B6eEStQ@mail.gmail.com>

On 2/20/26 12:57, Richard Guo wrote:
> ... and then pushed and back-patched to v16.

Thank you!

> Thank you, Sergey, for the report and the excellent self-contained
> repro query.  This is a great catch.  (I'm curious how you found this
> bug -- was it from a production query or a fuzzing tool?)

The bug was encountered by our customer upgrading to v17 and my 
colleague passed this repro to me.

-- 
Sergey Shinderuk		https://postgrespro.com/






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], [email protected], [email protected]
  Subject: Re: BUG #19412: Wrong query result with not null constraint
  In-Reply-To: <[email protected]>

* 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