doris:selectdb-doris-2.1.6
mysql:5.7
mysql catalog 使用时间函数查询外表,查询结不一致怎么回事,是使用方式不正确吗?
mysql catalog 信息
原表查询语句及结果正常:
使用时间函数查询无结果:
explain:
PLAN FRAGMENT 0
OUTPUT EXPRS:
id[#31]
updated[#32]
cast(updated as DATETIMEV2(3))[#33]
date(cast(updated as DATETIMEV2(6)))[#34]
convert_tz(cast(updated as DATETIMEV2(6)), '+00:00', '+08:00')[#35]
cast(updated as DATEV2)[#36]
PARTITION: UNPARTITIONED
0
HAS_COLO_PLAN_NODE: false
0
VRESULT SINK
MYSQL_PROTOCAL
0
1:VEXCHANGE
offset: 0
distribute expr lists:
0
PLAN FRAGMENT 1
0
PARTITION: RANDOM
0
HAS_COLO_PLAN_NODE: false
0
STREAM DATA SINK
EXCHANGE ID: 01
UNPARTITIONED
0
0:VJdbcScanNode(129)
TABLE: `ods`.`tb_proj_projecttask`
QUERY: SELECT `id`, `updated` FROM `ods`.`tb_proj_projecttask` WHERE (`updated` >= '2024-10-14 00:00:00') AND (`updated` <= '2024-10-14 23:59:59.999999')
PREDICATES: ((CAST(updated[#26] AS datetimev2(6)) >= '2024-10-14 00:00:00') AND (CAST(updated[#26] AS datetimev2(6)) <= '2024-10-14 23:59:59.999999'))
final projections: id[#8], updated[#26], CAST(updated[#26] AS datetimev2(3)), date(CAST(updated[#26] AS datetimev2(6))), convert_tz(CAST(updated[#26] AS datetimev2(6)), '+00:00', '+08:00'), CAST(updated[#26] AS datev2)
final project output tuple id: 1
0
0
Statistics
planed with unknown column statistics