>Description:
When attempting to modify a column from varchar(40) to char(40) the command
returns successfully, however the table is unaltered
>How-To-Repeat:
(prepare a table table_name with a column column_name varchar(40)
alter table table_name modify column_name char(40) NOT NULL default '';
describe table_name
>Fix:
alternative right now is to drop the table and recreate it
>Submitter-Id:
>Originator:
>Organization:
IMCB, Singapore
>MySQL support: none
>Synopsis: altering table structure from varchar to char
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.36 (Source distribution)
>Environment:
Compaq alpha ES40
System: OSF1 scooby.fugu-sg.org V5.1 732 alpha
Machine: alpha
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-dec-osf5.1/2.9-gnupro-99r1/specs
gcc version 2.9-gnupro-99r1
Compilation info: CC='/usr/bin/cc' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline
speed -speculate all -arch host' CXX='/usr/bin/cxx' CXXFLAGS='-O4 -ansi_alias
-ansi_args -fast -inline speed -speculate all -arch host' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root system 17 Nov 8 16:51 /lib/libc.a -> ../ccs/lib/libc.a
lrwxrwxrwx 1 root system 17 Nov 8 16:51 /usr/lib/libc.a ->
../ccs/lib/libc.a
Configure command: ./configure --prefix=/usr/local/mysql --with-low-memory
--enable-large-files --enable-shared=yes '--with-named-thread-libs=-lpthread -lmach
-lexc -lc'
---------------------------------------------------------------------
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
