peterlaursen wrote on May 11 2006, 10:54 AM:
I think I found a related issue!
This:
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`yyyyyyyyyy`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `yyyyyyyyyy`(a char)
BEGIN
set @test = a;
END$$
DELIMITER ;$$
creates the procedure. However it does not work with autocomplete UNLESS I MANUALLY REBUILD TAGS.
@shoyu: could I ask you to try 'rebuild tags' from 'powertools menu?
.. however it does not hang here (with that SP definition)
Reproduced.
This happens because for all queries executed from the Query Editor, SQLyog looks for CREATE/ALTER/DROP TABLE, CREATE/ALTER/DROP VIEW etc. to rebuild its Autocomplete cache internally. In the above case the statement starts as CREATE DEFINER and not CREATE PROCEDURE, thus it fails to rebuild the cache. Doing Powertools -> Rebuild Tags… forces SQLyog to rebuild all tags and thus it works.
BTW, which version of MySQL are you using?
CREATE DEFINER=`root`@`localhost` PROCEDURE `my`.`yyyyyyyyyy` ()
does not work with 5.1.6-alpha-nt-max but
CREATE PROCEDURE `my`.`yyyyyyyyyy` ()
does.
