diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-08-05 15:17:59 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-08-05 15:17:59 +0000 |
| commit | 2965400275d05795c143701d07d1ff25822c70ab (patch) | |
| tree | 23d2846343fed64dc1258e13bf3605678e5f93d3 | |
| parent | d8b04d5fac574d96252230c39a16f651b185661f (diff) | |
| download | postgresql-2965400275d05795c143701d07d1ff25822c70ab.tar.gz | |
Add an ORDER BY to one more SELECT DISTINCT test case, per buildfarm results.
| -rw-r--r-- | src/test/regress/expected/select_distinct.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/select_distinct.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/select_distinct.out b/src/test/regress/expected/select_distinct.out index fe64fe0d9c..3b5200b17a 100644 --- a/src/test/regress/expected/select_distinct.out +++ b/src/test/regress/expected/select_distinct.out @@ -4,7 +4,7 @@ -- -- awk '{print $3;}' onek.data | sort -n | uniq -- -SELECT DISTINCT two FROM tmp; +SELECT DISTINCT two FROM tmp ORDER BY 1; two ----- 0 diff --git a/src/test/regress/sql/select_distinct.sql b/src/test/regress/sql/select_distinct.sql index 7416e0194e..d97c397d06 100644 --- a/src/test/regress/sql/select_distinct.sql +++ b/src/test/regress/sql/select_distinct.sql @@ -5,7 +5,7 @@ -- -- awk '{print $3;}' onek.data | sort -n | uniq -- -SELECT DISTINCT two FROM tmp; +SELECT DISTINCT two FROM tmp ORDER BY 1; -- -- awk '{print $5;}' onek.data | sort -n | uniq |