diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 1999-08-01 04:41:32 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 1999-08-01 04:41:32 +0000 |
| commit | f851c6b07deac83e03de3e77221ea595513e6f47 (patch) | |
| tree | 0fa869f54701724ca77c3b99ac597cb4f7f52132 /src | |
| parent | 970ef45c41fceb5c5ad87d34f33443f79e7bd0cb (diff) | |
| download | postgresql-f851c6b07deac83e03de3e77221ea595513e6f47.tar.gz postgresql-f851c6b07deac83e03de3e77221ea595513e6f47.zip | |
Add another ORDER BY to rules test; got tired of it 'failing'
every time I tweak the optimizer...
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/rules.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/rules.sql | 2 |
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 |