From: Jon Olav Hauglid Date: February 21 2011 11:34am Subject: bzr commit into mysql-trunk branch (jon.hauglid:3688) List-Archive: http://lists.mysql.com/commits/131736 Message-Id: <201102211135.p1KMeLqY013883@rcsinet13.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit #At file:///export/home/x/mysql-trunk-test/ based on revid:jorgen.loland@stripped 3688 Jon Olav Hauglid 2011-02-21 [merge] Merge from mysql-5.5 to mysql-trunk No conflicts modified: mysql-test/r/alter_table.result mysql-test/t/alter_table.test === modified file 'mysql-test/r/alter_table.result' --- a/mysql-test/r/alter_table.result 2010-08-30 06:38:09 +0000 +++ b/mysql-test/r/alter_table.result 2011-02-21 11:34:23 +0000 @@ -1383,3 +1383,11 @@ ALTER TABLE t1 CHANGE a id INT; affected rows: 0 info: Records: 0 Duplicates: 0 Warnings: 0 DROP TABLE t1; +# +# Bug#11754461 CANNOT ALTER TABLE WHEN KEY PREFIX TOO LONG +# +DROP DATABASE IF EXISTS db1; +CREATE DATABASE db1 CHARACTER SET utf8; +CREATE TABLE db1.t1 (bar TINYTEXT, KEY (bar(100))); +ALTER TABLE db1.t1 ADD baz INT; +DROP DATABASE db1; === modified file 'mysql-test/t/alter_table.test' --- a/mysql-test/t/alter_table.test 2010-07-26 09:22:38 +0000 +++ b/mysql-test/t/alter_table.test 2011-02-21 11:30:08 +0000 @@ -1144,3 +1144,18 @@ INSERT INTO t1 VALUES (1, 1), (2, 2); ALTER TABLE t1 CHANGE a id INT; --disable_info DROP TABLE t1; + + +--echo # +--echo # Bug#11754461 CANNOT ALTER TABLE WHEN KEY PREFIX TOO LONG +--echo # + +--disable_warnings +DROP DATABASE IF EXISTS db1; +--enable_warnings + +CREATE DATABASE db1 CHARACTER SET utf8; +CREATE TABLE db1.t1 (bar TINYTEXT, KEY (bar(100))); +ALTER TABLE db1.t1 ADD baz INT; + +DROP DATABASE db1; No bundle (reason: revision is a merge (you can force generation of a bundle with env var BZR_FORCE_BUNDLE=1)).