postgres.git / summary / log / commit / refs

commit    c6cd20d91ce9b100b89997757b88a415c3e10747
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 2cd07f64dde..8e11c089b19 100644
--- a/src/test/regress/expected/create_index.out
+++ b/src/test/regress/expected/create_index.out
@@ -2505,7 +2505,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 c130b86c025..c0392f052d8 100644
--- a/src/test/regress/sql/create_index.sql
+++ b/src/test/regress/sql/create_index.sql
@@ -1034,7 +1034,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: 849383138581]