diff options
Diffstat (limited to 'src/test/regress/sql/select_distinct.sql')
-rw-r--r-- | src/test/regress/sql/select_distinct.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/sql/select_distinct.sql b/src/test/regress/sql/select_distinct.sql index eb23e6edb44..2bc50d49a1f 100644 --- a/src/test/regress/sql/select_distinct.sql +++ b/src/test/regress/sql/select_distinct.sql @@ -1,24 +1,24 @@ -- -- awk '{print $3;}' onek.data | sort -n | uniq -- -SELECT DISTINCT two FROM temp; +SELECT DISTINCT two FROM tmp; -- -- awk '{print $5;}' onek.data | sort -n | uniq -- -SELECT DISTINCT ten FROM temp; +SELECT DISTINCT ten FROM tmp; -- -- awk '{print $16;}' onek.data | sort -d | uniq -- -SELECT DISTINCT string4 FROM temp; +SELECT DISTINCT string4 FROM tmp; -- -- awk '{print $3,$16,$5;}' onek.data | sort -d | uniq | -- sort +0n -1 +1d -2 +2n -3 -- SELECT DISTINCT two, string4, ten - FROM temp + FROM tmp ORDER BY two using <, string4 using <, ten using <; -- |