This is an automated email from the ASF dual-hosted git repository.
Gabriel39 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 63d22403f88 [fix](regression) Correct OceanBase timestamp expectations
(#69002)
63d22403f88 is described below
commit 63d22403f884fac95f2da22606719903dbd875ef
Author: Gabriel <[email protected]>
AuthorDate: Tue Oct 13 18:09:07 2026 +0800
[fix](regression) Correct OceanBase timestamp expectations (#69002)
### What problem does this PR solve?
The OceanBase JDBC all-types golden adds an extra eight hours to
non-null TIMESTAMP values even though the fixture and Doris result
rendering use Asia/Shanghai. Regenerate the expected output from the
existing fixture and add a comment explaining the timezone expectation.
### Release note
None
### Check List (For Author)
- Test:
- [x] Reproduce the timestamp mismatch with the original golden.
- [x] Regenerate the golden with the regression runner and pass ordinary
comparison mode.
- [x] Confirm only the three non-null TIMESTAMP cells change.
- Behavior changed: No production behavior changes.
- Does this need documentation: No.
Validation used the repository OceanBase 4.2.5-test image, unchanged
initialization SQL, and OceanBase JDBC driver 2.4.8. The source
session/global timezone was +08:00; switching the source session to UTC
changed timestamp display but preserved the epoch. The original golden
failed by eight hours; generated output passed ordinary comparison (1
suite, 0 failures, 0 skipped). Only three non-null TIMESTAMP cells
changed; all other columns and NULLs stayed identical.
Local validation reused existing Doris binaries (FE `5024d4e894`, BE
`a48a5221001`), rather than a fresh build of this master checkout. The
unrelated binlog service was not used in this JDBC validation.
---
.../data/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.out | 6 +++---
.../external_table_p2/jdbc/test_oceanbase_jdbc_catalog.groovy | 2 ++
2 files changed, 5 insertions(+), 3 deletions(-)
diff --git
a/regression-test/data/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.out
b/regression-test/data/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.out
index d263337189a..b7ab1065b82 100644
---
a/regression-test/data/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.out
+++
b/regression-test/data/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.out
@@ -1,7 +1,7 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !query --
-\N 302 \N 502 602 4.14159 \N 6.141592 \N
-124 -302 2013 -402 -502 -602 \N 2012-10-26
10:08:39.3457+08:00 2013-10-26T16:09:18 -5.14145 \N -7.1400
row2 \N 09:11:09.567 text2 0xE86F6C6C6F20576F726C67 \N
\N 0x2F \N 0x88656C6C9F Value3
-201 301 401 501 601 3.14159 4.1415926 5.141592
1 -123 -301 2012 -401 -501 -601 2012-10-30
2012-10-25 20:05:36.3457+08:00 2012-10-25T16:08:08 -4.14145
-5.1400000001 -6.1400 row1 line1 09:09:09.567 text1
0x48656C6C6F20576F726C64 {"age": 30, "city": "London", "name": "Alice"}
Option1,Option3 0x2A 0x48656C6C6F00000000000000 0x48656C6C6F Value2
-202 302 402 502 602 4.14159 5.1415926 6.141592
0 -124 -302 2013 -402 -502 -602 2012-11-01
2012-10-26 10:08:39.3457+08:00 2013-10-26T16:09:18 -5.14145
-6.1400000001 -7.1400 row2 line2 09:11:09.567 text2
0xE86F6C6C6F20576F726C67 {"age": 18, "city": "ChongQing", "name":
"Gaoxin"} Option1,Option2 0x2F 0x58676C6C6F00000000000000
0x88656C6C9F Value3
+\N 302 \N 502 602 4.14159 \N 6.141592 \N
-124 -302 2013 -402 -502 -602 \N 2012-10-26
02:08:39.3457+08:00 2013-10-26T16:09:18 -5.14145 \N -7.1400
row2 \N 09:11:09.567 text2 0xE86F6C6C6F20576F726C67 \N
\N 0x2F \N 0x88656C6C9F Value3
+201 301 401 501 601 3.14159 4.1415926 5.141592
1 -123 -301 2012 -401 -501 -601 2012-10-30
2012-10-25 12:05:36.3457+08:00 2012-10-25T16:08:08 -4.14145
-5.1400000001 -6.1400 row1 line1 09:09:09.567 text1
0x48656C6C6F20576F726C64 {"age": 30, "city": "London", "name": "Alice"}
Option1,Option3 0x2A 0x48656C6C6F00000000000000 0x48656C6C6F Value2
+202 302 402 502 602 4.14159 5.1415926 6.141592
0 -124 -302 2013 -402 -502 -602 2012-11-01
2012-10-26 02:08:39.3457+08:00 2013-10-26T16:09:18 -5.14145
-6.1400000001 -7.1400 row2 line2 09:11:09.567 text2
0xE86F6C6C6F20576F726C67 {"age": 18, "city": "ChongQing", "name":
"Gaoxin"} Option1,Option2 0x2F 0x58676C6C6F00000000000000
0x88656C6C9F Value3
203 303 403 503 603 7.14159 8.1415926 9.141592
0 \N -402 2017 -602 -902 -1102 2012-11-02 \N
2013-10-27T16:11:18 -5.14145 -6.1400000000001 -7.1400 row3
line3 09:11:09.567 text3 0xE86F6C6C6F20576F726C67 {"age": 24,
"city": "ChongQing", "name": "ChenQi"} Option2 0x2F
0x58676C6C6F00000000000000 \N Value1
diff --git
a/regression-test/suites/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.groovy
b/regression-test/suites/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.groovy
index 5e0f7a222fa..686bd6a357e 100644
---
a/regression-test/suites/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.groovy
+++
b/regression-test/suites/external_table_p2/jdbc/test_oceanbase_jdbc_catalog.groovy
@@ -22,6 +22,8 @@ suite("test_oceanbase_jdbc_catalog", "p2,external") {
String bucket = getS3BucketName()
String driver_url =
"https://${bucket}.${s3_endpoint}/regression/jdbc_driver/oceanbase-client-2.4.8.jar";
if (enabled != null && enabled.equalsIgnoreCase("true")) {
+ // The fixture is initialized in Asia/Shanghai, so TIMESTAMP values
must retain their
+ // local time in this session instead of receiving another eight-hour
shift.
sql """ set time_zone = 'Asia/Shanghai' """
String catalog_name = "oceanbase_catalog";
String ex_db_name = "doris_test";
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
