diff options
| author | Alexander Nozdrin <alik@sun.com> | 2010-02-20 13:07:32 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2010-02-20 13:07:32 +0300 |
| commit | d1ad316a59b6bd48dec94433ffe982ddfc376e35 (patch) | |
| tree | c7e57caf2dddf80f1b45617e4a1bac400e4e880a /mysql-test/r/strict.result | |
| parent | f027e4e00f0c4ecef89b635ae2ab1e48eb076bff (diff) | |
| download | mariadb-git-d1ad316a59b6bd48dec94433ffe982ddfc376e35.tar.gz | |
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).
Diffstat (limited to 'mysql-test/r/strict.result')
| -rw-r--r-- | mysql-test/r/strict.result | 98 |
1 files changed, 95 insertions, 3 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result index bdb7576f95e..fa4096cb424 100644 --- a/mysql-test/r/strict.result +++ b/mysql-test/r/strict.result @@ -1304,8 +1304,42 @@ set @@sql_mode= @org_mode; set @@sql_mode='traditional'; 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 HY000: Comment for table 't1' is too long (max = 60) +ERROR HY000: Comment for table 't1' is too long (max = 2048) create table t1 ( i int comment '123456789*123456789*123456789*123456789* @@ -1314,8 +1348,28 @@ 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*'); -ERROR HY000: Comment for field 'i' is too long (max = 255) +ERROR HY000: Comment for field 'i' is too long (max = 1024) set @@sql_mode= @org_mode; create table t1 (i int comment @@ -1325,9 +1379,29 @@ create table t1 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789*'); Warnings: -Warning 1629 Comment for field 'i' is too long (max = 255) +Warning 1629 Comment for field 'i' is too long (max = 1024) select column_name, column_comment from information_schema.columns where table_schema = 'test' and table_name = 't1'; column_name column_comment @@ -1337,6 +1411,24 @@ i 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*123456789* + 123456789*123456789*123456789*12345 drop table t1; set names utf8; create table t1 (i int) |