Variable division in stored procedures causes 5.0.4 (NT) server to crash.

Folks,

Perhaps this is not allowed but in debugging my new stored procedure, I =
noticed that the following line (the SET statement) causes the MySQL =
server running on Windows 2000 to crash.

Is this a known problem or not allowed? I tried a wide verity of =
different options like using the CAST function, nothing seems to work. =
My original SET statement was (result was declared as an INT): SET =
result =3D CEILING(numerator / denominator);

Sample procedure--
--------------------------------
CREATE PROCEDURE divide(numerator INT, denominator INT)
BEGIN
DECLARE result FLOAT;
=20
SET result =3D numerator / denominator;
END;

Thanks,

Mark Smith

status information -
root@localhost-test_db~> status//
--------------
mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32)

Connection id: 1
SSL: Not in use
Using delimiter: //
Server version: 5.0.4-beta-nt-log
Protocol version: 10
Connection: localhost via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306
--------------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org