diff options
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 27 |
1 files changed, 22 insertions, 5 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 32f9bf24703..49d6186f389 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -1,13 +1,9 @@ # # Basic stored PROCEDURE tests # -# Please keep this file free of --error cases and other -# things that will not run in a single debugged mysqld -# process (e.g. master-slave things). -# # Test cases for bugs are added at the end. See template there. # -# Tests that require --error go into sp-error.test +# Some tests that require --error go into sp-error.test # Tests that require inndb go into sp_trans.test # Tests that check privilege and security issues go to sp-security.test. # Tests that require multiple connections, except security/privilege tests, @@ -6296,6 +6292,25 @@ call bug21416()| drop procedure bug21416| # +# BUG#21414: SP: Procedure undroppable, to some extent +# +--disable_warnings +DROP PROCEDURE IF EXISTS bug21414| +--enable_warnings + +CREATE PROCEDURE bug21414() SELECT 1| + +FLUSH TABLES WITH READ LOCK| + +--error ER_CANT_UPDATE_WITH_READLOCK +DROP PROCEDURE bug21414| + +UNLOCK TABLES| + +--echo The following should succeed. +DROP PROCEDURE bug21414| + +# # BUG#21493: Crash on the second call of a procedure containing # a select statement that uses an IN aggregating subquery # @@ -6363,6 +6378,8 @@ DROP FUNCTION bug21493| DROP TABLE t3,t4| --echo End of 5.0 tests + + # # BUG#NNNN: New bug synopsis # |