hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shiv...@apache.org
Subject incubator-hawq git commit: HAWQ-405. installcheck-good updates
Date Thu, 11 Feb 2016 00:01:06 GMT
Repository: incubator-hawq
Updated Branches:
  refs/heads/HAWQ-405 7af430a43 -> b3708b3ad


HAWQ-405. installcheck-good updates


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

Branch: refs/heads/HAWQ-405
Commit: b3708b3ad0da893d6f41e2e52cd10a89fe430e66
Parents: 7af430a
Author: Shivram Mani <shivram.mani@gmail.com>
Authored: Wed Feb 10 16:01:02 2016 -0800
Committer: Shivram Mani <shivram.mani@gmail.com>
Committed: Wed Feb 10 16:01:02 2016 -0800

----------------------------------------------------------------------
 src/test/regress/expected/temp.out | 16 ++++++++++++++++
 src/test/regress/sql/temp.sql      |  5 +++++
 2 files changed, 21 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/b3708b3a/src/test/regress/expected/temp.out
----------------------------------------------------------------------
diff --git a/src/test/regress/expected/temp.out b/src/test/regress/expected/temp.out
index ebedd68..bb01598 100755
--- a/src/test/regress/expected/temp.out
+++ b/src/test/regress/expected/temp.out
@@ -170,3 +170,19 @@ select * from whereami;
 -- you can invoke a temp function explicitly, though
 -- select pg_temp.whoami();
 drop table public.whereami;
+create temp table temptest (row integer, count integer);
+insert into temptest values (1, 10), (2, 20), (3, 30);
+select avg(temptest.count) from temptest;
+ avg
+-----
+  20
+(1 row)
+
+select case when pg_temp.temptest.count = 30 then 30 when pg_temp.temptest.count = 20 then
20 else 10 end from pg_temp.temptest;
+ case
+------
+   10
+   20
+   30
+(3 rows)
+

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/b3708b3a/src/test/regress/sql/temp.sql
----------------------------------------------------------------------
diff --git a/src/test/regress/sql/temp.sql b/src/test/regress/sql/temp.sql
index d1f25d7..c3f1b44 100644
--- a/src/test/regress/sql/temp.sql
+++ b/src/test/regress/sql/temp.sql
@@ -151,3 +151,8 @@ select * from whereami;
 -- select pg_temp.whoami();
 
 drop table public.whereami;
+
+create temp table temptest (row integer, count integer);
+insert into temptest values (1, 10), (2, 20), (3, 30);
+select avg(temptest.count) from temptest;
+select case when pg_temp.temptest.count = 30 then 30 when pg_temp.temptest.count = 20 then
20 else 10 end from pg_temp.temptest;


Mime
View raw message