diff options
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 8ffefd5be00..433e07a3a90 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'; |