hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From y...@apache.org
Subject incubator-hawq git commit: HAWQ-894. Add missed answer file for polymorphism case
Date Thu, 14 Jul 2016 08:59:22 GMT
Repository: incubator-hawq
Updated Branches:
  refs/heads/master ef3325f2b -> 077f708c7


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/077f708c
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/077f708c
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/077f708c

Branch: refs/heads/master
Commit: 077f708c73ab28c2142075d11877f56aeb93df62
Parents: ef3325f
Author: YI JIN <yjin@pivotal.io>
Authored: Thu Jul 14 18:58:33 2016 +1000
Committer: YI JIN <yjin@pivotal.io>
Committed: Thu Jul 14 18:58:33 2016 +1000

----------------------------------------------------------------------
 .../query/ans/polimorphism-test1-query.ans      | 190 +++++++++++++++++++
 1 file changed, 190 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/077f708c/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)
+


Mime
View raw message