[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-bugs
Subject:    Re: [BUG] single quote in C comment
From:       "Matt W" <mysql_lists () realplain ! com>
Date:       2004-02-26 0:03:21
Message-ID: 016301c3fbfb$f347adf0$0100a8c0 () pc1
[Download RAW message or body]

Hi,

This is a known issue in the way that the mysql *client* (not the MySQL
server) parses multi-line comments.  It's fixed in 4.1.1 (the client, I
assume, which you could use with any server version), according to the
following page, which also describes the problem:
http://www.mysql.com/doc/en/Comments.html


Hope that helps.


Matt


----- Original Message -----
From: "LiNuCe"
Sent: Wednesday, February 25, 2004 4:54 PM
Subject: [BUG] single quote in C comment


> Hello,
>
> What's my system ?
>
>     $ cat /etc/slackware-version
>     Slackware 9.1.0
>
> What's the MySQL version ?
>
>     $ mysql --version
>     mysql  Ver 12.21 Distrib 4.0.15a, for slackware-linux (i486)
>
> What does contain a starting SQL file not raising the bug ?
>
>     $ cat plop.sql
>     /*
>      * Two single quotes : ''
>      */
>     create table plop ( i int );
>     drop table plop ;
>
> Does the starting SQL file process without problem ? Yes :
>
>     $ mysql -u plop -p plop < plop.sql
>     Enter password:
>
> What does contain the SQL file raising the bug ?
>
>     $ cat plop.sql
>     /*
>      * One single quote : '
>      */
>     create table plop ( i int );
>     drop table plop ;
>
> How does the bug happen ?
>
>     $ mysql -u plop -p plop < plop.sql
>     Enter password:
>     ERROR 1064 at line 1: You have an error in your SQL syntax.  Check
>     the manual that corresponds to your MySQL server version for the
>     right syntax to use near ';
>     drop table plop' at line 4
>
> Sorry for :
>
>   1) my bad english ;
>   2) not having found the bug in the bug database ;
>   3) reporting something that is not a bug (but single quote are used
in
> french language and does not necessary appears in event occurence,
what
> is problem at least in french comments).
>
> I hope I have submitted all needed informations. Have a nice day !



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/bugs?unsub=mysql-bugs@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]