On 17/09/2025 16:34, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 19055
> Logged by: BugForge
> Email address: dllggyx@outlook.com
> PostgreSQL version: 17.6
> Operating system: Ubuntu 20.04 x86-64, docker image postgres:17.6
> Description:
>
> PoC:
> SELECT FROM ( SELECT generate_series ( 1 , '31' ) x ) GROUP BY ( x ) WINDOW
> w AS ( ORDER BY ( WITH x AS ( WITH x AS ( SELECT sum ( x ) ) SELECT DISTINCT
> * FROM x ) ( SELECT ( count ( ( SELECT x FROM x ) ) ) ) ) )
This query seems to crash the server at least back to 16. The only
simplification of it that I could manage was to replace generate_series
with SELECT 1. I could also replace all of the x's with different names
without effect.
--
Vik Fearing
