Bug #9534 Stored Procedure: Server crash if procedure uses IN param in an operation.
Submitted: 31 Mar 2005 17:11 Modified: 29 Apr 2005 12:06
Reporter: Disha Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.3 Beta/5.0.4 BK Linux OS:Windows (Windows 2000)
Assigned to: Per-Erik Martin CPU Architecture:Any

[31 Mar 2005 17:11] Disha 
Description:
When a precision math operation is used in a procedure with the expression comprising the IN paramater of the procedure, the connection is lost (server crash)

How to repeat:
1. delimiter //
2. drop procedure if exists sp1//		
3. create procedure sp1 (IN i1 smallint)
    begin
	set @i2 = i1/2;
    end//
4. call sp1 (6)//

ACTUAL RESULT:
ERROR 2013 (HY000): Lost connection to MySQL server during query

EXPECTED RESULT:
No server crash should occur. @i2 should get set to 3.
[31 Mar 2005 17:24] MySQL Verification Team 
Verified on BK, however I am not sure if it is a duplicate, will
search for.
[31 Mar 2005 17:24] MySQL Verification Team 
Verified on BK, however I am not sure if it is a duplicate, will
search for.
[29 Apr 2005 12:06] Per-Erik Martin 
No longer repeatable.