'peterlaursen' wrote on '24:
If I execute
Code:
DELIMITER $$
CREATE PROCEDURE `test`.`sp1`()
BEGIN
— do nothing at all
END$$
DELIMITER ;
and next
Code:
SHOW CREATE PROCEDURE sp1;
I do get
Code:
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp1`()
BEGIN
— do nothing at all
END
.. returned, what means that the comment is stored in the database . Also all 'mysql' client command line parameters do not apply to the C-API (SQLyog does not use the 'mysql' client). Please explain the problem so that we can understand. And also tell the server version. Early 5.0 servers had lots of bugs in this respect.
Upon executing the same commands as you have above, I also see comments being retained. Comments not being retained was an issue I experienced in the past which caused me to avoid executing procedure creation via SQLyog… but now that I've tried again, I see I'm not experiencing the issue, so it couldn't be something related to SQLyog. If I run into this again, I will definitely note the server version.
But for now… nevermind.
