public inbox for [email protected]
help / color / mirror / Atom feedFrom: Artem Fadeev <[email protected]>
To: [email protected]
Subject: Re: BUG #19412: Wrong query result with not null constraint
Date: Tue, 17 Feb 2026 15:14:40 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On 2/17/26 14:19, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 19412
> Logged by: Sergey Shinderuk
> Email address: [email protected]
> PostgreSQL version: 17.8
> Operating system: Ubuntu 24.04
> Description:
git bisect shows the bug was introduced by commit 3af7040985b [0]
I suppose presence of UNION ALL subquery is important for the reproduction
because the commit uses RangeTblEntry->inh, which has the following remark
in the comment in src/include/nodes/parsenodes.h
* inh is true for relation references that should be expanded to
include
* inheritance children, if the rel has any. In the parser, this
will
* only be true for RTE_RELATION entries. The planner also uses this
* field to mark RTE_SUBQUERY entries that contain UNION ALL
queries that
* it has flattened into pulled-up subqueries (creating a
structure much
* like the effects of inheritance).
[0]
https://github.com/postgres/postgres/commit/3af7040985b6df504a72cd307aad5d69ac5f5384
Regards,
Artem Fadeev.
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]
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