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: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.24a, 5.1-BK | OS: | Windows (Windows XP SP2, Linux) |
Assigned to: | Andrey Hristov | CPU Architecture: | Any |
Tags: | SHOW COLUMN;DEFAULT |
[6 Oct 2006 3:03]
Roman Belikin
[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]
Valeriy 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.