MySQL Bugs: #41465: confusing error message when comment is too long

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:	Windows
Assigned to:	Davi Arnaut	CPU Architecture:	Any

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".

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

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

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

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

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

Queued to 5.1-bugteam

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

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)

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.

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)

Noted in 6.0.11 changelog.

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)

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)

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)