[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=gcdmb-bugs@m.gmane.org

Re: [BUG] single quote in C comment

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=gcdmb-bugs@m.gmane.org

Re: [BUG] single quote in C comment

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
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org