Bug #23037 Bug in field "Default" of query "SHOW COLUMNS FROM table"

Description:
Values of column "Default" for varchar fields are cropped by length in results of query "SHOW COLUMNS FROM tablename"

How to repeat:
USE test;
CREATE TABLE  `t` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `field_problem` varchar(500) default 'very long default value1.very long default value2.very long default value3.very long default value4.',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

SHOW COLUMNS FROM `t`;

Thank you for the report.

Verified as described on Linux using last BK sources. Version 4.1 is not affected.

Why Linux? I wrote "Windows XP SP2".

Version and OS Linux were added because that was a version and platfrom where Sveta verified it, I suppose. We have to re-verify all bugs reported on non-Linux platform also on Linux, to check if the bug is really OS-specific. We also have to re-verify on latest code, as the bug, if any, will be fixed not in 5.0.24a, already released, but in the current code.

Anyway, I hope, OS and version fields look OK for you now.

excuse me for my misunderstanding
Thank you.

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/14053

ChangeSet@1.2297, 2006-10-20 14:18:20+02:00, andrey@example.com +3 -0
  Fix for bug#23037 Bug in field "Default" of query "SHOW COLUMNS FROM table"
  
  To the documentor: The DEFAULT value in SHOW COLUMNS/SELECT FROM I_S.COLUMNS
  was truncated to NAME_LEN (which effectively is 64) characters.

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/14079

ChangeSet@1.2297, 2006-10-20 17:49:43+02:00, andrey@example.com +3 -0
  Fix for bug#23037 Bug in field "Default" of query "SHOW COLUMNS FROM table"
    
  To the documentor: The DEFAULT value in SHOW COLUMNS/SELECT FROM I_S.COLUMNS
  was truncated to NAME_LEN (which effectively is 64) characters.

5.0 mysqltest has the "replace_regex" command also.  There's no need to wait for 5.1 .

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/14167

ChangeSet@1.2297, 2006-10-23 13:12:30+02:00, andrey@example.com +3 -0
  Fix for bug#23037 Bug in field "Default" of query "SHOW COLUMNS FROM table"
    
  To the documentor: The DEFAULT value in SHOW COLUMNS/SELECT FROM I_S.COLUMNS
  was truncated to NAME_LEN (which effectively is 64) characters.

Approved

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/14287

ChangeSet@1.2334, 2006-10-24 19:16:18+02:00, msvensson@neptunus.(none) +1 -0
  Bug#23037 Bug in field "Default" of query "SHOW COLUMNS FROM table"
   - Fix check in mysql_client_test to reflect the change of datatype
     for DEFAULT column

Noted in 5.0.30 (not 5.0.29), 5.1.13 changelogs.