[#MDEV-8217] select statement with udf is not being profiled

[MDEV-8217] select statement with udf is not being profiled Created: 2015-05-23 Updated: 2022-09-12 Resolved: 2022-09-12
Status:	Closed
Project:	MariaDB Server
Component/s:	OTHER
Affects Version/s:	5.5, 10.0
Fix Version/s:	N/A

Type:

Bug

Priority:

Minor

Reporter:

Gokhan Demir

Assignee:

Unassigned

Resolution:

Won't Fix

Votes:

Labels:

profiling, udf, upstream

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.

Comments

Comment by Sergei Golubchik [ 2022-09-12 ]

10.0 was EOLed in March 2019

Generated at Thu Feb 08 07:25:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.