>Description: If you create a table with a column name called 'desc' (as the command, that is, without the '') mysql allows to create it, but then you can't query or do any operation with it, always giving an error like: You have an error in your SQL syntax near desc='foo' where nombre='v5'
>How-To-Repeat: create a table with a column called desc, then perform any operation with that column (update, alter, etc.) >Fix: May be not allowing to create a column called that way or allowing it and not giving the error :-) >Submitter-Id: <submitter ID> >Originator: vinko >Organization: >MySQL support: none >Synopsis: calling a column desc prevents executing any command on it >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.41 (Mandrake Linux MySQL RPM) >Environment: System: Linux landsat.cprsig.cl 2.4.8-34.1mdk #1 Mon Nov 19 12:40:39 MST 2001 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/i586-mandrake-linux-gnu/2.96/specs gcc version 2.96 20000731 (Mandrake Linux 8.1 2.96-0.62mdk) Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' CXX='g++' CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 ene 17 21:21 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x 1 root root 1285896 dic 17 22:19 /lib/libc-2.2.4.so -rw-r--r-- 1 root root 27470790 dic 17 21:05 /usr/lib/libc.a -rw-r--r-- 1 root root 178 dic 17 21:05 /usr/lib/libc.so Configure command: ./configure --enable-shared --enable-thread-safe-client --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-berkeley-db --without-innobase '--with-comment=Mandrake Linux MySQL RPM' --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php