为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:select id_code--05134349426-20220509-160333-10045 Packe4
【操作系统】:
【CPU】:
【问题描述】*:
select distint t1.VER_PERSON_ID,
j2.mo_person_id,
t1.MO_VERSION_ID,
t1.RES_PERSON_ID,
t1.MO_PROJECT_ID,
t1.PERSON_ID,
(case
when (t1.JFG07003 is not null and t1.JFG07003!='') then t1.JFG07003
else ba01.POST_INCUMBENT end) as JFG07003,
(case
when (t1.JFG07004 is not null and t1.JFG07004!='') then t1.JFG07004
else ba01.REA_INCUMBENT end) as JFG07004,
t1.BIZ_PERSON_ID,
t3.MO_GROUP_ID,
t3.JFG06001,
t3.JFG06002,
t1.JFG07001,
ba01.POST_INCUMBENT,
ba01.after_positions_category,
t2.JFG01005,
t2.remark,
t1.created_date,
ba01.post_unit_id,
t1.JFG07002 AS "order",
t1.JFG07002,
t3.JFG06003,
(case
when exists(select 1
from jfg35,
jfg02
where jfg02.MO_PERSON_ID = jfg35.MO_PERSON_ID
and jfg35.JFG35001 = '01'
and jfg35.JFG35002 = '02'
and jfg02.RES_PERSON_ID = t1.RES_PERSON_ID) then 1
else 0 end) isSearchBv,
ba01.task_id as task_oid,
(select (case j19.JFG19003 when '1' then '通过' when '2' then '未通过' end)
from JFG19 j19
where j19.MO_PERSON_ID = j2.MO_PERSON_ID
and j19.JFG19005 = '3') jfg19003,
(select j19.jfg19004
from JFG19 j19
where j19.MO_PERSON_ID = j2.MO_PERSON_ID and j19.JFG19005 = '3') jfg19004,
(SELECT j27.JFG23003
FROM JFG26 j26
LEFT JOIN JFG27 j27 ON j26.CHK_RESULT_MAIN_ID = j27.CHK_RESULT_MAIN_ID
WHERE j26.EXAM_STATUS = '2'
AND J26.EXAM_SORT = '3'
AND j27.JFG23001 = '10'
AND j26.MO_PERSON_ID = j2.mo_person_ID
order by j27.CREATED_DATE desc LIMIT 1 ) jfg2300110
,( SELECT j27.JFG23003 FROM JFG26 j26 LEFT JOIN JFG27 j27 ON j26.CHK_RESULT_MAIN_ID=j27.CHK_RESULT_MAIN_ID WHERE j26.EXAM_STATUS='2' AND J26.EXAM_SORT='3' AND j27.JFG23001='11' AND j26.MO_PERSON_ID=j2.MO_PERSON_ID order by j27.CREATED_DATE desc LIMIT 1 ) jfg2300111
,( SELECT j27.JFG23003 FROM JFG26 j26 LEFT JOIN JFG27 j27 ON j26.CHK_RESULT_MAIN_ID=j27.CHK_RESULT_MAIN_ID WHERE j26.EXAM_STATUS='2' AND J26.EXAM_SORT='3' AND j27.JFG23001='12' AND j26.MO_PERSON_ID=j2.MO_PERSON_ID order by j27.CREATED_DATE desc LIMIT 1 ) jfg2300112
,( SELECT j27.JFG23003 FROM JFG26 j26 LEFT JOIN JFG27 j27 ON j26.CHK_RESULT_MAIN_ID=j27.CHK_RESULT_MAIN_ID WHERE j26.EXAM_STATUS='2' AND J26.EXAM_SORT='3' AND j27.JFG23001='13' AND j26.MO_PERSON_ID=j2.MO_PERSON_ID order by j27.CREATED_DATE desc LIMIT 1 ) jfg2300113
,( SELECT j27.JFG23003 FROM JFG26 j26 LEFT JOIN JFG27 j27 ON j26.CHK_RESULT_MAIN_ID=j27.CHK_RESULT_MAIN_ID WHERE j26.EXAM_STATUS='2' AND J26.EXAM_SORT='3' AND j27.JFG23001='14' AND j26.MO_PERSON_ID=j2.MO_PERSON_ID order by j27.CREATED_DATE desc LIMIT 1 ) jfg2300114
from JFG07 t1 left join jfg01 t2
on t1.RES_PERSON_ID = T2.RES_PERSON_ID left join jfg02 j2 on j2.RES_PERSON_ID = t1.RES_PERSON_ID left join biz_person_main ba01 on t1.biz_person_id = ba01.biz_person_id left join JFG06 t3 on t1.MO_GROUP_ID = t3.MO_GROUP_ID
WHERE t1.MO_VERSION_ID = '4051350148E5374C1CB26DCA48C48DDE'
and exists (select 1 from jfg43 where jfg43.object_type = '02'
and jfg43.object_id = j2.MO_PERSON_ID
and role_id = 'A9E973DD66ABB204B61DE7BBB39FF241' )
order by t3.JFG06003, t1.JFG07002;
大佬能不能帮看下,看其他问答有说版本问题,是不是啊,要怎么处理那;其中把标记加粗的j2.MO_PERSON_ID直接写死'10000',就不会报错;
测试库的版本是:4-2-18-21.08.20-146029-10013-ENT Pack14;;也不会报错;只有版本是select id_code--05134349426-20220509-160333-10045 Packe4的uat库,会报错?
这个执行报错截图看下