【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】4.3.1
【问题描述】 查询此语句 select
*
from(
select
ra.id,
ra.lineid,
ra.imgid,
ra.cameraid,
ra.ptaskid,
ra.pole_id as poleid,
ra.ptask_result_id as pTaskResultId,
ra.station,
ra.segment,
ra.mileage,
ra.pole_num as poleNum,
ra.filename as fileName,
ra.comp_name as compName,
ra.defect_area as defectArea,
ra.manual_add as manualAdd,
ra.exampart,
ra.problem,
ra.historyDate,
ra.level,
ra.ymin,
ra.xmin,
ra.ymax,
ra.xmax,
ra.areatype,
ra.areacode,
IF (
ra.areacode_confirm is null
or ra.areacode_confirm = ‘’,
ra.areacode,
ra.areacode_confirm
) as areacode_confirm,
ra.compcode,
IF (
ra.compcode_confirm is null
or ra.compcode_confirm = ‘’,
ra.compcode,
ra.compcode_confirm
) as compcode_confirm,
IF (
ra.part_name is null
or ra.part_name = ‘’,
ra.areadesc,
ra.part_name
) as partName,
ra.areadesc,
ra.description,
ra.markstate,
ra.seen_state as seenState,
ra.areaid,
ra.parentid,
ra.createDate,
ra.updateDate,
ra.delFlag,
ra.follow_flag as followFlag,
ra.follow_reason as followReason,
ra.repeat_flag as repeatFlag,
bdl.defect_level_value as defectLevelValue
from
result_areas_78a4517d8d044c65954da50bb1b83167 ra
left join base_defect_level bdl on ra.level = bdl.defect_level_key
AND bdl.del_flag = 0
where
ra.delFlag = 0
AND (
ra.parentid > -1
OR (
ra.parentid = -1
AND ra.manual_add = 1
)
OR (
ra.parentid = -1
AND ra.areatype in (0, 1, 2)
)
)
and ra.exampart = ‘基础和支柱’
order by
ra.pole_id,
ra.id
) t
where
1 = 1;
【复现路径】问题出现前后相关操作
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接（右键跳转查看）：