DROP TABLE IF EXISTS t0, t1 ;
DROP VIEW IF EXISTS v0;
DROP PROCEDURE IF EXISTS test_proc10;
DROP FUNCTION  IF EXISTS test_func1;
DROP FUNCTION  IF EXISTS test_func10;
DROP DATABASE IF EXISTS mysqltest_db1;
CREATE TABLE t0 (f1 BIGINT, f2 BIGINT);
INSERT INTO t0 VALUES(1, 1);
CREATE TABLE t1 AS SELECT * FROM t0;
DROP FUNCTION IF EXISTS test_func1;
CREATE FUNCTION test_func1() RETURNS INT
BEGIN
RETURN (SELECT MAX(f1) FROM t1);
END //
PREPARE s1 FROM  'SELECT test_func1() FROM t1 LIMIT 1';
EXECUTE s1;
test_func1()
1
CREATE PROCEDURE test_proc10() SELECT 238;
DROP   PROCEDURE test_proc10;
EXECUTE s1;
ERROR 42000: FUNCTION test.test_func1 does not exist
CREATE PROCEDURE test_proc10() SELECT 238;
DROP   PROCEDURE test_proc10;
EXECUTE s1;
ERROR 42000: FUNCTION test.test_func1 does not exist
PREPARE s1 FROM  'SELECT test_func1() FROM t1 LIMIT 1';
EXECUTE s1;
test_func1()
1
CREATE FUNCTION test_func10() RETURNS INT RETURN 5;
DROP   FUNCTION test_func10;
EXECUTE s1;
ERROR 42000: FUNCTION test.test_func1 does not exist
CREATE FUNCTION test_func10() RETURNS INT RETURN 5;
DROP   FUNCTION test_func10;
EXECUTE s1;
ERROR 42000: FUNCTION test.test_func1 does not exist
PREPARE s1 FROM  'SELECT test_func1() FROM t1 LIMIT 1';
EXECUTE s1;
test_func1()
1
CREATE VIEW v0 AS SELECT * FROM t0;
DROP VIEW v0;
EXECUTE s1;
ERROR 42000: FUNCTION test.test_func1 does not exist
CREATE VIEW v0 AS SELECT * FROM t0;
DROP VIEW v0;
EXECUTE s1;
ERROR 42000: FUNCTION test.test_func1 does not exist