>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