Victoria Reznichenko writes:
> Hi!
>
> Indeed I could repeat it :(
>
> In addition, MySQL crushes if the table is not empty. Subscriber
> provide ALTER TABLE .. with a column name that already exists.
>
> So I modify test case a little to:
>
> CREATE TABLE `users` (
> `ID` int(10) unsigned NOT NULL auto_increment,
> `FullName` char(50) NOT NULL default '',
> `UserName` char(50) NOT NULL default '',
> `Password` char(50) NOT NULL default '',
> `Level` enum('1','2') NOT NULL default '1',
> PRIMARY KEY (`ID`,`UserName`),
> UNIQUE KEY `ID` (`ID`),
> KEY `ID_2` (`ID`)
> ) TYPE=MyISAM;
> Query OK, 0 rows affected (0.01 sec)
>
> INSERT INTO users(ID) VALUES(NULL);
>
> ALTER TABLE `users` ADD `Level1` ENUM('1','2') DEFAULT "1" NOT NULL;
>
> This is a forwarded message
> From: Matt Parlane <[EMAIL PROTECTED]>
> To:
> Date: Tuesday, September 03, 2002, 1:56:12 AM
> Subject: Crash when adding field
>
Thank you for your bug report, but this bug is already fixed in 4.0.4.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
