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

select statement with udf is not being profiled

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 5.5(EOL), 10.0(EOL)
    • N/A
    • OTHER
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            gokhan Gokhan Demir
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.