aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/rules.out2
-rw-r--r--src/test/regress/sql/rules.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out
index bcce2332c4a..6ffa0c3dcd7 100644
--- a/src/test/regress/expected/rules.out
+++ b/src/test/regress/expected/rules.out
@@ -1002,7 +1002,7 @@ SELECT * FROM shoelace ORDER BY sl_name;
sl8 | 1 | brown | 40 | inch | 101.6
(8 rows)
-SELECT * FROM shoe_ready WHERE total_avail >= 2;
+SELECT * FROM shoe_ready WHERE total_avail >= 2 ORDER BY 1;
shoename | sh_avail | sl_name | sl_avail | total_avail
------------+----------+------------+----------+-------------
sh1 | 2 | sl1 | 5 | 2
diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql
index 20afc9f0eda..eb47245ce2b 100644
--- a/src/test/regress/sql/rules.sql
+++ b/src/test/regress/sql/rules.sql
@@ -585,7 +585,7 @@ INSERT INTO shoelace_data VALUES ('sl8', 1, 'brown', 40 , 'inch');
-- SELECTs in doc
SELECT * FROM shoelace ORDER BY sl_name;
-SELECT * FROM shoe_ready WHERE total_avail >= 2;
+SELECT * FROM shoe_ready WHERE total_avail >= 2 ORDER BY 1;
CREATE TABLE shoelace_log (
sl_name char(10), -- shoelace changed