postgres.git / summary / log / commit / refs

commit    5b2945ec0a39959962072c39d1817d0fdf23d486
Author:   Michael Paquier <michael@paquier.xyz>
Date:     Wed Feb 10 07:59:04 2021 +0000
First released in: 14.0, 12.7, 13.3

    Fix ORDER BY clause in new regression test of REINDEX CONCURRENTLY
    
    Oversight in bd12080.
    
    Reported-by: Justin Pryzby
    Discussion: https://postgr.es/m/20210210065805.GG20012@telsasoft.com
    Backpatch-through: 12


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

diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out
index 098ef3ab713..332c491de80 100644
--- a/src/test/regress/expected/create_index.out
+++ b/src/test/regress/expected/create_index.out
@@ -2492,7 +2492,7 @@ SELECT attrelid::regclass, attnum, attstattarget
     'concur_exprs_index_expr'::regclass,
     'concur_exprs_index_pred'::regclass,
     'concur_exprs_index_pred_2'::regclass)
-  ORDER BY 'concur_exprs_index_expr'::regclass::text, attnum;
+  ORDER BY attrelid::regclass::text, attnum;
          attrelid          | attnum | attstattarget 
 ---------------------------+--------+---------------
  concur_exprs_index_expr   |      1 |           100
diff --git a/src/test/regress/sql/create_index.sql b/src/test/regress/sql/create_index.sql
index e55d9f31919..0d4c0e66711 100644
--- a/src/test/regress/sql/create_index.sql
+++ b/src/test/regress/sql/create_index.sql
@@ -1028,7 +1028,7 @@ SELECT attrelid::regclass, attnum, attstattarget
     'concur_exprs_index_expr'::regclass,
     'concur_exprs_index_pred'::regclass,
     'concur_exprs_index_pred_2'::regclass)
-  ORDER BY 'concur_exprs_index_expr'::regclass::text, attnum;
+  ORDER BY attrelid::regclass::text, attnum;
 DROP TABLE concur_exprs_tab;
 
 -- Temporary tables and on-commit actions, where CONCURRENTLY is ignored.


[parent: 85edb1f2615d]