1 2--source include/not_valgrind.inc 3 4--echo # MDEV-20699 do not cache SP in SHOW CREATE 5--echo # Warmup round, this might allocate some memory for session variable 6--echo # and the output 7 8SELECT VARIABLE_VALUE into @global_mem_used FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME='MEMORY_USED'; 9SELECT VARIABLE_VALUE into @local_mem_used FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='MEMORY_USED'; 10CREATE PROCEDURE sp0() SELECT 1; 11SHOW CREATE PROCEDURE sp0; 12DROP PROCEDURE sp0; 13 14#Check that CREATE/SHOW does not use memory in caches. 15SELECT VARIABLE_VALUE into @global_mem_used FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME='MEMORY_USED'; 16SELECT VARIABLE_VALUE into @local_mem_used FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='MEMORY_USED'; 17CREATE PROCEDURE sp1() SELECT 1; 18SHOW CREATE PROCEDURE sp1; 19SELECT VARIABLE_VALUE-@local_mem_used FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='MEMORY_USED'; 20# FIXME: MDEV-26754 main.sp test fails for embedded server 21#SELECT VARIABLE_VALUE-@global_mem_used FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME='MEMORY_USED'; 22DROP PROCEDURE sp1; 23 24--echo # 25--echo # End of 10.3 tests 26--echo # 27