Fix ordering regression problem on freebsd/alpha by adding ORDER BY.

bmomjian · bmomjian · commit ed7f780016cd · 2002-09-02T05:20:56.000Z
diff --git 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
@@ -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
