Re: MySQL - HHHHangs when a stored procedure is called - 5.0.22/InnoDB/WinXP-SP2

2006-08-16 Thread Chris
CREATE FUNCTION CharValIsNumeric (v VARCHAR(15)) RETURNS boolean BEGIN declare i, l int(2); set l=char_length(v); set i=1; while (i <= l) and (substring(v,i,1) in ('1','2','3','4','5','6','7','8','9','0')) do set i=i+1; end while; What if the string (v)

Re: MySQL - HHHHangs when a stored procedure is called - 5.0.22/InnoDB/WinXP-SP2

2006-08-16 Thread Asif Lodhi
Hi, I am replying to my own post - only to add that in response to the MySQL misbehaving, I just kill it and restart it. More than once, I also restarted the service, drop the database and re-created the database and all the tables, procedures, triggers, grants, etc. But still when I call the st