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 <[email protected]> Authored: Thu Jun 16 15:35:10 2016 +1000 Committer: YI JIN <[email protected]> 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,
