public inbox for [email protected]  

help / color / mirror / Atom feed
From: Eric Ridge <[email protected]>
To: David G. Johnston <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: pg18 bug? SELECT query doesn't work
Date: Tue, 6 Jan 2026 13:10:40 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwZS4dO2xJeL7yT-D20J-WR15rCPE9iXta8F9WuFHvxXTA@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwbQj6kLxiz=Ft=ykM2s+H0ytCL7C+Cg1G=7W8ifhFi0Ow@mail.gmail.com>
	<[email protected]>
	<CAKFQuwZS4dO2xJeL7yT-D20J-WR15rCPE9iXta8F9WuFHvxXTA@mail.gmail.com>

> On Jan 6, 2026, at 12:00 PM, David G. Johnston <[email protected]> wrote:
> 
> While I haven't dug into the actual specifics of this report in detail, the change in question happened back in v10.
> 
> https://www.postgresql.org/docs/10/release-10.html

Thanks.  I wouldn't have thought to look back that far since the query worked on v15.  Interesting.

> The failure to emit an error when it probably should have is likely a bug in older versions since fixed.

Fair enough.

> That the behavior depends on the chosen plan and plans differ when you do and do not materialize a CTE is likewise not surprising. 

I guess I wouldn't expect Postgres to generate a plan that it then can't execute.  That's what's surprising to me.

But it's fine.  In all my years of using Postgres this is the first time I've run into a query that no longer executes, so I wanted to bring it to y'alls attention.

Thanks again!

eric

view thread (4+ messages)  latest in thread

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: pg18 bug? SELECT query doesn't work
  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