求教 ：MYSQL catalog 外表查询结果不一致问题

Viewed 53
2.1 catalog

doris:selectdb-doris-2.1.6
mysql:5.7

mysql catalog 使用时间函数查询外表，查询结不一致怎么回事，是使用方式不正确吗？

mysql catalog 信息
image.png

原表查询语句及结果正常：
image.png
image.png

使用时间函数查询无结果：
image.png

image.png

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
Alstore21
2 Answers

explain 错误的sql 看一下
然后 select cast(updated as date) from tb;看一下

daidai1

【问题状态】已经复现
【问题处理】内部定位中，后续进展会更新到论坛

徐振超@SelectDB4921