Details
-
Type:
Bug
-
Status: Confirmed (View Workflow)
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 5.5, 10.0
-
Fix Version/s: 10.0
-
Component/s: Admin statements
-
Environment:CentOS 6.6
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.