 | | | Variable division in stored procedures causes 5.0.4 (NT) server to crash. | Variable division in stored procedures causes 5.0.4 (NT) server to crash. 2005-05-04 - By Mark Smith
Back
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 = CEILING(numerator
/ denominator);
Sample procedure--
-- ---- ---- ---- ---- ---- ----
CREATE PROCEDURE divide(numerator INT, denominator INT)
BEGIN
DECLARE result FLOAT;
SET result = numerator / denominator;
END;
Thanks,
Mark Smith
status information -
root@(protected)~> 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=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|