Bug #41465 confusing error message when comment is too long
Submitted: 15 Dec 2008 11:14 Modified: 18 Mar 15:56
Reporter: Susanne Ebrecht
Status: Closed
Category:Server: DDL Severity:S3 (Non-critical)
Version:5.0, 5.1 OS:Microsoft Windows
Assigned to: Davi Arnaut Target Version:5.1+
Triage: Triaged: D4 (Minor)

[15 Dec 2008 11: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 10: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 12: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 12: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 13: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 13: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 13:25] Davi Arnaut 
Queued to 5.1-bugteam
[9 Mar 9: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 20: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 3: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 14: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 15:56] Paul DuBois 
Noted in 6.0.11 changelog.
[9 May 18: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 19: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 20: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)