Memory leak when selecting from information_schema.tables in stored procedure (1 reply)

When running the following stored procedure mutliple times, I see memory growth on the mysqld daemon:

DELIMITER //

DROP PROCEDURE IF EXISTS test_information_schema_select;

CREATE PROCEDURE test_information_schema_select

()

BEGIN

SELECT * from information_schema.tables;

END//

DELIMITER ;

I do not see any memory growth by simpy running the query "SELECT * from information_schema.tables;" by itself. Also, I don't see any memory growth when performing SELECT statements in other stored procedures. Basically, any access of test_information_schema.tables within a stored procedure exercises the problem.

When the procedure is dropped and recreated, mysqld seems to free this memory. Also, the memory is freed if I exit from the mysql client.

I don't see any bug reports associated with this.

I've noticed the problem on 5.0.45 (Community) and 5.0.64 (Enterprise).