summaryrefslogtreecommitdiff
path: root/mysql-test/r/grant.result
diff options
context:
space:
mode:
authorunknown <thek@adventure.(none)>2007-11-26 19:31:41 +0100
committerunknown <thek@adventure.(none)>2007-11-26 19:31:41 +0100
commitf1ad502ae1ebcac625a0213f9de1f178eb7a481e (patch)
treede62ec4ce6fe4261be06adbc30cceadc56dae89b /mysql-test/r/grant.result
parent1522ef3f21e2ec4d2b0ab0be62fb7aa78a839583 (diff)
parent1ddb4722f4194691564396da05b09fe783d5b5de (diff)
downloadmariadb-git-f1ad502ae1ebcac625a0213f9de1f178eb7a481e.tar.gz
Merge adventure.(none):/home/thek/Development/cpp/bug16470/my51-bug16470
into adventure.(none):/home/thek/Development/cpp/mysql-5.1-runtime mysql-test/r/grant.result: Auto merged mysql-test/t/grant.test: Auto merged sql/sql_acl.cc: Auto merged sql/sql_parse.cc: manual merge
Diffstat (limited to 'mysql-test/r/grant.result')
-rw-r--r--mysql-test/r/grant.result19
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/grant.result b/mysql-test/r/grant.result
index 4d402d7d0e9..34f6e0b4379 100644
--- a/mysql-test/r/grant.result
+++ b/mysql-test/r/grant.result
@@ -1226,3 +1226,22 @@ drop user юзер_юзер@localhost;
grant select on test.* to очень_длинный_юзер@localhost;
ERROR HY000: String 'очень_длинный_юзер' is too long for user name (should be no longer than 16)
set names default;
+FLUSH PRIVILEGES without procs_priv table.
+RENAME TABLE mysql.procs_priv TO mysql.procs_gone;
+FLUSH PRIVILEGES;
+Warnings:
+Error 1146 Table 'mysql.procs_priv' doesn't exist
+Error 1547 Cannot load from mysql.mysql.procs_priv. The table is probably corrupted
+Assigning privileges without procs_priv table.
+CREATE DATABASE mysqltest1;
+CREATE PROCEDURE mysqltest1.test() SQL SECURITY DEFINER
+SELECT 1;
+GRANT EXECUTE ON FUNCTION mysqltest1.test TO mysqltest_1@localhost;
+ERROR 42S02: Table 'mysql.procs_priv' doesn't exist
+GRANT ALL PRIVILEGES ON test.* TO mysqltest_1@localhost;
+CALL mysqltest1.test();
+1
+1
+DROP DATABASE mysqltest1;
+RENAME TABLE mysql.procs_gone TO mysql.procs_priv;
+FLUSH PRIVILEGES;