1 files changed, 103 insertions, 0 deletions
diff --git a/src/test/regress/expected/select_distinct.out b/src/test/regress/expected/select_distinct.out
new file mode 100644
index 00000000000..346816b157a
--- /dev/null
+++ b/src/test/regress/expected/select_distinct.out
@@ -0,0 +1,103 @@
+QUERY: SELECT DISTINCT two FROM temp;
+two
+---
+  0
+  1
+(2 rows)
+
+QUERY: SELECT DISTINCT ten FROM temp;
+ten
+---
+  0
+  1
+  2
+  3
+  4
+  5
+  6
+  7
+  8
+  9
+(10 rows)
+
+QUERY: SELECT DISTINCT string4 FROM temp;
+string4
+-------
+AAAAxx 
+HHHHxx 
+OOOOxx 
+VVVVxx 
+(4 rows)
+
+QUERY: SELECT DISTINCT two, string4, ten
+   FROM temp
+   ORDER BY two using <, string4 using <, ten using <;
+two|string4|ten
+---+-------+---
+  0|AAAAxx |  0
+  0|AAAAxx |  2
+  0|AAAAxx |  4
+  0|AAAAxx |  6
+  0|AAAAxx |  8
+  0|HHHHxx |  0
+  0|HHHHxx |  2
+  0|HHHHxx |  4
+  0|HHHHxx |  6
+  0|HHHHxx |  8
+  0|OOOOxx |  0
+  0|OOOOxx |  2
+  0|OOOOxx |  4
+  0|OOOOxx |  6
+  0|OOOOxx |  8
+  0|VVVVxx |  0
+  0|VVVVxx |  2
+  0|VVVVxx |  4
+  0|VVVVxx |  6
+  0|VVVVxx |  8
+  1|AAAAxx |  1
+  1|AAAAxx |  3
+  1|AAAAxx |  5
+  1|AAAAxx |  7
+  1|AAAAxx |  9
+  1|HHHHxx |  1
+  1|HHHHxx |  3
+  1|HHHHxx |  5
+  1|HHHHxx |  7
+  1|HHHHxx |  9
+  1|OOOOxx |  1
+  1|OOOOxx |  3
+  1|OOOOxx |  5
+  1|OOOOxx |  7
+  1|OOOOxx |  9
+  1|VVVVxx |  1
+  1|VVVVxx |  3
+  1|VVVVxx |  5
+  1|VVVVxx |  7
+  1|VVVVxx |  9
+(40 rows)
+
+QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
+age
+---
+ 98
+ 88
+ 78
+ 68
+ 60
+ 58
+ 50
+ 48
+ 40
+ 38
+ 34
+ 30
+ 28
+ 25
+ 24
+ 23
+ 20
+ 19
+ 18
+  8
+(20 rows)
+