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/t/strict.test | |
| 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/t/strict.test')
| -rw-r--r-- | mysql-test/t/strict.test | 74 |
1 files changed, 74 insertions, 0 deletions
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,6 +1166,40 @@ 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 ( @@ -1176,6 +1210,26 @@ 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*'); set @@sql_mode= @org_mode; create table t1 @@ -1186,6 +1240,26 @@ 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*'); select column_name, column_comment from information_schema.columns where |