Re: Crash when alter table with enum column collated utf8_unicode_ci

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jeremy,

> There is a crashing bug in 4.1.4 (bk pulled as of July 12) when
> executing ALTER TABLE on a table with an enum column collated with
> utf8_unicode_ci.  It works fine with utf8_general_ci.  This is the case
> for both myisam and innodb tables.  I tested this on a pentium 3 running
> red hat linux 9.  I've included the error log entry at the bottom.
>
> CREATE TABLE t1 (yesno enum ('Y', 'N') DEFAULT 'N' COLLATE
> utf8_unicode_ci);
>
> mysql crashes with alter table:
> ALTER TABLE t1 ADD COLUMN col2 CHAR(20);

I have verified this and will file the bug report so that this is
resolved as soon as possible.  Thank you for the report!

Best regards,
- --
Dean Ellis, Support Engineer & Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFA9ZZsAebV/bGJ5NERAs+/AKCQnii2D6F6tAs1AnyYJTKtMOuXDwCdGWYK
F6L3LoJ5DzpQdGvKw13DAwo=
=nVnV
-----END PGP SIGNATURE-----

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]