aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/rules.out6
-rw-r--r--src/test/regress/sql/rules.sql2
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out
index adf7d7b7b6e..3aa760b700b 100644
--- a/src/test/regress/expected/rules.out
+++ b/src/test/regress/expected/rules.out
@@ -1018,13 +1018,13 @@ sl7 | 6|brown | 60|cm | 60
sl8 | 21|brown | 40|inch | 101.6
(8 rows)
-QUERY: SELECT * FROM shoelace_log;
+QUERY: SELECT * FROM shoelace_log ORDER BY sl_name;
sl_name |sl_avail|log_who |log_when
----------+--------+--------+--------
-sl7 | 6|Al Bundy|epoch
+sl3 | 10|Al Bundy|epoch
sl6 | 20|Al Bundy|epoch
+sl7 | 6|Al Bundy|epoch
sl8 | 21|Al Bundy|epoch
-sl3 | 10|Al Bundy|epoch
(4 rows)
QUERY: CREATE VIEW shoelace_obsolete AS
diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql
index c1fd8b2a25f..32c887dd9a7 100644
--- a/src/test/regress/sql/rules.sql
+++ b/src/test/regress/sql/rules.sql
@@ -661,7 +661,7 @@ insert into shoelace_ok select * from shoelace_arrive;
SELECT * FROM shoelace ORDER BY sl_name;
-SELECT * FROM shoelace_log;
+SELECT * FROM shoelace_log ORDER BY sl_name;
CREATE VIEW shoelace_obsolete AS
SELECT * FROM shoelace WHERE NOT EXISTS