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]
