diff options
author | Dmitry Shulga <Dmitry.Shulga@oracle.com> | 2011-06-08 20:44:50 +0700 |
---|---|---|
committer | Dmitry Shulga <Dmitry.Shulga@oracle.com> | 2011-06-08 20:44:50 +0700 |
commit | 92a017d324c38e9e52586c85bf5a4745b6fab78f (patch) | |
tree | 2984068fddb19e8226485741c3d15b0c6bfc19c3 /mysql-test/t | |
parent | ab3cae3dce34d4e0a854e79766acbd62ca718ef8 (diff) | |
download | mariadb-git-92a017d324c38e9e52586c85bf5a4745b6fab78f.tar.gz |
Added regression test for bug#11763757 "56510: ERROR 42000:
FUNCTION DOES NOT EXIST IF NOT-PRIV USER RECONNECTS".
The bug itself was fixed by the same patch as bug@11747137
"30977: CONCURRENT STATEMENT USING STORED FUNCTION AND DROP
FUNCTION BREAKS SBR".
Diffstat (limited to 'mysql-test/t')
-rw-r--r-- | mysql-test/t/sp_notembedded.test | 52 |
1 files changed, 41 insertions, 11 deletions
diff --git a/mysql-test/t/sp_notembedded.test b/mysql-test/t/sp_notembedded.test index b15f6351e59..e86e4ef32be 100644 --- a/mysql-test/t/sp_notembedded.test +++ b/mysql-test/t/sp_notembedded.test @@ -371,16 +371,6 @@ DELETE FROM mysql.user WHERE User='mysqltest_1'; FLUSH PRIVILEGES; -# -# Restore global concurrent_insert value. Keep in the end of the test file. -# - -set @@global.concurrent_insert= @old_concurrent_insert; - -# Wait till all disconnects are completed ---source include/wait_until_count_sessions.inc - - --echo # --echo # Bug#44521 Prepared Statement: CALL p() - crashes: `! thd->main_da.is_sent' failed et.al. --echo # @@ -449,7 +439,47 @@ DROP FUNCTION f1; --disconnect con1 --disconnect con2 - --echo # ------------------------------------------------------------------ --echo # -- End of 5.1 tests --echo # ------------------------------------------------------------------ + +--echo # +--echo # Test for bug#11763757 "56510: ERROR 42000: FUNCTION DOES NOT EXIST +--echo # IF NOT-PRIV USER RECONNECTS ". +--echo # +--echo # The real problem was that server was unable handle properly stored +--echo # functions in databases which names contained dot. +--echo # + +connection default; + +--disable_warnings +DROP DATABASE IF EXISTS `my.db`; +--enable_warnings + +create database `my.db`; +use `my.db`; + +CREATE FUNCTION f1(a int) RETURNS INT RETURN a; + +--echo # Create new connection. +connect (addcon, localhost, root,,); +connection addcon; +USE `my.db`; +SELECT f1(1); +SELECT `my.db`.f1(2); + +--echo # Switching to default connection. +connection default; +disconnect addcon; +DROP DATABASE `my.db`; + +# +# Restore global concurrent_insert value. Keep in the end of the test file. +# + +set @@global.concurrent_insert= @old_concurrent_insert; + +# Wait till all disconnects are completed +--source include/wait_until_count_sessions.inc + |