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
