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 Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.21 OS:Linux (Linux)
Assigned to: Sergey Glukhov

[5 Jul 2006 7:43] sebastien lecornet
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';
[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 Glukhov
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.