You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by yj...@apache.org on 2016/07/18 11:19:32 UTC
incubator-hawq git commit: HAWQ-698 Restore create_table_test in
checkinstall-good to make test pass due to dependencies between cases
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 <yj...@pivotal.io>
Authored: Mon Jul 18 21:19:23 2016 +1000
Committer: YI JIN <yj...@pivotal.io>
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[]
+);