postgres.git / summary / log / commit / refs

commit    9f0f72d89ff6cff8261fd793257147cbb268a6ae
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Fri Jul 12 11:44:19 2024 +0000
First released in: 18.0, 12.20, 13.16, 14.13, 15.8, 16.4, 17.0

    Add ORDER BY to new test query
    
    Per buildfarm.


 src/test/regress/expected/constraints.out | 3 ++-
 src/test/regress/sql/constraints.sql      | 3 ++-
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git a/src/test/regress/expected/constraints.out b/src/test/regress/expected/constraints.out
index 03aec26657c..cf0b80d6169 100644
--- a/src/test/regress/expected/constraints.out
+++ b/src/test/regress/expected/constraints.out
@@ -639,7 +639,8 @@ CREATE UNIQUE INDEX t_b_idx ON t (b, a);
 ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey;
 ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key;
 SELECT conname, conparentid, conislocal, coninhcount
-  FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key');
+  FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key')
+  ORDER BY conname DESC;
   conname   | conparentid | conislocal | coninhcount 
 ------------+-------------+------------+-------------
  tp_pkey    |           0 | t          |           0
diff --git a/src/test/regress/sql/constraints.sql b/src/test/regress/sql/constraints.sql
index 034ebf38309..e3e3bea7091 100644
--- a/src/test/regress/sql/constraints.sql
+++ b/src/test/regress/sql/constraints.sql
@@ -462,7 +462,8 @@ CREATE UNIQUE INDEX t_b_idx ON t (b, a);
 ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey;
 ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key;
 SELECT conname, conparentid, conislocal, coninhcount
-  FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key');
+  FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key')
+  ORDER BY conname DESC;
 ALTER TABLE t DETACH PARTITION tp;
 DROP TABLE t, tp;
 


[parent: 4ae09c59d6f5]