You created a nearly infinite loop!! Relax, it's a mistake we ALL have
made. ;-D

You start you loop at 1000 and keep increasing your numbers by 1 until they
become less than 10 (which should never happen). Eventually you will reach
the max value for @x's datatype then it should fail with an error on the
next loop. But, that could take quite a while...

Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine




                                                                                       
                                
                      "Mario Protto"                                                   
                                
                      <[EMAIL PROTECTED]        To:       <[EMAIL PROTECTED]>          
                             
                      ne.com>                  cc:                                     
                                
                                               Fax to:                                 
                                
                      07/08/2004 11:44         Subject:  newbie question about sp      
                                
                      AM                                                               
                                
                                                                                       
                                
                                                                                       
                                




I'm trying to call this simple store procedure on my XP with "mysql  Ver
14.3 Distrib 5.0.0-alpha, for Win95/Win98 (i32)", server is
5.0.0-alpha-max-debug-log:
________________________________
CREATE PROCEDURE test_repeat ()
BEGIN

  SET @x = 1000;
  REPEAT
    SET @x = @x + 1;
  UNTIL @x < 10
  END REPEAT;

END
________________________________

it seems to go in a loop that block the system instead of exit immediatly
from the repeat loop, is there some stupid error I can't see or there are
problem with repeat statement in version I am using?

thx all

Mario




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to