diff options
| author | unknown <kaa@polly.(none)> | 2007-11-09 13:29:43 +0300 |
|---|---|---|
| committer | unknown <kaa@polly.(none)> | 2007-11-09 13:29:43 +0300 |
| commit | 737cdfeaeb4efc8f0ddd366d77860334bec40df3 (patch) | |
| tree | 9a34bd787cb00e8a65e163cb3d759277c023b56f /mysql-test/r/skip_grants.result | |
| parent | 04311fabaa11105743ce124de283cd504c978cc4 (diff) | |
| download | mariadb-git-737cdfeaeb4efc8f0ddd366d77860334bec40df3.tar.gz | |
Fix for bug #32020: loading udfs while --skip-grant-tables is enabled
causes out of memory errors
The code in mysql_create_function() and mysql_drop_function() assumed
that the only reason for UDFs being uninitialized at that point is an
out-of-memory error during initialization. However, another possible
reason for that is the --skip-grant-tables option in which case UDF
initialization is skipped and UDFs are unavailable.
The solution is to check whether mysqld is running with
--skip-grant-tables and issue a proper error in such a case.
mysql-test/r/skip_grants.result:
Added a test case for bug #32020.
mysql-test/t/skip_grants.test:
Added a test case for bug #32020.
sql/sql_udf.cc:
Issue a proper error when a user tries to CREATE/DROP a UDF
on a server running with the --skip-grant-tables option.
Diffstat (limited to 'mysql-test/r/skip_grants.result')
| -rw-r--r-- | mysql-test/r/skip_grants.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/skip_grants.result b/mysql-test/r/skip_grants.result index 3052bae8e97..1ef35b051d6 100644 --- a/mysql-test/r/skip_grants.result +++ b/mysql-test/r/skip_grants.result @@ -70,3 +70,8 @@ count(*) select count(*) from information_schema.USER_PRIVILEGES; count(*) 0 +CREATE FUNCTION a RETURNS STRING SONAME ''; +ERROR HY000: Can't initialize function 'a'; UDFs are unavailable with the --skip-grant-tables option +DROP FUNCTION a; +ERROR 42000: FUNCTION test.a does not exist +End of 5.0 tests |