You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by yj...@apache.org on 2016/07/21 04:47:08 UTC

incubator-hawq git commit: HAWQ-894. Add missed sql script file

Repository: incubator-hawq
Updated Branches:
  refs/heads/master cc7844cce -> eab41edab


HAWQ-894. Add missed sql script file


Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/eab41eda
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/eab41eda
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/eab41eda

Branch: refs/heads/master
Commit: eab41edab5b49411120ab068775bb93b8df0bbaf
Parents: cc7844c
Author: YI JIN <yj...@pivotal.io>
Authored: Thu Jul 21 14:46:21 2016 +1000
Committer: YI JIN <yj...@pivotal.io>
Committed: Thu Jul 21 14:46:21 2016 +1000

----------------------------------------------------------------------
 .../query/sql/polimorphism-test1-query.sql      | 24 ++++++++++++++++++++
 1 file changed, 24 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/eab41eda/src/test/feature/query/sql/polimorphism-test1-query.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/query/sql/polimorphism-test1-query.sql b/src/test/feature/query/sql/polimorphism-test1-query.sql
new file mode 100644
index 0000000..b7be9a8
--- /dev/null
+++ b/src/test/feature/query/sql/polimorphism-test1-query.sql
@@ -0,0 +1,24 @@
+select f3, myaggp01a(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp03a(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp03b(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp05a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp06a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp08a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp09a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp09b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp10a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp10b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp20a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggp20b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn01a(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn01b(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn03a(*) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn05a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn05b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn06a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn06b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn08a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn08b(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn09a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select f3, myaggn10a(f1) from (select * from t order by f1 limit 10) as foo group by f3 order by f3;
+select mysum2(f1, f1 + 1) from t;
\ No newline at end of file