From: Jon Olav Hauglid
Date: February 21 2011 10:34am
Subject: bzr commit into mysql-5.5 branch (jon.hauglid:3350) Bug#11754461
List-Archive: http://lists.mysql.com/commits/131730
X-Bug: 11754461
Message-Id: <201102211035.p1L5V1Ar013813@rcsinet15.oracle.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7720958977918598853=="

--===============7720958977918598853==
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

#At file:///export/home/x/mysql-5.5-bug11754461/ based on revid:sergey.vojtovich@stripped

 3350 Jon Olav Hauglid	2011-02-21
      Bug #11754461 CANNOT ALTER TABLE WHEN KEY PREFIX TOO LONG
      
      The problem was that doing ALTER TABLE on a table which had a key
      on a TEXT/BLOB column with a prefix longer than the minimum number
      of characteres (as per the character set), by mistake caused an error.
      (Error 1170 - ER_BLOB_KEY_WITHOUT_LENGTH).
      
      This bug not repeatable in 5.5.
      
      This patch adds a regression test to alter_table.test and
      contains no code changes.

    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-07-26 09:22:38 +0000
+++ b/mysql-test/r/alter_table.result	2011-02-21 10:34:03 +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 10:34:03 +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;


--===============7720958977918598853==
MIME-Version: 1.0
Content-Type: text/bzr-bundle; charset="us-ascii";
	name="bzr/jon.hauglid@stripped"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

# Bazaar merge directive format 2 (Bazaar 0.90)
# revision_id: jon.hauglid@stripped
# target_branch: file:///export/home/x/mysql-5.5-bug11754461/
# testament_sha1: 80ef3dc4ac9f7d4721b90c7ba30d1501a9e0ed84
# timestamp: 2011-02-21 11:34:05 +0100
# base_revision_id: sergey.vojtovich@stripped\
#   ucxoybax7mqwf209
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWRN0f1wAAoLfgAAQWGf//3/9
3uC////wYAZc+2ygCaxrbNaABoCSkno0k2ao9TJk8mpmo0DQDTamT1DQ0ABzAEYJiAYBME0ZDQwC
YIxMcwBGCYgGATBNGQ0MAmCMTCU0RBT2kyp6aajxR6T0mnqNqANGnpGhk00AcwBGCYgGATBNGQ0M
AmCMTCSRNDQaAEBNGo00U8GoNPUmm0ynoj9SephJ+I7VsoZsulut/l0k9Om2/gvhRTvsi6RwqGwq
eGDemLdRSkoyrJHb/dWZuHDKdAp+A+Y4hC/H2bulUJKikz4OH5zHkrNh6Pke8Y6/A85j7nefovJX
6L9UUDL+MzUmqK7rotQYWz6CLZyrW7RcA1FuRx78D3tm/oIchtY/p+5CTLbFkk04yQEVKJ7C2yXN
s9cqzbG3A+GG9iEwc+5IYeXj3itpPwLP3cYjT0IgGKF/3oHj7UQwHmr+Rz5eKxMtgMKn8dITF5wB
SQMuIMFi0NYPmNxV41ge4Vsh3biCAcyww0BGUEzG8BAdxrJj1GwiYVKITraY4EZvgBJcBlEcVKRa
wd3q/UrP2sSCpby/5TpEwEkfJbqeVMcphr6gsbaw2vJP3wCqHnZSUxCVCOC4eXa6YZpNuCRkSNd7
gnsPQgNU8qSGLfbekbEwQLstNVOQDMobNyMSkyPNiAx00qbW4C7nfsRIATuLrc5yBuwLKcR8GOOe
4Q8K78nOoaWQPKKIA0z1jLgPha09Sm/wrSPKFB3EfAfdyrG53azFNoS5avVYZD5DU1GSzIm892FW
Q/sNqyGL0/EmB4S5da6JXXBkXF45xLOgzquc6kfVSQSeT3EmcT2BYX0sYqgyurnvKAkuyWFEJ7n2
1SeK7DWXxlxzEi+eJwPSZUV1opc7LVqsLLlYsE9HFQeavKJTLHaqcAnqZ5tWxXJTPKvMKCOZs+jQ
VDDkL6NvyKtJzqFBIJVkiJRnquoqFWLMGl0zBCR1jNj+51cdGawKy0gZyAyHxEdzOIELELWVyfAC
mcYcv+C/P+iS+YQzPNOpQx8x/0WUEabAMw5ZirWqZysVoTLBFqyCCyjODKIES8PqtgmqICnLClQM
VWTinAYKi0X1JvtU5Gx90KVqvRJ4iUZdvTS7+QpSZ6VQIsSaPRl7BkQsxWf2UE41XwPdEHH1tQSn
+lwk6V1cSvxJ6ERKj+Pj+5c7kyeJO+x36DMhzFm/x6l2nPNZqn9MmCmjpuY8WJnEU6Zy2ywjLVhc
jKXXg81gMRdebqRgzxUsxHMiqa8od/rIpx0P2Pvvt6sFC7Vi9gVxMfUSuwgsytVRmqLCmmvgcim4
qCcHOeJSEXk5Zq3ctvoeFxHfuLKuzsny8rIUkwxmOTWePOdkq9A76ioRgbjkIhtj3laGMSN27crc
N5YdnZyqZ/sOlgGv2Awx2a3zcZ4sVr7JiMuDYv00NQcM4VRW48NNqNKCBOvkCHgQoxxp1U4aHU9y
4RN/cd53KBiv7Opqc6dHnedxwmZyYYbXuMt7IhOPWJQI6TnbbQT+lLmKT3pvWgY8b7wPWBw9hAtM
ipX8jVFh3mOkTWlPz6w+SHIHTkfUuwTijY0RLrMejj7+nGjmKRLJEeLXzmPHUC4id50P5PwTF+HY
esq1XQzNt/svA5o+C0qAzTA5Gmjw8vA6lwJknAygcQN4i/nwxZPSkW59vKNF8ELYbqpqjjgWnZRP
POvisz2xgQ/8d5MRUGapwlL0FpAnRCA4c9xQ0jtOIFJ2kIqLJzBM5d+k617d5Zm3DlipgD7zW2mC
Bg686Kg2BSReuTlfng9exdhw3Cw4sMDPW90fxMy3ooFLpFs5OcTjai4ueXK67mnJj0veTDAOBTDI
614TJNCPtWPKCgiupUkcJnbjyoKA9BaP7umzWE1mM22sqCiJuyDFjq2RGtDj1SCP4gbjcktbGRgt
VzCZYUWd/IpuOZOLUG2yCfGCjOhKExoQn9OdaTq6mTxwNQXl8wRu54DprUSW9WuoYI67l4fn3MNI
R6TvtXSvN9RQSLywfwKVT4ZKZHvNy8ORXgmHgaVXWrgVgXqQ4W2jOTZnxMUORAiVANYrI5VH/xdy
RThQkBN0f1w=


--===============7720958977918598853==--