# ESSENTIALs single session

--disable_warnings
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;
--enable_warnings

CREATE TABLE t0 (f1 BIGINT, f2 BIGINT);
INSERT INTO t0 VALUES(1, 1);
CREATE TABLE t1 AS SELECT * FROM t0;

--disable_abort_on_error

--disable_warnings
DROP FUNCTION IF EXISTS test_func1;
--enable_warnings
delimiter //;
CREATE FUNCTION test_func1() RETURNS INT
BEGIN
RETURN (SELECT MAX(f1) FROM t1);
END //
delimiter ;//

PREPARE s1 FROM  'SELECT test_func1() FROM t1 LIMIT 1';
EXECUTE s1;
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;
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;
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