Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commita73a367

Browse files
committed
Protect against collation variations in test
Discussion:https://postgr.es/m/YW/MYdSRQZtPFBWR@paquier.xyz
1 parentabb9ee9 commita73a367

File tree

2 files changed

+6
-6
lines changed

2 files changed

+6
-6
lines changed

‎src/test/regress/expected/alter_table.out‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -248,7 +248,7 @@ ALTER INDEX alter_idx_rename_test_parted RENAME TO alter_idx_rename_test_parted_
248248
SELECT relation::regclass, mode FROM pg_locks
249249
WHERE pid = pg_backend_pid() AND locktype = 'relation'
250250
AND relation::regclass::text LIKE 'alter\_idx%'
251-
ORDER BY relation::regclass::text;
251+
ORDER BY relation::regclass::text COLLATE "C";
252252
relation | mode
253253
--------------------------------+---------------------
254254
alter_idx_rename_test_2 | AccessExclusiveLock
@@ -262,7 +262,7 @@ ALTER INDEX alter_idx_rename_test_parted_idx RENAME TO alter_idx_rename_test_par
262262
SELECT relation::regclass, mode FROM pg_locks
263263
WHERE pid = pg_backend_pid() AND locktype = 'relation'
264264
AND relation::regclass::text LIKE 'alter\_idx%'
265-
ORDER BY relation::regclass::text;
265+
ORDER BY relation::regclass::text COLLATE "C";
266266
relation | mode
267267
------------------------------------+--------------------------
268268
alter_idx_rename_test_idx_2 | ShareUpdateExclusiveLock
@@ -276,7 +276,7 @@ ALTER TABLE alter_idx_rename_test_parted_idx_2 RENAME TO alter_idx_rename_test_p
276276
SELECT relation::regclass, mode FROM pg_locks
277277
WHERE pid = pg_backend_pid() AND locktype = 'relation'
278278
AND relation::regclass::text LIKE 'alter\_idx%'
279-
ORDER BY relation::regclass::text;
279+
ORDER BY relation::regclass::text COLLATE "C";
280280
relation | mode
281281
------------------------------------+---------------------
282282
alter_idx_rename_test_idx_3 | AccessExclusiveLock

‎src/test/regress/sql/alter_table.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -242,23 +242,23 @@ ALTER INDEX alter_idx_rename_test_parted RENAME TO alter_idx_rename_test_parted_
242242
SELECT relation::regclass, modeFROM pg_locks
243243
WHERE pid= pg_backend_pid()AND locktype='relation'
244244
AND relation::regclass::textLIKE'alter\_idx%'
245-
ORDER BY relation::regclass::text;
245+
ORDER BY relation::regclass::text COLLATE"C";
246246
COMMIT;
247247
BEGIN;
248248
ALTERINDEX alter_idx_rename_test_idx RENAME TO alter_idx_rename_test_idx_2;
249249
ALTERINDEX alter_idx_rename_test_parted_idx RENAME TO alter_idx_rename_test_parted_idx_2;
250250
SELECT relation::regclass, modeFROM pg_locks
251251
WHERE pid= pg_backend_pid()AND locktype='relation'
252252
AND relation::regclass::textLIKE'alter\_idx%'
253-
ORDER BY relation::regclass::text;
253+
ORDER BY relation::regclass::text COLLATE"C";
254254
COMMIT;
255255
BEGIN;
256256
ALTERTABLE alter_idx_rename_test_idx_2 RENAME TO alter_idx_rename_test_idx_3;
257257
ALTERTABLE alter_idx_rename_test_parted_idx_2 RENAME TO alter_idx_rename_test_parted_idx_3;
258258
SELECT relation::regclass, modeFROM pg_locks
259259
WHERE pid= pg_backend_pid()AND locktype='relation'
260260
AND relation::regclass::textLIKE'alter\_idx%'
261-
ORDER BY relation::regclass::text;
261+
ORDER BY relation::regclass::text COLLATE"C";
262262
COMMIT;
263263
DROPTABLE alter_idx_rename_test_2;
264264

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp