From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: dqetool@126.com
Subject: BUG #18764: server closed the connection unexpectedly
Date: Fri, 03 Jan 2025 07:36:29 +0000
Message-ID: <18764-63ad667ea26e877a@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18764
Logged by: Jason Smith
Email address: dqetool@126.com
PostgreSQL version: 17.2
Operating system: Linux
Description:
Run the following statements and an error is returned.
CREATE TABLE t0 (c1 INT, c2 DECIMAL);
INSERT INTO t0 VALUES (0, NULL);
INSERT INTO t0 VALUES (8, NULL);
SELECT c2 AS ca2, c2 AS ca3 FROM t0 UNION SELECT DISTINCT ca8 AS ca5, ca7 AS
ca6 FROM (SELECT c1 AS ca7, c2 AS ca8 FROM t0) AS ta1 JOIN (SELECT c1 AS
ca10, c1 AS ca11 FROM t0) AS ta2 ON TRUE; -- server closed the connection
unexpectedly
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: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, dqetool@126.com
Subject: Re: BUG #18764: server closed the connection unexpectedly
In-Reply-To: <18764-63ad667ea26e877a@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox