| Bug #20862 | truncated result with show variables like 'innodb_data_file_path' | ||
|---|---|---|---|
| Submitted: | 5 Jul 2006 7:43 | Modified: | 5 Oct 2006 15:07 |
| Reporter: | sebastien lecornet | Email Updates: | |
| Status: | Closed | ||
| Category: | Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.21 | OS: | Linux (Linux) |
| Assigned to: | Sergey Gluhov | Target Version: | |
[5 Jul 2006 12:26]
Sveta Smirnova
Thank you for the report. Verified as reporter described.
[29 Aug 2006 11:45]
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/10997 ChangeSet@1.2253, 2006-08-29 17:02:33+05:00, gluh@mysql.com +1 -0 Bug#20862 truncated result with show variables like 'innodb_data_file_path' The size of 'value' field is increased to FN_REFLEN
[11 Sep 2006 10:26]
Alexander Barkov
The patch looks ok to push.
[11 Sep 2006 12: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/11689 ChangeSet@1.2264, 2006-09-11 17:27:35+05:00, gluh@mysql.com +1 -0 Bug#20862 truncated result with show variables like 'innodb_data_file_path' The size of 'value' field is increased to FN_REFLEN
[5 Oct 2006 10:58]
Sergey Gluhov
Fixed in 5.0.27
[5 Oct 2006 15:07]
Paul DuBois
Noted in 5.0.27 changelog. SHOW VARIABLES truncated the Value field to 256 characters.
[25 Oct 2006 16:44]
Paul DuBois
The 5.0.x fix is in 5.0.30.
Description: [6] XXXXX:mysql> grep innodb_data /etc/my.cnf innodb_data_home_dir = /mysql/ZZZZZZZ/DATA innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:4000M;ibdata8:4000M;ibdata9:4000M;ibdata10:4000M;ibdata11:4000M;ibdata12:4000M;ibdata13:4000M;ibdata14:4000M;ibdata15:4000M;ibdata16:4000M;ibdata17:4000M;ibdata18:4000M;ibdata19:4000M;ibdata20:4000M;ibdata21:4000M; mysql> show variables like 'innodb_data_file_path'; +-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | innodb_data_file_path | ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:4000M;ibdata8:4000M;ibdata9:4000M;ibdata10:4000M;ibdata11:4000M;ibdata12:4000M;ibdata13:4000M;ibdata14:4000M;ibdata15:4000M;ibdata16:4000M;ibdata17:4000M;ibdata18: | +-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) the result (Value) is truncated with 256 character. How to repeat: Add in my.cnf a innodb_data_file_path greater than 256 character and execute a show variables like 'innodb_data_file_path';