List:Bugs« Previous MessageNext Message »
From:Michael Widenius Date:April 28 2000 1:14pm
Subject:Apostrophes and quotes within a comment confuse the mysql client
View as plain text  
Hi!

>>>>> "Jan" == Jan Dvorak <jan.dvorak@stripped> writes:

Jan> Hi!
Jan> This is not a big issue,
Jan> but it should be corrected one day.

Jan> Jan

>> Description:

Jan> The mysql client thinks that quotes and apostrophes
Jan> within comments delimit a string literal,
Jan> but that is not necessarily true.

>> How-To-Repeat:

mysql> /* Let us see - this is o.k. */
-> select version();
Jan> +--------------------+
Jan> | version()          |
Jan> +--------------------+
Jan> | 3.23.12c-alpha-log |
Jan> +--------------------+
Jan> 1 row in set (0.04 sec)

mysql> 
mysql> /* Let's see - this will fail */
Jan>     '> select version();
Jan>     '> 

Jan> The apostrophe in the comment is not ignored.
Jan> Instead, the client thinks we're within a string literal.

mysql> /* My 19" monitor is a nice one - this will also fail */
Jan>     "> select version();
Jan>     ">

Jan> So the quote misbehaves similarly.

>> Fix:

Jan> Reverse the priorities:
Jan> First handle comments, then literal string delimiters.
Jan> However, the current behavior is o.k. for the /*!version sql_chunk */ .

Jan> (I currently don't have the time to look at it myself, sorry.)

The problem is that the mysql client doesn't yet support comments with
/* */ ;  I have now put this on Jani's todo so this should be solved shortly.

Regards,
Monty
Thread
Apostrophes and quotes within a comment confuse the mysql clientJan Dvorak28 Apr
  • Apostrophes and quotes within a comment confuse the mysql clientMichael Widenius28 Apr