diff options
| author | malff@lambda.hsd1.co.comcast.net. <> | 2007-10-16 11:16:31 -0600 |
|---|---|---|
| committer | malff@lambda.hsd1.co.comcast.net. <> | 2007-10-16 11:16:31 -0600 |
| commit | a9c6ed46e2c76fd73744c28564cfc216206bb469 (patch) | |
| tree | cb255a5a791fb89a3c5e9ecfa1dbf2f7c4e0a04a /mysql-test/t | |
| parent | 99a270ba0f86ed5a163b7f570a0808eb6e4eb8cb (diff) | |
| download | mariadb-git-a9c6ed46e2c76fd73744c28564cfc216206bb469.tar.gz | |
Implementing code review comments
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/sp.test | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 501d96c842a..785e7e3793c 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -7671,6 +7671,35 @@ DROP FUNCTION f1; ########################################################################### +# +# Bug#28318 (CREATE FUNCTION (UDF) requires a schema) +# + +--disable_warnings +DROP PROCEDURE IF EXISTS db28318_a.t1; +DROP PROCEDURE IF EXISTS db28318_b.t2; +DROP DATABASE IF EXISTS db28318_a; +DROP DATABASE IF EXISTS db28318_b; +--enable_warnings + +CREATE DATABASE db28318_a; +CREATE DATABASE db28318_b; + +CREATE PROCEDURE db28318_a.t1() SELECT "db28318_a.t1"; +CREATE PROCEDURE db28318_b.t2() CALL t1(); + +use db28318_a; + +# In db28318_b.t2, t1 refers to db28318_b.t1 +--error ER_SP_DOES_NOT_EXIST +CALL db28318_b.t2(); + +DROP PROCEDURE db28318_a.t1; +DROP PROCEDURE db28318_b.t2; +DROP DATABASE db28318_a; +DROP DATABASE db28318_b; + + --echo # ------------------------------------------------------------------ --echo # -- End of 5.0 tests --echo # ------------------------------------------------------------------ |