task_runs timezone bug

[bulolo]

• 数据库时区

SHOW VARIABLES LIKE '%time_zone%';

Variable_name	Value
system_time_zone	Asia/Shanghai
time_zone	Asia/Shanghai

• 当不加时间过滤条件的时候，时区为0时区

SELECT TASK_NAME,CREATE_TIME FROM `information_schema`.`task_runs` WHERE `TASK_NAME` = 'mv-2554142' ORDER BY `CREATE_TIME` DESC LIMIT 0,10

TASK_NAME	CREATE_TIME
mv-2554142	2024-10-19 02:07:19

• 当加上时间过滤条件的时候，时区变为东八区

SELECT TASK_NAME,CREATE_TIME FROM `information_schema`.`task_runs` WHERE `TASK_NAME` = 'mv-2554142' AND `CREATE_TIME` >= '2024-10-19 00:00:00' ORDER BY `CREATE_TIME` DESC LIMIT 0,10

TASK_NAME	CREATE_TIME
mv-2554142	2024-10-19 10:08:29