diff options
| author | unknown <tsmith@quadxeon.mysql.com> | 2007-04-30 23:32:13 +0200 |
|---|---|---|
| committer | unknown <tsmith@quadxeon.mysql.com> | 2007-04-30 23:32:13 +0200 |
| commit | 3a89563ebbe6640b67d63475e6270550f990c2a8 (patch) | |
| tree | 8771319161efe2d72a8bfafc86c510423c2044dc /mysql-test/r/mysqldump.result | |
| parent | 93d6958fc8e2cc3b5e9a636a6db0c463138f19e9 (diff) | |
| parent | 0f6f3aa0c705e440b29474be5ebd7c8a4e7930ae (diff) | |
| download | mariadb-git-3a89563ebbe6640b67d63475e6270550f990c2a8.tar.gz | |
Merge quadxeon.mysql.com:/benchmarks/ext3/TOSAVE/tsmith/bk/maint/50
into quadxeon.mysql.com:/benchmarks/ext3/TOSAVE/tsmith/bk/maint/51
client/mysqldump.c:
Auto merge
mysql-test/r/mysqldump.result:
Manual merge
mysql-test/t/mysqldump.test:
SCCS merged
Diffstat (limited to 'mysql-test/r/mysqldump.result')
| -rw-r--r-- | mysql-test/r/mysqldump.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/mysqldump.result b/mysql-test/r/mysqldump.result index af0db95d97c..db1eecea6be 100644 --- a/mysql-test/r/mysqldump.result +++ b/mysql-test/r/mysqldump.result @@ -3308,6 +3308,33 @@ drop procedure sp1; drop user user1; drop user user2; drop database mysqldump_test_db; +# +# Bug 27293: mysqldump crashes when dumping routines +# defined by a different user +# +# Bug #22761: mysqldump reports no errors when using +# --routines without mysql.proc privileges +# +create database mysqldump_test_db; +grant all privileges on mysqldump_test_db.* to user1; +grant all privileges on mysqldump_test_db.* to user2; +create procedure mysqldump_test_db.sp1() select 'hello'; +DELIMITER ;; + +-- insufficient privileges to SHOW CREATE PROCEDURE `sp1` +-- does user2 have permissions on mysql.proc? + +DELIMITER ; +DELIMITER ;; +/*!50003 SET SESSION SQL_MODE=""*/;; +/*!50003 CREATE*/ /*!50020 DEFINER=`user1`@`%`*/ /*!50003 PROCEDURE `sp1`() +select 'hello' */;; +/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;; +DELIMITER ; +drop procedure sp1; +drop user user1; +drop user user2; +drop database mysqldump_test_db; # # End of 5.0 tests # |