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

select statement with udf is not being profiled

    XMLWordPrintable

    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.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:

                Git Integration