diff options
| author | unknown <pem@mysql.comhem.se> | 2005-04-20 17:59:28 +0200 |
|---|---|---|
| committer | unknown <pem@mysql.comhem.se> | 2005-04-20 17:59:28 +0200 |
| commit | c751c6ce7ce538409636f877bc11893830ee67d7 (patch) | |
| tree | de33ae00d77dbe29153517ed85b5c0f0dd6558a1 /sql/sql_yacc.yy | |
| parent | 5642bbd35e11e7eaca1e0654435198c084087584 (diff) | |
| download | mariadb-git-c751c6ce7ce538409636f877bc11893830ee67d7.tar.gz | |
Fixed BUG#7047: Stored procedure crash if alter procedure
by simply disallowing alter procedure/function in an SP (as for drop).
mysql-test/r/sp-error.result:
Added test case for BUG#7047.
mysql-test/t/sp-error.test:
Added test case for BUG#7047.
sql/share/errmsg.txt:
Modified error message for "update procedure/function" too.
sql/sql_yacc.yy:
Don't allow alter procedure/function in an SP.
Diffstat (limited to 'sql/sql_yacc.yy')
| -rw-r--r-- | sql/sql_yacc.yy | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/sql_yacc.yy b/sql/sql_yacc.yy index 9aa5d7fb4fc..7f5255aa764 100644 --- a/sql/sql_yacc.yy +++ b/sql/sql_yacc.yy @@ -3305,6 +3305,11 @@ alter: { LEX *lex= Lex; + if (lex->sphead) + { + my_error(ER_SP_NO_DROP_SP, MYF(0), "PROCEDURE"); + YYABORT; + } bzero((char *)&lex->sp_chistics, sizeof(st_sp_chistics)); } sp_a_chistics @@ -3318,6 +3323,11 @@ alter: { LEX *lex= Lex; + if (lex->sphead) + { + my_error(ER_SP_NO_DROP_SP, MYF(0), "FUNCTION"); + YYABORT; + } bzero((char *)&lex->sp_chistics, sizeof(st_sp_chistics)); } sp_a_chistics |