Bug #54941 just executing a loop with a counter with initial value = 256
Submitted: 1 Jul 2010 17:57 Modified: 11 Feb 2018 12:50
Reporter: Roberto Cobo Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.1.47 ?? OS:Windows (XP SP3)
Assigned to: CPU Architecture:Any
Tags: loop

[1 Jul 2010 17:57] Roberto Cobo 
Description:
procedure(in loops int)
kk: loop
@loops= @loops -1;
if @loops < 0 then leave kk end;
...
...
end loop kk;

call procedure(256);

How to repeat:
procedure(in loops int)
kk: loop
@loops= @loops -1;
if @loops < 0 then leave kk end;
...
...
end loop kk;

call procedure(256);
[1 Jul 2010 18:02] Roberto Cobo 
Please, forgot about '@' characters because I was writting by heart. 

The current program is like this ...
if loops < @newgrupoA then 
    select count(*) ,grupoA,grupoB  from estadocotizAB group by grupoA,grupoB order by 1 desc;
    leave kk;
end if;
[1 Jul 2010 19:19] Roberto Cobo 
problem is a tinyint; but it is supposed to be reported and not to commit suicide by aplication....

Best regards.
[2 Jul 2010 4:16] Valeriy Kravchuk 
I do not see any tinyint in your code fragments. Please, provide the exact code that demonstrates the problem.
[2 Aug 2010 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[11 Feb 2018 12:50] Roy Lyseng 
Posted by developer:
 
Closing as bug has been suspended for more than 7 years.