Re: Cannot insert value in the Temporary Table when accessed from a function via a procedure.

[Bob Field]

I boiled your script down to this:

delimiter //
drop database if exists test1//
create database test1//
use test1//
CREATE PROCEDURE tp () BEGIN
	DROP TABLE IF EXISTS tt; # works without this line
	CREATE TABLE tt (id int); 
	DROP TABLE tt; 
END//
CREATE FUNCTION tf () returns VARCHAR(32) BEGIN 
	call tp(); 
	return null; 
END//
call tp()//	# works
select tf ()//	# doesn't

Basically the DROP TABLE line seems to be causing undesirable behavior. I'm not sure if this is a bug or what. Another odd thing is if the CREATE TABLE statement is commented out, the error changes to "Unknown table".