Client Option: –Enable-Comments

[Mahesh]

We are executing:

“SHOW CREATE PROCEDURE `dbname.spname”;

Resultset return by server does not show comments in this case.

Can you please provide the details like which MySQL client has this settings(MySQL command-line tool/MySQL QB/MySQL workbench) ?

Thanks,

Mahesh

[peterlaursen]

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.

[albinojones]

'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.

[Author]

Posts