diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-09-02 05:20:56 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-09-02 05:20:56 +0000 |
| commit | ed7f780016cdc11c54bcb3b522b255304156cda5 (patch) | |
| tree | 98ab8294c015f87808b2dcc427b0938c281de95e /src | |
| parent | f486f9241b22576f97385e2f08268b8e74c2cdb1 (diff) | |
| download | postgresql-ed7f780016cdc11c54bcb3b522b255304156cda5.tar.gz postgresql-ed7f780016cdc11c54bcb3b522b255304156cda5.zip | |
Fix ordering regression problem on freebsd/alpha by adding ORDER BY.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/rules.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/rules.sql | 2 |
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 |