The time is incorrect after the time_zone is changed

[Hester-Gu]

Please check the FAQ documentation before raising an issue

when time_zone is default UTC+00:00:00

(root@nebula) [(none)]> RETURN now(), timestamp(), date(), time(), datetime();
+------------+-------------+------------+-----------------+----------------------------+
| now()      | timestamp() | date()     | time()          | datetime()                 |
+------------+-------------+------------+-----------------+----------------------------+
| 1670315448 | 1670315448  | 2022-12-06 | 08:30:48.160000 | 2022-12-06T08:30:48.160000 |
+------------+-------------+------------+-----------------+----------------------------+
Got 1 rows (time spent 224/519 us)

Tue, 06 Dec 2022 16:30:48 CST

(root@nebula) [(none)]>  return time("19:03:00") > time("07:59:59")
+-------------------------------------+
| (time("19:03:00")>time("07:59:59")) |
+-------------------------------------+
| true                                |
+-------------------------------------+
Got 1 rows (time spent 266/508 us)

Tue, 06 Dec 2022 16:27:27 CST

(root@nebula) [(none)]> 
(root@nebula) [(none)]> return time("19:03:00") > time("08:00:00")
+-------------------------------------+
| (time("19:03:00")>time("08:00:00")) |
+-------------------------------------+
| true                                |
+-------------------------------------+
Got 1 rows (time spent 216/439 us)

but when time_zone is UTC+08:00

(root@nebula) [(none)]> return time("19:03:00") > time("07:59:59")
+-------------------------------------+
| (time("19:03:00")>time("07:59:59")) |
+-------------------------------------+
| false                               |
+-------------------------------------+
Got 1 rows (time spent 402/695 us)

Tue, 06 Dec 2022 16:35:51 CST

(root@nebula) [(none)]> return time("19:03:00") > time("08:00:00")
+-------------------------------------+
| (time("19:03:00")>time("08:00:00")) |
+-------------------------------------+
| true                                |
+-------------------------------------+
Got 1 rows (time spent 284/538 us)

Tue, 06 Dec 2022 16:35:56 CST

(root@nebula) [(none)]> RETURN now(), timestamp(), date(), time(), datetime();
+------------+-------------+------------+-----------------+----------------------------+
| now()      | timestamp() | date()     | time()          | datetime()                 |
+------------+-------------+------------+-----------------+----------------------------+
| 1670315763 | 1670315763  | 2022-12-06 | 16:36:03.894000 | 2022-12-06T16:36:03.894000 |
+------------+-------------+------------+-----------------+----------------------------+
Got 1 rows (time spent 291/629 us)

Tue, 06 Dec 2022 16:36:03 CST

return time("19:03:00")>time("07:59:59") is false

Describe the bug (required)

Your Environments (required)

• OS: uname -a
• Compiler: g++ --version or clang++ --version
• CPU: lscpu
• Commit id v3.1.0

How To Reproduce(required)

Steps to reproduce the behavior:

1. Step 1
2. Step 2
3. Step 3

Expected behavior

Additional context

[Shylock-Hg]

It's caused by Time overflow after converting Timezone.

[Shylock-Hg]

@foesa-yang Please note this on document.