diff options
| author | anozdrin@mysql.com <> | 2006-02-22 13:44:04 +0300 |
|---|---|---|
| committer | anozdrin@mysql.com <> | 2006-02-22 13:44:04 +0300 |
| commit | a77cc69e6203b03f6a43c874b6e8e5f5b0797ccb (patch) | |
| tree | c5cc250b79cd5ffa2679fe4e4773114610047ad0 /mysql-test/r | |
| parent | f0abdf1ebe7fced136882a325d5ca787c847a100 (diff) | |
| download | mariadb-git-a77cc69e6203b03f6a43c874b6e8e5f5b0797ccb.tar.gz | |
Fix for BUG#7787: Stored procedures: improper warning for "grant execute" statement.
The problem was that error flag was not reset.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/sp-security.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/sp-security.result b/mysql-test/r/sp-security.result index ff729e87f97..d8abc387677 100644 --- a/mysql-test/r/sp-security.result +++ b/mysql-test/r/sp-security.result @@ -314,3 +314,12 @@ select * from db_bug14533.t1; ERROR 42000: SELECT command denied to user 'user_bug14533'@'localhost' for table 't1' drop user user_bug14533@localhost; drop database db_bug14533; +CREATE DATABASE db_bug7787; +use db_bug7787; +CREATE PROCEDURE p1() +SHOW INNODB STATUS; +Warnings: +Warning 1287 'SHOW INNODB STATUS' is deprecated; use 'SHOW ENGINE INNODB STATUS' instead +GRANT EXECUTE ON PROCEDURE p1 TO user_bug7787@localhost; +DROP DATABASE db_bug7787; +use test; |