Bug #8936 | Stored Procedure: Procedures can be dropped unexpectedly | ||
---|---|---|---|
Submitted: | 4 Mar 2005 1:17 | Modified: | 4 Mar 2005 3:54 |
Reporter: | Shuichi Tamagawa | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.3-alpha-20050216 | OS: | Linux (SuSE Linux 9.2) |
Assigned to: | CPU Architecture: | Any |
[4 Mar 2005 1:17]
Shuichi Tamagawa
[4 Mar 2005 3:54]
MySQL Verification Team
mysql> drop procedure if exists sp1; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> drop procedure if exists sp2; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> delimiter // mysql> create procedure sp1() -> begin -> select * from t1; -> end// Query OK, 0 rows affected (0.00 sec) mysql> drop procedure sp2// ERROR 1305 (42000): PROCEDURE test.sp2 does not exist mysql> call sp1()// Empty set (0.01 sec) Query OK, 0 rows affected (0.01 sec)