select if(length(new_owner)=0, null, convert(new_owner))
from dwd_transfers
where length(new_owner)=0;
对于UDF函数convert,如果参数长度为0会报错。现在通过if语句,理论上应该返回null,但是仍会走到concert函数报错!!!
select if(length(new_owner)=0, null, convert(new_owner))
from dwd_transfers
where length(new_owner)=0;
对于UDF函数convert,如果参数长度为0会报错。现在通过if语句,理论上应该返回null,但是仍会走到concert函数报错!!!