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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.