hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From y...@apache.org
Subject incubator-hawq git commit: HAWQ-776. Fix time zone problem when inserting time values for testing alter table add column
Date Thu, 16 Jun 2016 05:35:43 GMT
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 <yjin@pivotal.io>
Authored: Thu Jun 16 15:35:10 2016 +1000
Committer: YI JIN <yjin@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, 


Mime
View raw message