Bug #23993 Warning with unknown error on table creation with comments larger than 60 chars.

• Submitted: 6 Nov 2006 0:10
• Modified: 13 May 2009 8:49
• Reporter: Gökhan Demir
• Status: Duplicate
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.0.27/5.1BK
• OS: Linux (linux)
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: 1105, comment, CREATE TABLE, unknown error

[6 Nov 2006 0:10] Gökhan Demir

Description:
if the create table command contains a comment larger than 60 characters, then the server reports 1 warning. Show warnings reports a 1105 - unknown error.

How to repeat:
create table test (a int, primary key (a))
   comment="this comment is longer than 60 characters long and will cause an unknown error on mysql 5.0.27. thanks"
   engine = InnoDB ;

Suggested fix:
shorten comments on table creation to not exceed 60 characters.

[6 Nov 2006 13:08] MySQL Verification Team

Thank you for the bug report. Verified as described.

[13 May 2009 8:49] Magne Mæhre

This bug was duplicated by bug #41465 , which is fixed.

Note that the maximum comment length has been increased to 2048 in MySQL 5.2.4 and later versions.