Below code executed independently, the result is correct is 1, but after a stored procedure that executes the result is a wrong value of 2, could you tell me how great god is the reason why the solution
Select count (*)
Into sre_count
The from view_stacking_ctrl_get a
Where 1=1
And a.f eatures=the features
/* and a.f ile_id like '%' | | file_id | | '%' */
And a.s pec=spec
And a. zformula=jzformula
Atul gawande at the/* and pformula like '%' | | gpformula | | '%' */
And a.s ilu=silu
And Dr. Alue_03=heicode
Atul gawande at the/* and phei like '%' | | gphei | | '%' */
And cap & gt;=a.c apdown
And cap & lt;=a.c apup
And Dr. Oldown & lt;=vol
And Dr. Olup & gt;=vol.

CodePudding user response:

With a stored procedure call, the return value is 2? 1 the running mean directly?

CodePudding user response:

Is the Count (*), the result of the two after the execution of the results are different, in the process of storage and query to the data does not meet the conditions