Bug #8790 Test 'information_schema': 'Max_data_length' shows 10 * (2 giga - 1) + 9
Submitted: 24 Feb 2005 18:15 Modified: 17 Mar 2005 13:33
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.3-pre OS:Other (QNX)
Assigned to: Sergei Glukhov CPU Architecture:Any

[24 Feb 2005 18:15] Joerg Bruehe 
Description:
Build based on changeset
  1.1840.1.1 05/02/24 12:17:59 ramil@mysql.com +1 -0
  A fix (mysql_priv.h should be included first)

In a 'debug' build on host 'buildqnx', test 'information_schema' shows this:
-------------------------------------------------------
*** r/information_schema.result Thu Feb 24 11:40:20 2005
--- r/information_schema.reject Thu Feb 24 16:02:14 2005
***************
*** 117,124 ****
  t3
  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
! t2    MyISAM  9       Fixed   0       0       0       21474836479     1024    0       NULL    #       #       NULL    latin1_swedish_ci       NULL
! t3    MyISAM  9       Fixed   0       0       0       21474836479     1024    0       NULL    #       #       NULL    latin1_swedish_ci       NULL
  v1    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    #       #       NULL    NULL    NULL    NULL    view
  show full columns from t3 like "a%";
  Field Type    Collation       Null    Key     Default Extra   Privileges      Comment
--- 117,124 ----
  t3
  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
! t2    MyISAM  9       Fixed   0       0       0       2147483647      1024    0       NULL    #       #       NULL    latin1_swedish_ci       NULL
! t3    MyISAM  9       Fixed   0       0       0       2147483647      1024    0       NULL    #       #       NULL    latin1_swedish_ci       NULL
  v1    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    #       #       NULL    NULL    NULL    NULL    view
  show full columns from t3 like "a%";
  Field Type    Collation       Null    Key     Default Extra   Privileges      Comment
-------------------------------------------------------

How to repeat:
Build + test.
[3 Mar 2005 15:09] Joerg Bruehe 
In a later build based on ChangeSet
  1.1777 05/03/02 08:04:26 patg@krsna.patg.net +1 -0
  Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.0
  into krsna.patg.net:/home/patg/mysql-5.0

the same happens for both 'standard' and 'max' in test 'view'.
('debug' was not built then.)
[15 Mar 2005 16:53] 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/23045
[17 Mar 2005 13:33] Sergei Glukhov 
Fixed in 5.0.3