Bug #6993 Max myisam_data_pointer_size limited to 7
Submitted: 3 Dec 2004 16:06 Modified: 20 Jul 2005 2:50
Reporter: Dean Ellis Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.8 OS:
Assigned to: Ramil Kalimullin CPU Architecture:Any

[3 Dec 2004 16:06] Dean Ellis
Description:
myisam_data_pointer_size is restricted to 7.

How to repeat:
SET GLOBAL MYISAM_DATA_POINTER_SIZE=8;
SHOW VARIABLES LIKE 'MYISAM_DATA_POINTER_SIZE';

Suggested fix:
===== mysqld.cc 1.531 vs edited =====
--- 1.531/sql/mysqld.cc 2004-12-02 04:39:25 -06:00
+++ edited/mysqld.cc    2004-12-03 10:02:18 -06:00
@@ -5004,7 +5004,7 @@
    "Default pointer size to be used for MyISAM tables.",
    (gptr*) &myisam_data_pointer_size,
    (gptr*) &myisam_data_pointer_size, 0, GET_ULONG, REQUIRED_ARG,
-   4, 2, 7, 0, 1, 0},
+   4, 2, 8, 0, 1, 0},
   {"myisam_max_extra_sort_file_size", OPT_MYISAM_MAX_EXTRA_SORT_FILE_SIZE,
    "Used to help MySQL to decide when to use the slow but safe key cache index create method.",
    (gptr*) &global_system_variables.myisam_max_extra_sort_file_size,
[7 Dec 2004 14:49] Ramil Kalimullin
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

Additional info:

fixed in 4.1.8
[30 Jun 2005 13:26] 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/26555
[16 Jul 2005 20:33] Sergei Golubchik
This bugfix was reverted. The manual should reflect it.
See the referenced patch for the explanation
[20 Jul 2005 2:50] Paul DuBois
I've updated the various sections that refer to
myisam_data_pointer_size.