mysql报错Error Code: 1292. Truncated incorrect INTEGER value: 'CANBM'

电竞煤老板 2017-04-14 02:45:50

今天同事和我说程序报了个错误，就是标题那个错误，可是我看了半天也看不出有什么错误。
INSERT INTO T_search_sttl_check_data
(
STTL_MONTH ,
cust_carrier_cd ,
check_result ,
total_number ,
not_sttl_numer ,
sttl_numer ,
not_present_number ,
not_file_numer ,
not_money_numer ,
temp_file_numer ,
partner_carrier_cd_numbeR ,
DIFFER_MONTH_NUMBER )
select invs.sttl_month,invs.cust_carrier_cd,
(case when invs.inv_num-opens.open_num= 0 then '相同' else '不相同'end),
invs.inv_num,
not_sttl_numer,sttl_numer,not_present_number,not_file_numer,not_money_numer,temp_file_numer,
opens.open_num,opens.open_diff_num
from (
select v_begin_month sttl_month,
t.cust_carrier_cd,
count(*) inv_num,
count(case when t.data_status = 0 then t.partner_carrier_cd else null end) not_sttl_numer,-- 未冲销
count(case when t.data_status = 1 then t.partner_carrier_cd else null end) sttl_numer,-- 已冲销
count(case when t.data_status = 3 then t.partner_carrier_cd else null end) not_present_number,-- 账单未到
count(case when t.data_status = 2 then t.partner_carrier_cd else null end) not_file_numer,-- 文件不全
count(case when t.data_status = 6 then t.partner_carrier_cd else null end) not_money_numer,-- 金额不符
count(case when t.data_status = 4 then t.partner_carrier_cd else null end) temp_file_numer-- 文件重复
from fcsdba.accnt_invoice t
where t.sttl_month =v_begin_month
and (t.cust_carrier_cd = i_CUST_CARRIER_CD or i_CUST_CARRIER_CD is null or i_CUST_CARRIER_CD = '')
and (t.biz_pkg = i_biz_pkg or i_biz_pkg is null or i_biz_pkg = '')
and t.biz_line=2
group by t.cust_carrier_cd
) invs,
(
select cust_carrier_cd,
sum(case when sttl_month = v_begin_month then 1 else 0 end ) open_num,
sum(case when sttl_month = v_begin_month then 1 else -1 end) open_diff_num
from(
select distinct p.cust_carrier_cd,p.partner_carrier_cd,p.biz_pkg,v_begin_month sttl_month
from pubdba.partner_carriers p,pubdba.partner_open_financial_info f
where 1=1
and date_format(p.effc_tm,'%Y%m')<=v_begin_month
and date_format(p.expired_tm,'%Y%m')>=v_begin_month
and p.cust_carrier_cd=f.cust_carrier_cd
and p.partner_carrier_cd=f.partner_carrier_cd
and p.biz_pkg=f.biz_pkg
and p.roam_mode in(0,2)
and (p.biz_pkg = i_biz_pkg or i_biz_pkg is null or i_biz_pkg = '')
and (p.cust_carrier_cd = i_CUST_CARRIER_CD or i_CUST_CARRIER_CD is null or i_CUST_CARRIER_CD = '')
and date_format(f.effc_tm,'%Y%m')<=v_begin_month
and date_format(f.expired_tm,'%Y%m')>=v_begin_month
union all
select distinct p.cust_carrier_cd,p.partner_carrier_cd,p.biz_pkg,v_last_month sttl_month
from pubdba.partner_carriers p,pubdba.partner_open_financial_info f
where 1=1
and date_format(p.effc_tm,'%Y%m')<=v_last_month
and date_format(p.expired_tm,'%Y%m')>=v_last_month
and p.cust_carrier_cd=f.cust_carrier_cd
and p.partner_carrier_cd=f.partner_carrier_cd
and p.biz_pkg=f.biz_pkg
and (p.biz_pkg = i_biz_pkg or i_biz_pkg is null or i_biz_pkg='')
and (p.cust_carrier_cd = i_CUST_CARRIER_CD or i_CUST_CARRIER_CD is null or i_CUST_CARRIER_CD = '')
and p.roam_mode in(0,2)
and date_format(f.effc_tm,'%Y%m')<=v_last_month
and date_format(f.expired_tm,'%Y%m')>=v_last_month
) t group by cust_carrier_cd
) opens
where invs.cust_carrier_cd=opens.cust_carrier_cd;

...全文