From: Sergei Golubchik
Date: February 26 2004 12:03am
Subject: Re: [BUG] single quote in C comment
List-Archive: http://lists.mysql.com/bugs/15253
Message-Id: <20040226000357.GB99221@serg.mylan>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi!

Thanks!
It is a known bug - see http://bugs.mysql.com/bug.php?id=539

Unfortunately it was found in 4.1.0 and fixed there.

I'm backporting it to 4.0.19.

As a workaround you can use mysql client from 4.1.1 with your 4.0.15a
server.

On Feb 25, LiNuCe wrote:
> 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 !
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com