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

Appearance settings

Commit 7e3c541

Browse filesBrowse files
committed
Add ORDER BY to some regression test queries
Apparently, an unrelated patch introduced some variation on the build farm. Reported-by: Magnus Hagander <magnus@hagander.net>
1 parent aaf0432 commit 7e3c541
Copy full SHA for 7e3c541

File tree

Expand file treeCollapse file tree

2 files changed

+10
-8
lines changed
Filter options
Expand file treeCollapse file tree

2 files changed

+10
-8
lines changed

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

Copy file name to clipboardExpand all lines: src/test/regress/expected/create_function_3.out
+5-4Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -474,26 +474,27 @@ CREATE FUNCTION functest_IS_7()
474474
SELECT r0.routine_name, r1.routine_name
475475
FROM information_schema.routine_routine_usage rru
476476
JOIN information_schema.routines r0 ON r0.specific_name = rru.specific_name
477-
JOIN information_schema.routines r1 ON r1.specific_name = rru.routine_name;
477+
JOIN information_schema.routines r1 ON r1.specific_name = rru.routine_name
478+
ORDER BY 1, 2;
478479
routine_name | routine_name
479480
----------------+----------------
480481
functest_is_4b | functest_is_4a
481482
(1 row)
482483

483-
SELECT routine_name, sequence_name FROM information_schema.routine_sequence_usage;
484+
SELECT routine_name, sequence_name FROM information_schema.routine_sequence_usage ORDER BY 1, 2;
484485
routine_name | sequence_name
485486
---------------+---------------
486487
functest_is_5 | functest1
487488
functest_is_6 | functest1
488489
(2 rows)
489490

490-
SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage;
491+
SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage ORDER BY 1, 2;
491492
routine_name | table_name | column_name
492493
---------------+------------+-------------
493494
functest_is_7 | functest2 | a
494495
(1 row)
495496

496-
SELECT routine_name, table_name FROM information_schema.routine_table_usage;
497+
SELECT routine_name, table_name FROM information_schema.routine_table_usage ORDER BY 1, 2;
497498
routine_name | table_name
498499
---------------+------------
499500
functest_is_7 | functest2

‎src/test/regress/sql/create_function_3.sql

Copy file name to clipboardExpand all lines: src/test/regress/sql/create_function_3.sql
+5-4Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -276,10 +276,11 @@ CREATE FUNCTION functest_IS_7()
276276
SELECT r0.routine_name, r1.routine_name
277277
FROM information_schema.routine_routine_usage rru
278278
JOIN information_schema.routines r0 ON r0.specific_name = rru.specific_name
279-
JOIN information_schema.routines r1 ON r1.specific_name = rru.routine_name;
280-
SELECT routine_name, sequence_name FROM information_schema.routine_sequence_usage;
281-
SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage;
282-
SELECT routine_name, table_name FROM information_schema.routine_table_usage;
279+
JOIN information_schema.routines r1 ON r1.specific_name = rru.routine_name
280+
ORDER BY 1, 2;
281+
SELECT routine_name, sequence_name FROM information_schema.routine_sequence_usage ORDER BY 1, 2;
282+
SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage ORDER BY 1, 2;
283+
SELECT routine_name, table_name FROM information_schema.routine_table_usage ORDER BY 1, 2;
283284

284285
DROP FUNCTION functest_IS_4a CASCADE;
285286
DROP SEQUENCE functest1 CASCADE;

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.