doris整合mybatis执行sql问题

Question

select

,count( DISTINCT l.data_id) as total ,sum(if(l.abnormal & 1 = 1, 1, 0)) abnormal, sum(if(l.abnormal & 1=0, 1, 0)) success,
COUNT(DISTINCT CASE WHEN l.org_code LIKE 'H%' THEN l.org_code END) AS medical_institution_count,
COUNT(DISTINCT CASE WHEN l.org_code LIKE 'P%' THEN l.org_code END) AS retail_pharmacy_count,
COUNT(DISTINCT l.org_code) AS total_institutions,
sum(ifnull(l.gb_node_num, 0) + ifnull(l.js_node_num, 0) + ifnull(l.qt_node_num, 0)+ifnull(l.bl_node_num, 0)+ifnull(l.zs_node_num,0)) AS total_node_count,
sum(ifnull(l.call_error_tc,0)) AS total_error_count

, SUBSTR(#{condition.startTime}, 1, 10) as start_time

, SUBSTR(#{condition.endTime}, 1, 10) as end_time

FROM
interface_call_log l
where l.outside = 0
AND l.data_source & 1 = 1
AND (l.abnormal & 1 IN(0, 1))

and l.division_code like #{condition.divisionCode}

and (
l.division_code like '${item}'
)

and l.interface_code in

#{item}

AND l.rev_admdv_code LIKE CONCAT( SUBSTR(#{condition.divisionCode}, 1, 2 ), '%' )

and l.date_time = ]]> #{condition.startTimeStr}

and l.date_time #{condition.endTimeStr}

and l.system_id = #{condition.systemId}

and l.org_code like #{condition.orgType}

group by

    报错信息：Caused by: java.sql.SQLException: errCode = 2, detailMessage = Unexpected exception: Implicit casts should never throw analysis exception.  不是每次报错 时间范围查询多点数据会报。感觉和优化器有关系。

阿渊@SelectDB (没回帖直接加我主页微信) · Answer

具体 2.1的哪个版本呢，show backends 看下version
分别开启和关闭优化器进行测试下：

-- 关闭新优化器，走老优化器
set enable_fallback_to_original_planner = true;
set experimental_enable_nereids_planner = false;


-- 关闭fallback ，走新优化器
set enable_fallback_to_original_planner false;
set experimental_enable_nereids_planner =true;

这个sql 手动执行能复现吗？还是说必须得通过 mybatis 才行呢？如果说手动可以复现的话，帮忙整理个可以复现的case吧，这里可能优化器的报错有问题。

zhuwei · Answer

2.1.6 单独执行sql不报错在mybatis执行报错而且是在数据量大的情况下才报，时间范围大了就会报。

doris整合mybatis执行sql问题

2 Answers