From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: d.kovalenko@postgrespro.ru
Subject: BUG #19338: [PG15] Unstable SQL result in test regress/tablespace
Date: Mon, 01 Dec 2025 11:31:19 +0000
Message-ID: <19338-3dd4f9982d9b55a9@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 19338
Logged by: Dmitry Kovalenko
Email address: d.kovalenko@postgrespro.ru
PostgreSQL version: 15.15
Operating system: AltLinux-10 ARM64
Description:
Hello!
PG15 has an unstable SQL in test regress/tablespace:
^^^^^^^^^^^^^^^^^^^^/home/test/.../src/test/regress/regression.diffs
diff -U3 /home/test/.../src/test/regress/expected/tablespace.out
/home/test/.../src/test/regress/results/tablespace.out
--- /home/test/.../src/test/regress/expected/tablespace.out 2025-11-30
21:11:56.000000000 +0300
+++ /home/test/.../src/test/regress/results/tablespace.out 2025-11-30
23:17:49.378004420 +0300
@@ -334,9 +334,9 @@
where c.reltablespace = t.oid AND c.relname LIKE 'part%_idx';
relname | spcname
-------------+------------------
+ part_a_idx | regress_tblspace
part1_a_idx | regress_tblspace
part2_a_idx | regress_tblspace
- part_a_idx | regress_tblspace
(3 rows)
\d testschema.part
^^^^^^^^^^^^^^^^^^^^
https://github.com/postgres/postgres/blob/134a8ee2240557e8165cffe70d19e48937cece03/src/test/regress/...
---
PG16 has the correct SQL:
...
where c.reltablespace = t.oid AND c.relname LIKE 'part%_idx' ORDER BY
relname;
https://github.com/postgres/postgres/blob/4d288e33b957ce5023dd1ec24b53f02c8a9e8ba0/src/test/regress/...
Could you backport this fix from PG16 to PG15, please?
Thanks&Regards,
Dmitry Kovalenko
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, d.kovalenko@postgrespro.ru
Subject: Re: BUG #19338: [PG15] Unstable SQL result in test regress/tablespace
In-Reply-To: <19338-3dd4f9982d9b55a9@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