diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 1998-10-28 19:32:43 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 1998-10-28 19:32:43 +0000 |
| commit | 1f27facc90c11c3e4c96b706ef64369842f1137c (patch) | |
| tree | d73403b629fc495086fa676bea0fd3442e51124c /src/test/regress/sql/rules.sql | |
| parent | 571d1216641b77dcb1e301eb887162c8b590581a (diff) | |
| download | postgresql-1f27facc90c11c3e4c96b706ef64369842f1137c.tar.gz | |
Add ORDER BY to ensure platform-independent results in rules test.
Diffstat (limited to 'src/test/regress/sql/rules.sql')
| -rw-r--r-- | src/test/regress/sql/rules.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql index 8ffefd5be0..433e07a3a9 100644 --- a/src/test/regress/sql/rules.sql +++ b/src/test/regress/sql/rules.sql @@ -251,7 +251,11 @@ select * from rtest_admin; update rtest_person set pname = 'jwieck' where pdesc = 'Jan Wieck'; -select * from rtest_admin; +-- Note: use ORDER BY here to ensure consistent output across all systems. +-- The above UPDATE affects two rows with equal keys, so they could be +-- updated in either order depending on the whim of the local qsort(). + +select * from rtest_admin order by pname, sysname; delete from rtest_system where sysname = 'orion'; |