List:Bugs« Previous MessageNext Message »
From:Jan Dvorak Date:April 28 2000 11:13am
Subject:Apostrophes and quotes within a comment confuse the mysql client
View as plain text  
Hi!

This is not a big issue,
but it should be corrected one day.

Jan

>Description:

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

>How-To-Repeat:

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

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

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

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

So the quote misbehaves similarly.

>Fix:

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

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

>Submitter-Id:	jan.dvorak@stripped
>Originator:	Jan Dvorak
>Organization:
MathAn Praha, Ltd., CZ.
>MySQL support: none
>Synopsis:	Apostrophes and quotes within a comment confuse the mysql client
>Severity:	non-critical
>Priority:	medium
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.23.12c-alpha (Source distribution)
>Server: /usr/bin/mysqladmin  Ver 8.0 Distrib 3.23.12c-alpha, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty

Server version		3.23.12c-alpha-log
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/lib/mysql/mysql.sock
Uptime:			1 day 1 hour 32 min 33 sec

Threads: 3  Questions: 545  Slow queries: 25  Opens: 343  Flush tables: 1  Open tables: 8
>Environment:
System: Linux medved.mathan.cz 2.2.13 #2 SMP Thu Dec 16 09:47:45 CET 1999 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root     root           13 Jun  9  1999 /lib/libc.so.6 -> libc-2.1.1.so
-rwxr-xr-x   1 root     root      4016683 Apr 17  1999 /lib/libc-2.1.1.so
-rw-r--r--   1 root     root     19533408 Apr 17  1999 /usr/lib/libc.a
-rw-r--r--   1 root     root          178 Apr 17  1999 /usr/lib/libc.so
Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
--mandir=/usr/man --with-charset=czech
Perl: This is perl, version 5.005_03 built for i386-linux
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