Hi! On Jan 24, Gelu Gogancea wrote: > Hi, > I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on > 2003-01-22. > Table schema : > CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser > CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish > SMALLINT(1),DataIntro DATE,DataIese > DATE,INDEX(Dep),INDEX(FactExt),INDEX(IDCLI),INDEX(mUser),INDEX(LivrFinish),I > NDEX(DataIntro),INDEX(DataIese)); > > I wish to alter this table and modify the definition of IDCMD to "IDCMD > INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 30000" > For this i do : > alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY > KEY DEFAULT 30000;
No crash for me on a recent bk tree (Jan 24, that is). Try a fresh pull. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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