Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8217

select statement with udf is not being profiled

        Details

        • Type: Bug
        • Status: Confirmed
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0, 5.5
        • 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.

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #61328 - SET profiling = 1 does not profile queries with stored functions

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      gokhan Gokhan Demir
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated: