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 <zhenglin.ta...@gmail.com> Authored: Thu Jul 14 10:57:08 2016 +0800 Committer: rlei <r...@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