Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Profiler With Stored Function

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Profiler With Stored Function

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • November 30, 2010 at 7:44 pm #31616
      peterlaursen
      Participant

      What is the problem? I am not able to understand!

      Please provide a a complete test case (the stored function, the query you use, tables if they are required to reproduce this etc.).

    • November 30, 2010 at 8:06 pm #31617
      mjdb
      Member

      not a bug sorry. mysql does not profile queries with stored functions

    • November 30, 2010 at 8:19 pm #31618
      peterlaursen
      Participant

      Thanks for the info! 

      But I think we should handle this better in SQLyog if query_id for a query returns = '0'.  We will check what we can do!

    • November 30, 2010 at 8:23 pm #31619
      mjdb
      Member
      'peterlaursen' wrote:

      Thanks for the info! 

      But I think we should handle this better in SQLyog if query_id for a query returns = '0'.  We will check what we can do!

      DELIMITER $$

      USE `mysql`$$

      CREATE DEFINER=`root`@`localhost` FUNCTION `test`() RETURNS CHAR(10) CHARSET latin1

      NOT DETERMINISTIC NO SQL

      BEGIN

      RETURN CURDATE();

      END$$

      DELIMITER ;

      select mysql.test()

      click on profiler tab

      then click on the history tab

    • November 30, 2010 at 9:26 pm #31620
      peterlaursen
      Participant

      added here: http://code.google.com/p/sqlyog/issues/detail?id=1569

      We will discuss the best implementation for such cases.

  • Author
    Posts
Viewing 4 reply threads
  • You must be logged in to reply to this topic.