diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-02-10 04:18:32 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-02-10 04:18:32 +0000 |
commit | 23b65b8063c8b6e33ac8a84a33ecab8ff8a4177e (patch) | |
tree | fa9144373826b1ca2ae2d93ade772a8feca40d20 /src | |
parent | fc7de7c2cb1015764b21e7a95369a5eb2ce425de (diff) | |
download | postgresql-23b65b8063c8b6e33ac8a84a33ecab8ff8a4177e.tar.gz postgresql-23b65b8063c8b6e33ac8a84a33ecab8ff8a4177e.zip |
Hm, seems my hack on rowtypes regression test has made its output row
order platform-specific. Add an ORDER BY clause to stop buildfarm
failures.
Diffstat (limited to 'src')
-rw-r--r-- | src/test/regress/expected/rowtypes.out | 5 | ||||
-rw-r--r-- | src/test/regress/sql/rowtypes.sql | 3 |
2 files changed, 5 insertions, 3 deletions
diff --git a/src/test/regress/expected/rowtypes.out b/src/test/regress/expected/rowtypes.out index 8d3f5dffb15..dbf163cd695 100644 --- a/src/test/regress/expected/rowtypes.out +++ b/src/test/regress/expected/rowtypes.out @@ -207,11 +207,12 @@ HINT: Row comparison operators must be associated with btree operator families. -- Check row comparison with a subselect select unique1, unique2 from tenk1 where (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3) - and unique1 <= 20; + and unique1 <= 20 +order by 1; unique1 | unique2 ---------+--------- - 1 | 2838 0 | 9998 + 1 | 2838 (2 rows) -- Also check row comparison with an indexable condition diff --git a/src/test/regress/sql/rowtypes.sql b/src/test/regress/sql/rowtypes.sql index 1b68bad7a5e..779b20e8631 100644 --- a/src/test/regress/sql/rowtypes.sql +++ b/src/test/regress/sql/rowtypes.sql @@ -101,7 +101,8 @@ select ROW('ABC','DEF') ~~ ROW('DEF','ABC') as fail; -- Check row comparison with a subselect select unique1, unique2 from tenk1 where (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3) - and unique1 <= 20; + and unique1 <= 20 +order by 1; -- Also check row comparison with an indexable condition select thousand, tenthous from tenk1 |