This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 4d6d2263cd4 [Enhancement](partial update)Add timezone case for partial
update timestamp #33177
4d6d2263cd4 is described below
commit 4d6d2263cd45ae29b12d7ced880533973062698d
Author: abmdocrt <[email protected]>
AuthorDate: Fri Apr 5 07:58:01 2024 +0800
[Enhancement](partial update)Add timezone case for partial update timestamp
#33177
---
.../unique_with_mow_p0/partial_update/test_partial_update.out | 6 ++++++
.../unique_with_mow_p0/partial_update/test_partial_update.groovy | 8 ++++++++
2 files changed, 14 insertions(+)
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 19b048316ae..e44c0055a32 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
@@ -38,6 +38,9 @@
-- !select_timestamp --
1
+-- !select_timestamp2 --
+11
+
-- !select_default --
1 doris 200 123 1
2 doris2 400 223 1
@@ -77,3 +80,6 @@
-- !select_timestamp --
1
+-- !select_timestamp2 --
+11
+
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 d1205bfa1b5..df5b4d4a8fb 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
@@ -206,6 +206,14 @@ suite("test_primary_key_partial_update", "p0") {
sql "INSERT INTO ${tableName}(`name`, `userid`, `corp_name`)
VALUES ('test1', 1234567, 'A');"
qt_select_timestamp "select count(*) from ${tableName} where
`ctime` > \"1970-01-01\""
+
+ sql "set time_zone = 'America/New_York'"
+
+ Thread.sleep(5000)
+
+ sql "INSERT INTO ${tableName}(`name`, `userid`, `corp_name`)
VALUES ('test2', 1234567, 'A');"
+
+ qt_select_timestamp2 "SELECT ABS(TIMESTAMPDIFF(HOUR, MIN(ctime),
MAX(ctime))) AS time_difference_hours FROM ${tableName};"
}
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
