This is an automated email from the ASF dual-hosted git repository.
gavinchou pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new e9a32264bff [fix](regression) test_primary_key_partial_update fail due
to the U.S. change from DST to standard time (#43288)
e9a32264bff is described below
commit e9a32264bfff572cc1563b4aa49891e5b74fe116
Author: zhannngchen <[email protected]>
AuthorDate: Wed Nov 6 09:52:00 2024 +0800
[fix](regression) test_primary_key_partial_update fail due to the U.S.
change from DST to standard time (#43288)
The case used time zone `America/New_York`, and the result of
`TIMESTAMPDIFF` will change when U.S. switch between DST(daylight saving
time) and standard time, we should use a time zone not sensitive to
this.
---
.../data/unique_with_mow_c_p0/partial_update/test_partial_update.out | 4 ++--
.../data/unique_with_mow_p0/partial_update/test_partial_update.out | 4 ++--
.../unique_with_mow_c_p0/partial_update/test_partial_update.groovy | 2 +-
.../unique_with_mow_p0/partial_update/test_partial_update.groovy | 2 +-
4 files changed, 6 insertions(+), 6 deletions(-)
diff --git
a/regression-test/data/unique_with_mow_c_p0/partial_update/test_partial_update.out
b/regression-test/data/unique_with_mow_c_p0/partial_update/test_partial_update.out
index 8ed2e6fd900..e5efd741004 100644
---
a/regression-test/data/unique_with_mow_c_p0/partial_update/test_partial_update.out
+++
b/regression-test/data/unique_with_mow_c_p0/partial_update/test_partial_update.out
@@ -37,7 +37,7 @@
1
-- !select_timestamp2 --
-11
+1
-- !select_date --
1
@@ -86,7 +86,7 @@ B
1
-- !select_timestamp2 --
-11
+1
-- !select_date --
1
diff --git
a/regression-test/data/unique_with_mow_p0/partial_update/test_partial_update.out
b/regression-test/data/unique_with_mow_p0/partial_update/test_partial_update.out
index 70c57c2555e..6c611c00030 100644
---
a/regression-test/data/unique_with_mow_p0/partial_update/test_partial_update.out
+++
b/regression-test/data/unique_with_mow_p0/partial_update/test_partial_update.out
@@ -39,7 +39,7 @@
1
-- !select_timestamp2 --
-11
+1
-- !select_date --
1
@@ -90,7 +90,7 @@ B
1
-- !select_timestamp2 --
-11
+1
-- !select_date --
1
diff --git
a/regression-test/suites/unique_with_mow_c_p0/partial_update/test_partial_update.groovy
b/regression-test/suites/unique_with_mow_c_p0/partial_update/test_partial_update.groovy
index d5dcb839379..34a62e6da0c 100644
---
a/regression-test/suites/unique_with_mow_c_p0/partial_update/test_partial_update.groovy
+++
b/regression-test/suites/unique_with_mow_c_p0/partial_update/test_partial_update.groovy
@@ -257,7 +257,7 @@ suite("test_primary_key_partial_update", "p0") {
qt_select_timestamp "select count(*) from ${tableName} where
`ctime` > \"1970-01-01\""
- sql "set time_zone = 'America/New_York'"
+ sql "set time_zone = 'Asia/Tokyo'"
Thread.sleep(5000)
diff --git
a/regression-test/suites/unique_with_mow_p0/partial_update/test_partial_update.groovy
b/regression-test/suites/unique_with_mow_p0/partial_update/test_partial_update.groovy
index ea3dde5bf5b..9643f9501ed 100644
---
a/regression-test/suites/unique_with_mow_p0/partial_update/test_partial_update.groovy
+++
b/regression-test/suites/unique_with_mow_p0/partial_update/test_partial_update.groovy
@@ -207,7 +207,7 @@ suite("test_primary_key_partial_update", "p0") {
qt_select_timestamp "select count(*) from ${tableName} where
`ctime` > \"1970-01-01\""
- sql "set time_zone = 'America/New_York'"
+ sql "set time_zone = 'Asia/Tokyo'"
Thread.sleep(5000)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
