Details
Description
any select statement that includes a udf is not being placed into the information_schema.PROFILING table.
To reproduce, I prepared a simple test case:
delimiter //
|
CREATE FUNCTION simple_udf() RETURNS varchar(255) CHARSET utf8 DETERMINISTIC |
BEGIN
|
RETURN 'simple_udf()'; |
END
|
//
|
 |
show profiles;
|
set profiling=1; |
select simple_udf(); |
show profiles;
|
set profiling=0; |
So, the select statement is not being reported by 'show profiles' command.