zhangstar333 commented on issue #59412:
URL: https://github.com/apache/doris/issues/59412#issuecomment-4807158736
@xiongcp I can't reproduce your case.
could you give more infos to help me reproduce.
and u could change session variables "force_jni_scanner" and then test it,
look it's result worng?
```
mysql> desc test_tz_ctl.repro_ltz.t_ltz_repro;
+--------+-------------+------+------+---------+---------------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+------+---------+---------------+
| id | int | Yes | true | NULL | |
| ts_ltz | datetime(3) | Yes | true | NULL | WITH_TIMEZONE |
| note | text | Yes | true | NULL | |
+--------+-------------+------+------+---------+---------------+
3 rows in set (0.01 sec)
mysql> select * from test_tz_ctl.repro_ltz.t_ltz_repro;
+------+-------------------------+-----------------------------------------+
| id | ts_ltz | note |
+------+-------------------------+-----------------------------------------+
| 1 | 2025-12-24 00:50:02.503 | before_2025_12_24_00_50_02_503_utc |
| 2 | 2025-12-24 00:50:50.265 | before_2025_12_24_00_50_50_265_utc |
| 3 | 2025-12-25 00:00:00.000 | lower_bound_2025_12_25_00_00_00_000_utc |
| 4 | 2025-12-25 12:34:56.789 | inside_2025_12_25_12_34_56_789_utc |
| 5 | 2025-12-25 23:59:59.999 | inside_2025_12_25_23_59_59_999_utc |
| 6 | 2025-12-26 00:00:00.000 | upper_bound_2025_12_26_00_00_00_000_utc |
| 7 | 2025-12-26 00:00:00.001 | after_2025_12_26_00_00_00_001_utc |
+------+-------------------------+-----------------------------------------+
7 rows in set (0.04 sec)
mysql> SELECT id, ts_ltz, UNIX_TIMESTAMP(ts_ltz) AS ts, @@session.time_zone
AS tz FROM test_tz_ctl.repro_ltz.t_ltz_repro WHERE ts_ltz >= '2025-12-25
00:00:00+00:00' AND ts_ltz < '2025-12-26 00:00:00+00:00' ORDER BY id;
+------+-------------------------+----------------+------+
| id | ts_ltz | ts | tz |
+------+-------------------------+----------------+------+
| 3 | 2025-12-25 00:00:00.000 | 1766620800.000 | UTC |
| 4 | 2025-12-25 12:34:56.789 | 1766666096.789 | UTC |
| 5 | 2025-12-25 23:59:59.999 | 1766707199.999 | UTC |
+------+-------------------------+----------------+------+
3 rows in set (0.04 sec)
mysql> show variables like "%version%";
+--------------------------------------+-------------------------------------------+-------------------------------------------+---------+
| Variable_name | Value
| Default_Value | Changed |
+--------------------------------------+-------------------------------------------+-------------------------------------------+---------+
| cloud_partition_version_cache_ttl_ms | 0
| 0 | 0 |
| skip_checking_acid_version_file | false
| false | 0 |
| skip_missing_version | false
| false | 0 |
| version | 5.7.99
| 5.7.99 | 0 |
| version_comment | doris version
doris-3.1.3-rc01-6c7df037fa | doris version doris-3.1.3-rc01-6c7df037fa | 0
|
+--------------------------------------+-------------------------------------------+-------------------------------------------+---------+
5 rows in set (0.01 sec)
mysql>
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
