Repository: incubator-hawq Updated Branches: refs/heads/master 9c8b59e00 -> 95995a62f
HAWQ-698 Restore create_table_test in checkinstall-good to make test pass due to dependencies between cases Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/95995a62 Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/95995a62 Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/95995a62 Branch: refs/heads/master Commit: 95995a62f48c1da688cb8af1a7a6346b1c1bac57 Parents: 9c8b59e Author: YI JIN <[email protected]> Authored: Mon Jul 18 21:19:23 2016 +1000 Committer: YI JIN <[email protected]> Committed: Mon Jul 18 21:19:23 2016 +1000 ---------------------------------------------------------------------- src/test/regress/expected/create_table_test.out | 112 ++++++++++++++++ src/test/regress/known_good_schedule | 1 + src/test/regress/sql/create_table_test.sql | 134 +++++++++++++++++++ 3 files changed, 247 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/95995a62/src/test/regress/expected/create_table_test.out ---------------------------------------------------------------------- diff --git a/src/test/regress/expected/create_table_test.out b/src/test/regress/expected/create_table_test.out new file mode 100755 index 0000000..d744410 --- /dev/null +++ b/src/test/regress/expected/create_table_test.out @@ -0,0 +1,112 @@ +-- +-- COPY +-- +CREATE TABLE aggtest ( + a int2, + b float4 +); +CREATE TABLE tenk1 ( + unique1 int4, + unique2 int4, + two int4, + four int4, + ten int4, + twenty int4, + hundred int4, + thousand int4, + twothousand int4, + fivethous int4, + tenthous int4, + odd int4, + even int4, + stringu1 name, + stringu2 name, + string4 name +) WITH OIDS; +CREATE TABLE slow_emp4000 ( + home_base box +); +CREATE TABLE person ( + name text, + age int4, + location point +); +CREATE TABLE onek ( + unique1 int4, + unique2 int4, + two int4, + four int4, + ten int4, + twenty int4, + hundred int4, + thousand int4, + twothousand int4, + fivethous int4, + tenthous int4, + odd int4, + even int4, + stringu1 name, + stringu2 name, + string4 name +); +CREATE TABLE emp ( + salary int4, + manager name +) INHERITS (person) WITH OIDS; +CREATE TABLE student ( + gpa float8 +) INHERITS (person); +CREATE TABLE stud_emp ( + percent int4 +) INHERITS (emp, student); +CREATE TABLE real_city ( + pop int4, + cname text, + outline path +); +CREATE TABLE road ( + name text, + thepath path +); +CREATE TABLE hash_i4_heap ( + seqno int4, + random int4 +); +CREATE TABLE hash_name_heap ( + seqno int4, + random name +); +CREATE TABLE hash_txt_heap ( + seqno int4, + random text +); +CREATE TABLE hash_f8_heap ( + seqno int4, + random float8 +); +CREATE TABLE bt_i4_heap ( + seqno int4, + random int4 +); +CREATE TABLE bt_name_heap ( + seqno name, + random int4 +); +CREATE TABLE bt_txt_heap ( + seqno text, + random int4 +); +CREATE TABLE bt_f8_heap ( + seqno float8, + random int4 +); +CREATE TABLE array_op_test ( + seqno int4, + i int4[], + t text[] +); +CREATE TABLE array_index_op_test ( + seqno int4, + i int4[], + t text[] +); http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/95995a62/src/test/regress/known_good_schedule ---------------------------------------------------------------------- diff --git a/src/test/regress/known_good_schedule b/src/test/regress/known_good_schedule index 292573b..71564b9 100755 --- a/src/test/regress/known_good_schedule +++ b/src/test/regress/known_good_schedule @@ -57,6 +57,7 @@ ignore: opr_sanity ignore: geometry ignore: horology ignore: create_type +test: create_table_test test: create_table_distribution ignore: create_function_2 test: copy http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/95995a62/src/test/regress/sql/create_table_test.sql ---------------------------------------------------------------------- diff --git a/src/test/regress/sql/create_table_test.sql b/src/test/regress/sql/create_table_test.sql new file mode 100644 index 0000000..3c42b80 --- /dev/null +++ b/src/test/regress/sql/create_table_test.sql @@ -0,0 +1,134 @@ +-- +-- COPY +-- + +CREATE TABLE aggtest ( + a int2, + b float4 +); + +CREATE TABLE tenk1 ( + unique1 int4, + unique2 int4, + two int4, + four int4, + ten int4, + twenty int4, + hundred int4, + thousand int4, + twothousand int4, + fivethous int4, + tenthous int4, + odd int4, + even int4, + stringu1 name, + stringu2 name, + string4 name +) WITH OIDS; + +CREATE TABLE slow_emp4000 ( + home_base box +); + +CREATE TABLE person ( + name text, + age int4, + location point +); + +CREATE TABLE onek ( + unique1 int4, + unique2 int4, + two int4, + four int4, + ten int4, + twenty int4, + hundred int4, + thousand int4, + twothousand int4, + fivethous int4, + tenthous int4, + odd int4, + even int4, + stringu1 name, + stringu2 name, + string4 name +); + +CREATE TABLE emp ( + salary int4, + manager name +) INHERITS (person) WITH OIDS; + + +CREATE TABLE student ( + gpa float8 +) INHERITS (person); + + +CREATE TABLE stud_emp ( + percent int4 +) INHERITS (emp, student); + +CREATE TABLE real_city ( + pop int4, + cname text, + outline path +); + +CREATE TABLE road ( + name text, + thepath path +); + +CREATE TABLE hash_i4_heap ( + seqno int4, + random int4 +); + +CREATE TABLE hash_name_heap ( + seqno int4, + random name +); + +CREATE TABLE hash_txt_heap ( + seqno int4, + random text +); + +CREATE TABLE hash_f8_heap ( + seqno int4, + random float8 +); + +CREATE TABLE bt_i4_heap ( + seqno int4, + random int4 +); + +CREATE TABLE bt_name_heap ( + seqno name, + random int4 +); + +CREATE TABLE bt_txt_heap ( + seqno text, + random int4 +); + +CREATE TABLE bt_f8_heap ( + seqno float8, + random int4 +); + +CREATE TABLE array_op_test ( + seqno int4, + i int4[], + t text[] +); + +CREATE TABLE array_index_op_test ( + seqno int4, + i int4[], + t text[] +);
