MySQL Bugs: #11226: Dynamic table >4GB issue

Bug #11226	Dynamic table >4GB issue
Submitted:	10 Jun 2005 7:51	Modified:	30 Jun 2005 13:31
Reporter:	Christian Volk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S2 (Serious)
Version:	4.1.12-nt	OS:	Windows (Win XP sp2)
Assigned to:	Jani Tolonen	CPU Architecture:	Any

Description:
serversettings:
myisam_data_pointer_size=8

When we create a dynamic table, the max table size is limited to 4GB.
When we alter the table to static, then there are no limitations to 4GB.
 
In the forum, they told us, that dynamic tables >4GB without the option max_rows are possible.

How to repeat:
set myisam_data_pointer_size=8 

create table with varchar coloumn (to get a dynamic table)
open mysql administrator ->Catalogs/Schemata/Row Status/Max data length

mysql> insert into mydin select * from mydin;
ERROR 1114 (HY000): The table 'mydin' is full
mysql> show variables like "myisam_data_pointer_size";
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| myisam_data_pointer_size | 8     |
+--------------------------+-------+
1 row in set (0.16 sec)

mysql> select version();
+------------+
| version()  |
+------------+
| 4.1.12a-nt |
+------------+
1 row in set (0.06 sec)

mysql> SHOW TABLE STATUS FROM test LIKE 'mydin'\G
*************************** 1. row ***************************
           Name: mydin
         Engine: MyISAM
        Version: 9
     Row_format: Dynamic
           Rows: 16519104
 Avg_row_length: 260
    Data_length: 4294967040
Max_data_length: 4294967295
   Index_length: 1024
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2005-06-28 21:50:09
    Update_time: 2005-06-28 21:57:42
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.24 sec)

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html