Horton

Re: BUG #19412: Wrong query result with not null constraint

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: David Rowley <dgrowleyml@gmail.com>
Cc: s.shinderuk@postgrespro.ru, pgsql-bugs@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2026-02-19T02:18:54Z
Lists: pgsql-bugs 
On Wed, Feb 18, 2026 at 6:50 PM Richard Guo <guofenglinux@gmail.com> wrote:
> Here is a more readable version of the patch.

Regarding back-patching, I plan to back-patch this all through to v16.
Although the reported case does not seem to cause problems in v16, the
underlying logic error persists.  Leaving incorrect varnullingrels in
the tree seems like a trap for the unwary.

Any thoughts?

- Richard

Commits

  1. Fix computation of varnullingrels when translating appendrel Var

  2. Fix IS [NOT] NULL qual optimization for inheritance tables