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:35 UTC
[10/14] incubator-hawq git commit: HAWQ-924. Refactor feature test
for querycontext with new test framework
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/e65d463c
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/e65d463c
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/e65d463c
Branch: refs/heads/2.0.0.0-incubating
Commit: e65d463c42081d63b9219d768d8a6eacbf11183d
Parents: a2a79c6
Author: ztao1987 <zh...@gmail.com>
Authored: Thu Jul 14 10:57:08 2016 +0800
Committer: rlei <rl...@pivotal.io>
Committed: Tue Jul 19 10:49:42 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/e65d463c/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/e65d463c/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/e65d463c/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