下方的代码单独执行,结果是正确的为1,但在存储过程中执行后结果就错了值为2,请问大神是什么原因该如何解决
select count(*)
into sre_count
from view_stacking_ctrl_get a
where 1 = 1
and a.features = features
/*and a.file_id like '%'||file_id||'%'*/
and a.spec = spec
and a.jzformula = jzformula
/*and a.gpformula like '%'||gpformula||'%'*/
and a.silu = silu
and a.value_03 = heicode
/* and a.gphei like '%'||gphei||'%'*/
and cap >= a.capdown
and cap <= a.capup
and a.voldown <= vol
and a.volup >= vol;
select count(*)
into sre_count
from view_stacking_ctrl_get a
where 1 = 1
and a.features = features
/*and a.file_id like '%'||file_id||'%'*/
and a.spec = spec
and a.jzformula = jzformula
/*and a.gpformula like '%'||gpformula||'%'*/
and a.silu = silu
and a.value_03 = heicode
/* and a.gphei like '%'||gphei||'%'*/
and cap >= a.capdown
and cap <= a.capup
and a.voldown <= vol
and a.volup >= vol;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货