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: | |
| 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: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.
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.