报错信息为：

inserted value too large for column: search table error:  [4013] value conversion failed;exception 70004013: cannot convert "100" to the type VARCHAR(2) for column PM

,Exception in executor plan337098564@hanaphn01

原语句：

原语句.zip

SELECT A.*,B.DTXS,A.TB-1 AS TBZF,A.HB-1 AS HBZF,TB.TBSJXSJS,HB.HBSJXSJS,DY.SJXSJS,QN.QNSJXSJE ,JN.JNSJXSJE FROM (

SELECT * FROM "_SYS_BIC"."CB.AL.YW/ZAL_BMYXSJDB"

(PLACEHOLDER."$$CALMONTH$$"=>'202308',

PLACEHOLDER."$$CALDAY$$"=>'20230813'

)

WHERE 1=1 --AND ZICZS0000 IN (${GET_ZICZS0000})

 ) A

LEFT JOIN 

(SELECT ZICZS0000,SUM(SJXSJE) AS DTXS FROM(

SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJE

FROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A 

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001

WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' 

AND C.ZICXA0005='Y' AND A.CALDAY='20230813' 

 AND A.ZICZS0008<>'8009194' --屏蔽大客户

) GROUP BY ZICZS0000

) B 

ON A.ZICZS0000=B.ZICZS0000

 LEFT JOIN 

 (

 SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS TBSJXSJS FROM(

SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJS

FROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A 

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001

WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' 

AND C.ZICXA0005='Y' AND A.CALMONTH='20220813' 

 AND A.ZICZS0008<>'8009194' --屏蔽大客户

) GROUP BY ZICZS0000,YF

 )

 TB ON A.ZICZS0000=TB.ZICZS0000

 LEFT JOIN 

 (

  SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS HBSJXSJS FROM(

SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJS

FROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A 

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001

WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' 

AND C.ZICXA0005='Y' AND A.CALMONTH='20230713' 

 AND A.ZICZS0008<>'8009194' --屏蔽大客户

)GROUP BY ZICZS0000,YF

 ) HB ON A.ZICZS0000=HB.ZICZS0000

  LEFT JOIN 

 (

  SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS SJXSJS FROM(

SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJS

FROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A 

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001

WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' 

AND C.ZICXA0005='Y' AND A.CALMONTH='202308' 

 AND A.ZICZS0008<>'8009194' --屏蔽大客户

)GROUP BY ZICZS0000,YF

 ) DY ON A.ZICZS0000=DY.ZICZS0000

 LEFT JOIN 

 (

  SELECT ZICZS0000,SUM(SJXSJE) AS QNSJXSJE FROM(

SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJE

FROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A 

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001

WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' 

AND C.ZICXA0005='Y' AND A.CALYEAR='2022' 

AND A.CALDAY<='20220813'  AND A.ZICZS0008<>'8009194'

)GROUP BY ZICZS0000

 ) QN ON A.ZICZS0000=QN.ZICZS0000

    LEFT JOIN 

 (

  SELECT ZICZS0000,SUM(SJXSJE) AS JNSJXSJE FROM(

SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJE

FROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A 

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000

INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001

WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' 

AND C.ZICXA0005='Y' AND A.CALYEAR='2023'  

AND A.CALDAY<='20230813' AND A.ZICZS0008<>'8009194'

)GROUP BY ZICZS0000

 ) JN ON A.ZICZS0000=JN.ZICZS0000

 WHERE  JN.JNSJXSJE<>0 OR A.ZIFYY0801>0

ORDER BY A.ZICZS0000