From d1ad316a59b6bd48dec94433ffe982ddfc376e35 Mon Sep 17 00:00:00 2001 From: Alexander Nozdrin Date: Sat, 20 Feb 2010 13:07:32 +0300 Subject: Patch for WL#3736: Extended Table, Column and Index Comments. The task is to (a) add a comment on indexes and (b) increase the maximum length of column, table and the new index comments. The patch committed on behalf of Yoshinori Matsunobu (Yoshinori.Matsunobu@Sun.COM). --- mysql-test/t/strict.test | 74 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 74 insertions(+) (limited to 'mysql-test/t/strict.test') diff --git a/mysql-test/t/strict.test b/mysql-test/t/strict.test index 5779ea97bc2..d1e136bf5fa 100644 --- a/mysql-test/t/strict.test +++ b/mysql-test/t/strict.test @@ -1166,11 +1166,65 @@ set @@sql_mode='traditional'; --error ER_TOO_LONG_TABLE_COMMENT create table t1 (i int) comment '123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789*123456789*'; --error ER_TOO_LONG_FIELD_COMMENT create table t1 ( i int comment '123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* @@ -1181,6 +1235,26 @@ set @@sql_mode= @org_mode; create table t1 (i int comment '123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* -- cgit v1.2.1