>Description:
The --allow-keywords option has no effect if the server can
use the SHOW CREATE INFO command (it's the other else branch).
All the new code only make use of opt_quoted which is set by
the -Q option and quotes "illegal" table/column names instead of
prepending them with the database name like --allow-keywods would do.
>How-To-Repeat:
"CREATE TABLE `by` (`char` char(30));" and then try to dump it using
--allow-keywords and -Q.
>Fix:
If it is backwards compatible to e.g. version 3.21 which didn't know
the "SHOW CREATE TABLE" command, then make --allow-keywods just an
alias for opt_quoted (-Q).
>Submitter-Id: <submitter ID>
>Originator: Christian Hammers
>Organization:
Debian Project
>MySQL support: none
>Synopsis: mysqldump --allow-keywods has no effect
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.55 (Source distribution)
>Environment:
System: Linux app109 2.4.20-app109-3 #3 Sat Jan 25 14:55:31 CET 2003 i686 unknown
unknown GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.2/specs
Configured with: ../src/configure -v
--enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr
--mandir=/usr/share/man --infodir=/usr/share/info
--with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib
--enable-nls --without-included-gettext --enable-__cxa_atexit --enable-clocale=gnu
--enable-java-gc=boehm --enable-objc-gc i386-linux
Thread model: posix
gcc version 3.2.2 20030124 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 2003-01-23 13:49 /lib/libc.so.6 ->
libc-2.3.1.so
-rwxr-xr-x 1 root root 1102984 2003-01-21 23:15 /lib/libc-2.3.1.so
-rw-r--r-- 1 root root 2337952 2003-01-21 23:15 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 2003-01-21 23:15 /usr/lib/libc.so
-rw-r--r-- 1 root root 716080 2002-01-13 21:06
/usr/lib/libc-client.so.2001
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
--with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile
--with-raid --enable-thread-safe-client --without-readline
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql
--without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all
---------------------------------------------------------------------
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
