Bug #23037 Bug in field "Default" of query "SHOW COLUMNS FROM table"
Submitted: 6 Oct 2006 3:03 Modified: 13 Nov 2006 19:52
Reporter: Roman Belikin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.24a, 5.1-BK OS:Microsoft Windows (Windows XP SP2, Linux)
Assigned to: Andrey Hristov
Tags: SHOW COLUMN;DEFAULT

[6 Oct 2006 3:03] Roman Belikin
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`;
[6 Oct 2006 9:25] Sveta Smirnova
Thank you for the report.

Verified as described on Linux using last BK sources. Version 4.1 is not affected.
[7 Oct 2006 6:42] Roman Belikin
Why Linux? I wrote "Windows XP SP2".
[7 Oct 2006 6:53] Valerii Kravchuk
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.
[7 Oct 2006 10:12] Roman Belikin
excuse me for my misunderstanding
Thank you.
[20 Oct 2006 12:19] 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/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.
[20 Oct 2006 15:51] 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/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.
[20 Oct 2006 18:50] Chad MILLER
5.0 mysqltest has the "replace_regex" command also.  There's no need to wait for 5.1 .
[23 Oct 2006 11:14] 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/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.
[23 Oct 2006 11:44] Magnus BlÄudd
Approved
[24 Oct 2006 17: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/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
[13 Nov 2006 19:52] Paul Dubois
Noted in 5.0.30 (not 5.0.29), 5.1.13 changelogs.