>Description:
Upgrading from 3.22 to 3.23 with a field having a reserved name
ALTER TABLE barfs and doesn't let me do
ALTER TABLE casualties CHANGE when cas_when DATE NOT NULL;
cos of the reserved word "when".
>How-To-Repeat:
Have a field called "when" in 3.22, upgrade to 3.23
>Fix:
Manually edited the .frm file - didn't feel right
Need something to either do it automatically on upgrade, or a standalone
utility to modify the mysql files directly.
>Submitter-Id: <submitter ID>
>Originator: David Croft
>Organization:
>MySQL support: none
>Synopsis: Reserved words in MySQL update
>Severity: serious
>Priority: medium
>Category: mysql
>Class: change-request
>Release: mysql-3.23.32 (Official MySQL binary)
>Environment:
System: Linux papaya 2.2.18 #3 Sat Feb 10 02:36:04 EST 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 20000220 (Debian GNU/Linux)
Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc'
CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Feb 9 08:38 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 887712 Jan 12 04:59 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 2089420 Jan 12 05:00 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 12 05:00 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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