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/06/16 05:35:43 UTC
incubator-hawq git commit: HAWQ-776. Fix time zone problem when
inserting time values for testing alter table add column
Repository: incubator-hawq
Updated Branches:
refs/heads/master dbf32f1b7 -> 1aa4a17b2
HAWQ-776. Fix time zone problem when inserting time values for testing alter table add column
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/1aa4a17b
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/1aa4a17b
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/1aa4a17b
Branch: refs/heads/master
Commit: 1aa4a17b2886cc63aae7da02239fcbecb7a51255
Parents: dbf32f1
Author: YI JIN <yj...@pivotal.io>
Authored: Thu Jun 16 15:35:10 2016 +1000
Committer: YI JIN <yj...@pivotal.io>
Committed: Thu Jun 16 15:35:10 2016 +1000
----------------------------------------------------------------------
.../feature/catalog/ans/alter-table-addcol-insert-alltypes.ans | 4 +++-
.../feature/catalog/sql/alter-table-addcol-insert-alltypes.sql | 1 +
2 files changed, 4 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/1aa4a17b/src/test/feature/catalog/ans/alter-table-addcol-insert-alltypes.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/catalog/ans/alter-table-addcol-insert-alltypes.ans b/src/test/feature/catalog/ans/alter-table-addcol-insert-alltypes.ans
index e28d8f6..4aec294 100644
--- a/src/test/feature/catalog/ans/alter-table-addcol-insert-alltypes.ans
+++ b/src/test/feature/catalog/ans/alter-table-addcol-insert-alltypes.ans
@@ -1,3 +1,5 @@
+SET TIME ZONE UTC;
+SET
INSERT INTO tmp
(a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, v, w, x, y, z)
VALUES (4,
@@ -29,6 +31,6 @@ INSERT 0 1
SELECT * FROM tmp;
initial | a | b | c | d | e | f | g | h | i | j | k | l | m | n | p | q | r | s | t | u | v | w | x | y | z
---------+---+------+------+-----+-----+---+-----------------------+------------------------+---+------------------------------------------------------------------------------+--------+-------+-----+-----------------+---------------+-----------+-----------------------+-----------------------------+---------------------+---------------------------------------+---------------------+----------+-----------+-----------+-----------
- | 4 | name | text | 4.1 | 4.1 | 2 | ((4.1,4.1),(3.1,3.1)) | 1995-05-01 00:30:30+10 | c | {"1995-05-01 00:30:30+10","1992-08-24 14:43:07+10","1970-01-01 10:00:00+10"} | 314159 | (1,1) | 512 | 1 2 3 4 5 6 7 8 | magnetic disk | (1.1,1.1) | [(4.1,4.1),(3.1,3.1)] | ((0,2),(4.1,4.1),(3.1,3.1)) | (4.1,4.1),(3.1,3.1) | ["1970-01-01 10:00:00+10" "infinity"] | 1970-01-01 00:00:00 | 01:00:10 | {1,2,3,4} | {1,2,3,4} | {1,2,3,4}
+ | 4 | name | text | 4.1 | 4.1 | 2 | ((4.1,4.1),(3.1,3.1)) | 1995-05-01 00:30:30+00 | c | {"1995-05-01 00:30:30+00","1992-08-24 14:43:07+00","1970-01-01 00:00:00+00"} | 314159 | (1,1) | 512 | 1 2 3 4 5 6 7 8 | magnetic disk | (1.1,1.1) | [(4.1,4.1),(3.1,3.1)] | ((0,2),(4.1,4.1),(3.1,3.1)) | (4.1,4.1),(3.1,3.1) | ["1970-01-01 00:00:00+00" "infinity"] | 1970-01-01 00:00:00 | 01:00:10 | {1,2,3,4} | {1,2,3,4} | {1,2,3,4}
(1 row)
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/1aa4a17b/src/test/feature/catalog/sql/alter-table-addcol-insert-alltypes.sql
----------------------------------------------------------------------
diff --git a/src/test/feature/catalog/sql/alter-table-addcol-insert-alltypes.sql b/src/test/feature/catalog/sql/alter-table-addcol-insert-alltypes.sql
index be3280a..0f8b59e 100644
--- a/src/test/feature/catalog/sql/alter-table-addcol-insert-alltypes.sql
+++ b/src/test/feature/catalog/sql/alter-table-addcol-insert-alltypes.sql
@@ -1,3 +1,4 @@
+SET TIME ZONE UTC;
INSERT INTO tmp
(a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, v, w, x, y, z)
VALUES (4,