<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Is this problem with comments outside queries in a SQL file exclusive to /* Comment */ style comments, or are<br><br>#<br># Comment<br>#<br><br>style comments a problem as well?<br><br>Thanks,<br>Jason<br><br>--- On <b>Tue, 8/23/11, toolserver-l-request@lists.wikimedia.org <i><toolserver-l-request@lists.wikimedia.org></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div class="plainMail"><br>the following message is only interesting for people who uses the MySQL-CLI <br>(the "mysql"-command on the command-line) or the "sql"-script. It doesn't <br>matter if you use php, perl, phyton, java or other languages.<br><br>The problem is that the mysql-cli strips out comments by default (see <br>bugreport [1]). That is bad for us, because it strips all SLOW_OK or LIMIT: <br>too; so if you add a
SLOW_OK at the mysql-cli it will stript out and the <br>query-killer will kill it sooner. To prevent this, I changed the mysql-config <br>in a way that comments will NOT be stripted yesterday [2] .<br><br>In the last hour a user told me, that this has a problematic side-effect: if <br>you use /* foobar */ in a mysql-file OUTSIDE of a query, the file will fail; the <br>user was angry because I changed the default without telling.<br><br>I still think that the mysql-default (to strip comments) is stupid (because in <br>my eyes the user doesn't expect that comments he/she inserts will be removed).<br><br>So here is my plan: I will revert my changes for now (so the mysql-cli will <br>strip comments again). And I hereby announce that I'm going to change the <br>default at wednesday, the 31. August, in a way that comments will NOT the <br>striped out.<br><br>You what that means for you:<br>-If you don't use comments at the mysql-cli: nothing.<br>-If you
use comments at the mysql-cli: You have to add the following lines to <br>,your .my.cnf-file (you can find this hidden file in your home ? please notice <br>the "." at the start):<br><br>--snip--<br>[mysql]<br>comments<br>--snap--<br><br>-If you need the default of the mysql-cli after the 31. August, you have to <br>add the following lines to your .my.cnf:<br><br>--snip--<br>[mysql]<br>skip-comments<br>--snap--<br><br>My revert will not affect the "sql"-script (our recommend way to uise myql on <br>the command-line): It will still not strip the comments.<br><br>Please feel free to discuss this and ask for details on the mailinglist.<br><br>Sincerly,<br>DaB.<br></div></blockquote></td></tr></table>