[BUG] single quote in C comment

LiNuCe <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
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/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.