You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by rl...@apache.org on 2016/07/19 02:50:36 UTC
[11/14] incubator-hawq git commit: HAWQ-894. Add missed answer file
for polymorphism case
HAWQ-894. Add missed answer file for polymorphism case
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/2e1b093f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/2e1b093f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/2e1b093f
Branch: refs/heads/2.0.0.0-incubating
Commit: 2e1b093f35faba2511eafcd0a2826ce8a7d5afb9
Parents: 0081706
Author: YI JIN <yj...@pivotal.io>
Authored: Thu Jul 14 18:58:33 2016 +1000
Committer: rlei <rl...@pivotal.io>
Committed: Tue Jul 19 10:49:42 2016 +0800
----------------------------------------------------------------------
.../query/ans/polimorphism-test1-query.ans | 190 +++++++++++++++++++
1 file changed, 190 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/2e1b093f/src/test/feature/query/ans/polimorphism-test1-query.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/query/ans/polimorphism-test1-query.ans b/src/test/feature/query/ans/polimorphism-test1-query.ans
new file mode 100644
index 0000000..decdf01
--- /dev/null
+++ b/src/test/feature/query/ans/polimorphism-test1-query.ans
@@ -0,0 +1,190 @@
+select f3, myaggp01a(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp01a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggp03a(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp03a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggp03b(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp03b
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggp05a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp05a
+----+-----------
+ a | {1,4,7}
+ b | {5,2,8}
+ c | {3,6}
+(3 rows)
+
+select f3, myaggp06a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp06a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggp08a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp08a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggp09a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp09a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggp09b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp09b
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggp10a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp10a
+----+-----------
+ a | {1,4,7}
+ b | {5,2,8}
+ c | {3,6}
+(3 rows)
+
+select f3, myaggp10b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp10b
+----+-----------
+ a | {1,4,7}
+ b | {5,2,8}
+ c | {3,6}
+(3 rows)
+
+select f3, myaggp20a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp20a
+----+-----------
+ a | {1,4,7}
+ b | {5,2,8}
+ c | {3,6}
+(3 rows)
+
+select f3, myaggp20b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggp20b
+----+-----------
+ a | {1,4,7}
+ b | {5,2,8}
+ c | {3,6}
+(3 rows)
+
+select f3, myaggn01a(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn01a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggn01b(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn01b
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggn03a(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn03a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggn05a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn05a
+----+-----------
+ a | {1,4,7}
+ b | {5,2,8}
+ c | {3,6}
+(3 rows)
+
+select f3, myaggn05b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn05b
+----+-----------
+ a | {1,4,7}
+ b | {5,2,8}
+ c | {3,6}
+(3 rows)
+
+select f3, myaggn06a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn06a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggn06b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn06b
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggn08a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn08a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggn08b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn08b
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggn09a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn09a
+----+-----------
+ a | {}
+ b | {}
+ c | {}
+(3 rows)
+
+select f3, myaggn10a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+ f3 | myaggn10a
+----+-----------
+ a | {1,4,7}
+ b | {5,2,8}
+ c | {3,6}
+(3 rows)
+
+select mysum2(f1, f1 + 1) from t;
+ mysum2
+--------
+ 80
+(1 row)
+