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

Commit74e12db

Browse files
committed
Add ORDER BY to new test query
Per buildfarm.
1 parent8391779 commit74e12db

File tree

2 files changed

+4
-2
lines changed

2 files changed

+4
-2
lines changed

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

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -639,7 +639,8 @@ CREATE UNIQUE INDEX t_b_idx ON t (b, a);
639639
ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey;
640640
ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key;
641641
SELECT conname, conparentid, conislocal, coninhcount
642-
FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key');
642+
FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key')
643+
ORDER BY conname DESC;
643644
conname | conparentid | conislocal | coninhcount
644645
------------+-------------+------------+-------------
645646
tp_pkey | 0 | t | 0

‎src/test/regress/sql/constraints.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -462,7 +462,8 @@ CREATE UNIQUE INDEX t_b_idx ON t (b, a);
462462
ALTERINDEX t_a_idx ATTACH PARTITION tp_pkey;
463463
ALTERINDEX t_b_idx ATTACH PARTITION tp_b_a_key;
464464
SELECT conname, conparentid, conislocal, coninhcount
465-
FROM pg_constraintWHERE connameIN ('tp_pkey','tp_b_a_key');
465+
FROM pg_constraintWHERE connameIN ('tp_pkey','tp_b_a_key')
466+
ORDER BY connameDESC;
466467
ALTERTABLE t DETACH PARTITION tp;
467468
DROPTABLE t, tp;
468469

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp