Bug #37728 Partitions: too-long comment causes no warning
Submitted: 29 Jun 2008 20:27 Modified: 5 Aug 2009 16:28
Reporter: Peter Gulutzan
Status: Verified
Category:Server: Partition Severity:S3 (Non-critical)
Version:6.0.6-alpha-debug,5.1 OS:Linux (SUSE 10 | 32-bit)
Assigned to: Mikael Ronstrom Target Version:
Triage: Triaged: D4 (Minor)

[29 Jun 2008 20:27] Peter Gulutzan 
Description:
Supposedly the maximum length of a partition comment is 80.
In fact I can create a table with a partition comment longer than that.
And when I say SHOW CREATE TABLE, I see the long comment.
But when I select information_schema.partitions.partition_comment,
I only see 80 characters.

How to repeat:
create table t (s1 int) partition by list (s1) (partition p1 values in (1) comment
'a12345678901234567890123456789012345678901234567890123456789012345678901234567890!');
show create table t;
select partition_comment from information_schema.partitions where table_name='t';
[30 Jun 2008 12:18] Susanne Ebrecht 
Verified as described
[30 Jun 2008 12:19] Susanne Ebrecht 
Verified by using test from reporter and MySQL 6.0-bzr tree from one hour ago.
[7 Jul 2009 17:46] Tomas Ulin 
same in 5.1, updating version info