diff options
| author | unknown <anozdrin@mysql.com> | 2006-02-22 13:44:04 +0300 |
|---|---|---|
| committer | unknown <anozdrin@mysql.com> | 2006-02-22 13:44:04 +0300 |
| commit | 85e54a08c4fc468ab89f8df27bc981027cb22e6c (patch) | |
| tree | c5cc250b79cd5ffa2679fe4e4773114610047ad0 /mysql-test/t/sp-security.test | |
| parent | b56d453c8dd28e3499ed161355fc40d8746012aa (diff) | |
| download | mariadb-git-85e54a08c4fc468ab89f8df27bc981027cb22e6c.tar.gz | |
Fix for BUG#7787: Stored procedures: improper warning for "grant execute" statement.
The problem was that error flag was not reset.
mysql-test/r/sp-security.result:
Results for test case for BUG#7787.
mysql-test/t/sp-security.test:
A test case for BUG#7787.
sql/sp.cc:
Reset errors after sp_find_routine().
Diffstat (limited to 'mysql-test/t/sp-security.test')
| -rw-r--r-- | mysql-test/t/sp-security.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/sp-security.test b/mysql-test/t/sp-security.test index 90160780618..19f94a32d9c 100644 --- a/mysql-test/t/sp-security.test +++ b/mysql-test/t/sp-security.test @@ -525,4 +525,26 @@ disconnect user_bug14533; drop user user_bug14533@localhost; drop database db_bug14533; + +# +# BUG#7787: Stored procedures: improper warning for "grant execute" statement +# + +# Prepare. + +CREATE DATABASE db_bug7787; +use db_bug7787; + +# Test. + +CREATE PROCEDURE p1() + SHOW INNODB STATUS; + +GRANT EXECUTE ON PROCEDURE p1 TO user_bug7787@localhost; + +# Cleanup. + +DROP DATABASE db_bug7787; +use test; + # End of 5.0 bugs. |