diff options
| author | Tom Lane | 2007-02-09 20:17:59 +0000 |
|---|---|---|
| committer | Tom Lane | 2007-02-09 20:17:59 +0000 |
| commit | 6be40def01a1ca5c673427b2aa47936e6fcba93f (patch) | |
| tree | 840161f077dcc898b2b99e1dc829b54be8afa055 | |
| parent | 6e1664beafc999f7143981e6d4bf7ae050f625c5 (diff) | |
Minor tweak to make rowtypes regression test run faster. We don't
currently have any better strategy for this query than re-running the
sub-select over and over; it seems unlikely that doing so 10000 times
is a more useful test than doing it a few dozen times.
| -rw-r--r-- | src/test/regress/expected/rowtypes.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/rowtypes.sql | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/src/test/regress/expected/rowtypes.out b/src/test/regress/expected/rowtypes.out index 10687f5669..8d3f5dffb1 100644 --- a/src/test/regress/expected/rowtypes.out +++ b/src/test/regress/expected/rowtypes.out @@ -206,7 +206,8 @@ LINE 1: select ROW('ABC','DEF') ~~ ROW('DEF','ABC') as fail; 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); +where (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3) + and unique1 <= 20; unique1 | unique2 ---------+--------- 1 | 2838 diff --git a/src/test/regress/sql/rowtypes.sql b/src/test/regress/sql/rowtypes.sql index 43d57bc603..1b68bad7a5 100644 --- a/src/test/regress/sql/rowtypes.sql +++ b/src/test/regress/sql/rowtypes.sql @@ -100,7 +100,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); +where (unique1, unique2) < any (select ten, ten from tenk1 where hundred < 3) + and unique1 <= 20; -- Also check row comparison with an indexable condition select thousand, tenthous from tenk1 |