Bug #41465 confusing error message when comment is too long
Submitted: 15 Dec 2008 10:14 Modified: 18 Mar 2009 14:56
Reporter: Susanne Ebrecht Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.0, 5.1 OS:Microsoft Windows
Assigned to: Davi Arnaut CPU Architecture:Any
Triage: Triaged: D4 (Minor)

[15 Dec 2008 10:14] Susanne Ebrecht
Description:
Warning for a too long comment is: "Unknown Error". That is confusing. Something more specific like: "Comment too long" would be better.

CREATE TABLE t(
v INTEGER COMMENT 'From out the forest I now appear, to proclaim that Christmas tide is here! For at the top of every tree are golden lights for all to see; and there from Heavens gate on high I saw our Christ-child in the sky. And in among the darkend trees, a loud voice it was called to me: Knecht Ruprecht, old fellow! it cries. Hurry now! Make haste, do not hide! All the candles have now been lit, Heavens gate have open wide!'
);

Query OK, 0 rows affected, 1 warning (0.00 sec)

SHOW warnings;

+---------+------+---------------+
| Level   | Code | Message       |
+---------+------+---------------+
| Warning | 1105 | Unknown error |
+---------+------+---------------+
1 row in set (0.00 sec)

SHOW CREATE TABLE t;

CREATE TABLE `t` (
`v` int(11) DEFAULT NULL COMMENT 'From out the forest I now appear, to proclai
m that Christmas tide is here! For at the top of every tree are golden lights fo
r all to see; and there from Heavens gate on high I saw our Christ-child in the
sky. And in among the darkend trees, a loud voice i'
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Engine doesn't matter here.

How to repeat:
See above

Suggested fix:
Change warning here to: "Comment too long".
[25 Feb 2009 9:03] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/67468
[5 Mar 2009 11:11] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68351
[5 Mar 2009 11:20] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68357
[6 Mar 2009 12:16] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68488
[6 Mar 2009 12:25] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68490
[6 Mar 2009 12:25] Davi Arnaut
Queued to 5.1-bugteam
[9 Mar 2009 8:43] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68591

2837 He Zhenxing	2009-03-09 [merge]
      Auto merge
[13 Mar 2009 19:03] Bugs System
Pushed into 5.1.33 (revid:joro@sun.com-20090313111355-7bsi1hgkvrg8pdds) (version source revid:zhou.li@sun.com-20090311061050-ihp0g77znonq1tuq) (merge vers: 5.1.33) (pib:6)
[15 Mar 2009 2:52] Paul Dubois
Noted in 5.1.33 changelog.

The error message for a too-long column comment was "Unknown error"
rather than a more appropriate message.

Setting report to NDI pending push into 6.0.x.
[18 Mar 2009 13:21] Bugs System
Pushed into 6.0.11-alpha (revid:joro@sun.com-20090318122208-1b5kvg6zeb4hxwp9) (version source revid:matthias.leich@sun.com-20090310140952-gwtoq87wykhji3zi) (merge vers: 6.0.11-alpha) (pib:6)
[18 Mar 2009 14:56] Paul Dubois
Noted in 6.0.11 changelog.
[9 May 2009 16:41] Bugs System
Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)
[9 May 2009 17:38] Bugs System
Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)
[9 May 2009 18:36] Bugs System
Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)