hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ztao1...@apache.org
Subject incubator-hawq git commit: HAWQ-924. Refactor feature test for querycontext with new test framework
Date Thu, 14 Jul 2016 03:24:58 GMT
Repository: incubator-hawq
Updated Branches:
  refs/heads/master 0171b38a4 -> b0ee0aee1


HAWQ-924. Refactor feature test for querycontext with new test framework


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

Branch: refs/heads/master
Commit: b0ee0aee187d2b0a72fb5258059f161e18545363
Parents: 0171b38
Author: ztao1987 <zhenglin.taozl@gmail.com>
Authored: Thu Jul 14 10:57:08 2016 +0800
Committer: ztao1987 <zhenglin.taozl@gmail.com>
Committed: Thu Jul 14 10:57:08 2016 +0800

----------------------------------------------------------------------
 src/test/regress/expected/querycontext.out | 95 -------------------------
 src/test/regress/known_good_schedule       |  1 -
 src/test/regress/sql/querycontext.sql      | 67 -----------------
 3 files changed, 163 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/b0ee0aee/src/test/regress/expected/querycontext.out
----------------------------------------------------------------------
diff --git a/src/test/regress/expected/querycontext.out b/src/test/regress/expected/querycontext.out
deleted file mode 100644
index 82d37e0..0000000
--- a/src/test/regress/expected/querycontext.out
+++ /dev/null
@@ -1,95 +0,0 @@
-set Debug_querycontext_print = true;
-set Debug_querycontext_print_tuple = true;
---disable dispatching query context
-set gp_query_context_mem_limit = 0;
-create table a (a int);
-NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum
Database data distribution key for this table.
-HINT:  The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s)
chosen are the optimal data distribution key to minimize skew.
-select * from a;
- a 
----
-(0 rows)
-
-insert into a select generate_series(1, 10000);
-select count(1), sum(a) from a;
- count |   sum    
--------+----------
- 10000 | 50005000
-(1 row)
-
-truncate a;
-select * from a;
- a 
----
-(0 rows)
-
-insert into a select generate_series(1, 10000);
-select count(1), sum(a) from a;
- count |   sum    
--------+----------
- 10000 | 50005000
-(1 row)
-
-drop table a;
---set a small value, 2K
-set gp_query_context_mem_limit = 2;
-create table a (a int);
-NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum
Database data distribution key for this table.
-HINT:  The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s)
chosen are the optimal data distribution key to minimize skew.
-select * from a;
- a 
----
-(0 rows)
-
-insert into a select generate_series(1, 10000);
-select count(1), sum(a) from a;
- count |   sum    
--------+----------
- 10000 | 50005000
-(1 row)
-
-truncate a;
-select * from a;
- a 
----
-(0 rows)
-
-insert into a select generate_series(1, 10000);
-select count(1), sum(a) from a;
- count |   sum    
--------+----------
- 10000 | 50005000
-(1 row)
-
-drop table a;
---set a small default value
-reset gp_query_context_mem_limit;
-create table a (a int);
-NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Greenplum
Database data distribution key for this table.
-HINT:  The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s)
chosen are the optimal data distribution key to minimize skew.
-select * from a;
- a 
----
-(0 rows)
-
-insert into a select generate_series(1, 10000);
-select count(1), sum(a) from a;
- count |   sum    
--------+----------
- 10000 | 50005000
-(1 row)
-
-truncate a;
-select * from a;
- a 
----
-(0 rows)
-
-insert into a select generate_series(1, 10000);
-select count(1), sum(a) from a;
- count |   sum    
--------+----------
- 10000 | 50005000
-(1 row)
-
-drop table a;

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/b0ee0aee/src/test/regress/known_good_schedule
----------------------------------------------------------------------
diff --git a/src/test/regress/known_good_schedule b/src/test/regress/known_good_schedule
index a402997..58608ce 100755
--- a/src/test/regress/known_good_schedule
+++ b/src/test/regress/known_good_schedule
@@ -1,7 +1,6 @@
 # $PostgreSQL: pgsql/src/test/regress/serial_schedule,v 1.33 2006/08/30 23:34:22 tgl Exp
$
 # This should probably be in an order similar to parallel_schedule.
 test: type_sanity
-test: querycontext
 test: errortbl
 test: goh_create_type_composite
 ignore: goh_create_table

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/b0ee0aee/src/test/regress/sql/querycontext.sql
----------------------------------------------------------------------
diff --git a/src/test/regress/sql/querycontext.sql b/src/test/regress/sql/querycontext.sql
deleted file mode 100644
index f30c73d..0000000
--- a/src/test/regress/sql/querycontext.sql
+++ /dev/null
@@ -1,67 +0,0 @@
-set Debug_querycontext_print = true;
-set Debug_querycontext_print_tuple = true;
-
---disable dispatching query context
-set gp_query_context_mem_limit = 0;
-
-create table a (a int);
-
-select * from a;
-
-insert into a select generate_series(1, 10000);
-
-select count(1), sum(a) from a;
-
-truncate a;
-
-select * from a;
-
-insert into a select generate_series(1, 10000);
-
-select count(1), sum(a) from a;
-
-drop table a;
-
-
---set a small value, 2K
-set gp_query_context_mem_limit = 2;
-
-create table a (a int);
-
-select * from a;
-
-insert into a select generate_series(1, 10000);
-
-select count(1), sum(a) from a;
-
-truncate a;
-
-select * from a;
-
-insert into a select generate_series(1, 10000);
-
-select count(1), sum(a) from a;
-
-drop table a;
-
-
---set a small default value
-reset gp_query_context_mem_limit;
-
-create table a (a int);
-
-select * from a;
-
-insert into a select generate_series(1, 10000);
-
-select count(1), sum(a) from a;
-
-truncate a;
-
-select * from a;
-
-insert into a select generate_series(1, 10000);
-
-select count(1), sum(a) from a;
-
-drop table a;
\ No newline at end of file


Mime
View raw message