diff options
| author | pem@mysql.comhem.se <> | 2005-04-20 17:59:28 +0200 |
|---|---|---|
| committer | pem@mysql.comhem.se <> | 2005-04-20 17:59:28 +0200 |
| commit | 54dfe4a66a5bc2a17098aa0597b3a1a299cb61f0 (patch) | |
| tree | de33ae00d77dbe29153517ed85b5c0f0dd6558a1 /mysql-test | |
| parent | 189d6b502bbdf3b9e295177dc4f61ed28ca72db6 (diff) | |
| download | mariadb-git-54dfe4a66a5bc2a17098aa0597b3a1a299cb61f0.tar.gz | |
Fixed BUG#7047: Stored procedure crash if alter procedure
by simply disallowing alter procedure/function in an SP (as for drop).
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/sp-error.result | 13 | ||||
| -rw-r--r-- | mysql-test/t/sp-error.test | 14 |
2 files changed, 25 insertions, 2 deletions
diff --git a/mysql-test/r/sp-error.result b/mysql-test/r/sp-error.result index 3f224d790f7..5ee1d46f3c9 100644 --- a/mysql-test/r/sp-error.result +++ b/mysql-test/r/sp-error.result @@ -457,9 +457,9 @@ ERROR 42S22: Unknown column 'aa' in 'order clause' drop procedure bug2653_1| drop procedure bug2653_2| create procedure bug4344() drop procedure bug4344| -ERROR HY000: Can't drop a PROCEDURE from within another stored routine +ERROR HY000: Can't drop or alter a PROCEDURE from within another stored routine create procedure bug4344() drop function bug4344| -ERROR HY000: Can't drop a FUNCTION from within another stored routine +ERROR HY000: Can't drop or alter a FUNCTION from within another stored routine drop procedure if exists bug3294| create procedure bug3294() begin @@ -585,4 +585,13 @@ end; end; end| drop procedure bug9073| +create procedure bug7047() +alter procedure bug7047| +ERROR HY000: Can't drop or alter a PROCEDURE from within another stored routine +create function bug7047() returns int +begin +alter function bug7047; +return 0; +end| +ERROR HY000: Can't drop or alter a FUNCTION from within another stored routine drop table t1| diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test index ecbc98f86e9..cb4ebf080f4 100644 --- a/mysql-test/t/sp-error.test +++ b/mysql-test/t/sp-error.test @@ -818,6 +818,20 @@ drop procedure bug9073| # +# BUG#7047: Stored procedure crash if alter procedure +# +--error ER_SP_NO_DROP_SP +create procedure bug7047() + alter procedure bug7047| +--error ER_SP_NO_DROP_SP +create function bug7047() returns int +begin + alter function bug7047; + return 0; +end| + + +# # BUG#NNNN: New bug synopsis # #--disable_warnings |