From 5e8fbc83f1cf5744df8a47d5a59726efc5fc7689 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 20 May 2005 17:47:08 +0200 Subject: Fixed BUG#10537: Server crashes while loading data file into table through procedure. by simply disabling 'load' in stored procedures, like it's already disabled for prepared statements. (They must be made "re-execution" safe before working with either PS or SP.) mysql-test/r/sp-error.result: New test case for BUG#10537. mysql-test/t/sp-error.test: New test case for BUG#10537. sql/sql_yacc.yy: Disable LOAD in stored procedures (just as for prepared statements). --- mysql-test/r/sp-error.result | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'mysql-test/r/sp-error.result') diff --git a/mysql-test/r/sp-error.result b/mysql-test/r/sp-error.result index 683f3e12091..7c19f60471a 100644 --- a/mysql-test/r/sp-error.result +++ b/mysql-test/r/sp-error.result @@ -642,4 +642,8 @@ val x bug8408() 7 7 3 drop function bug8408| delete from t1| +drop procedure if exists bug10537| +create procedure bug10537() +load data local infile '/tmp/somefile' into table t1| +ERROR 0A000: LOAD DATA is not allowed in stored procedures drop table t1| -- cgit v1.2.1