Bug #10806 Garbage (?) value for "Max_data_length"
Submitted: 23 May 2005 17:25 Modified: 28 Feb 2007 22:24
Reporter: Joerg Bruehe Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:5.0.6 OS:IBM AIX (AIX 5.2)
Assigned to: CPU Architecture:Any

[23 May 2005 17:25] Joerg Bruehe
Description:
Build of 5.0.6, based on ChangeSet
  1.1889 05/05/21 23:23:39 kent@mysql.com +5 -0
  default_modify.c:
    Use MY_STAT to declare argument to my_fstat()
  des_key_file.cc:
    Use local seach path for "mysql_priv.h"
  mysys.dsp, libmysqld.dsp, libmysql.dsp:
    New file needed, "../mysys/default_modify.c"

On AIX 5.2, the table status output differs from the reference protocol, in both the default and "--ps-protocol" run, this error is specific to AIX 5.2:

-------------------------------------------------------
*** r/ps_1general.result        Sun May 22 02:05:15 2005
--- r/ps_1general.reject        Mon May 23 00:03:22 2005
***************
*** 290,300 ****
  prepare stmt4 from ' show table status from test like ''t2%'' ';
  execute stmt4;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
! t2    MyISAM  10      Fixed   0       0       0       4222124650659839        1024    0       NULL    #       #       #       latin1_swedish_ci       NULL
  prepare stmt4 from ' show table status from test like ''t9%'' ';
  execute stmt4;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
! t9    MyISAM  10      Dynamic 2       216     432     281474976710655 2048    0       NULL    #       #       #       latin1_swedish_ci       NULL
  prepare stmt4 from ' show status like ''Threads_running'' ';
  execute stmt4;
  Variable_name Value
--- 290,300 ----
  prepare stmt4 from ' show table status from test like ''t2%'' ';
  execute stmt4;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
! t2    MyISAM  10      Fixed   0       0       0       64424509439     1024    0       NULL    #       #       #       latin1_swedish_ci       NULL
  prepare stmt4 from ' show table status from test like ''t9%'' ';
  execute stmt4;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
! t9    MyISAM  10      Dynamic 2       216     432     4294967295      2048    0       NULL    #       #       #       latin1_swedish_ci       NULL
  prepare stmt4 from ' show status like ''Threads_running'' ';
  execute stmt4;
  Variable_name Value
-------------------------------------------------------

How to repeat:
Run the test suite.
[23 May 2005 17:34] Joerg Bruehe
Similar issue in test "view" on the same platform:

-------------------------------------------------------
*** r/view.result       Sun May 22 02:05:17 2005
--- r/view.reject       Mon May 23 00:35:40 2005
***************
*** 149,155 ****
  v6    VIEW
  show table status;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
! t1    MyISAM  10      Fixed   5       9       45      2533274790395903        1024    0       NULL    #       #       NULL    latin1_swedish_ci       NULL
  v1    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    #       #       NULL    NULL    NULL    NULL    view
  v2    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    #       #       NULL    NULL    NULL    NULL    view
  v3    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    #       #       NULL    NULL    NULL    NULL    view
--- 149,155 ----
  v6    VIEW
  show table status;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
! t1    MyISAM  10      Fixed   5       9       45      38654705663     1024    0       NULL    #       #       NULL    latin1_swedish_ci       NULL
  v1    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    #       #       NULL    NULL    NULL    NULL    view
  v2    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    #       #       NULL    NULL    NULL    NULL    view
  v3    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    #       #       NULL    NULL    NULL    NULL    view
-------------------------------------------------------
[9 Jun 2005 18:49] 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/internals/25828