Bug #21054 myisam_stats_method ignored in my.cnf and cmdline

Description:
The myisam_stats_method variable cannot be set in the my.cnf file or on the commandline.

How to repeat:
mysqld_safe --myisam-stats-method=nulls-equal &
mysqladmin variables | grep myisam_stats_method

kolbe@beluga:~/MySQL/inst/5.0.22> ./bin/mysqld_safe --myisam-stats-method=nulls_equal &

kolbe@beluga:~/MySQL/inst/5.0.22> ./bin/mysqladmin variables | grep myisam_stats
| myisam_stats_method             | nulls_unequal     |

Suggested fix:
This should be repaired in such a way that myisam_stats_method can again be set in the my.cnf file or as a command line option to mysqld.

Calvin, Ingo:

I'm stealing this one.  Trivial fix included in bug.

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/11502

ChangeSet@1.2539, 2006-09-07 00:11:43+02:00, tsmith@maint1.mysql.com +1 -0
  Bug #21054: myisam_stats_method ignored in my.cnf and cmdline
  Fix OPT_MYISAM_STATS_METHOD case, where the NULLS_EQUAL and NULLS_NOT_EQUAL methods were mixed up

A typo (actuall, mixed up two identifiers) in option handling in mysqld caused the myisam_stats_method to be handled incorrectly - you'd ask for "nulls_equal" and get "nulls_unequal", and vice versa.

Patch pushed to mysql-5.0-release.  Will be in 5.0.25.

Docs team: please set back to "Patch queued" after documenting for 5.0.

Patch queued to -maint team trees (4.1, 5.0 and 5.1).

Noted in 5.0.25 changelog.

The myisam_stats_method variable was mishandled when set from an option file or on the command line.

Report set back to Patch Queued pending merge into 4.1, 5.1.

Pushed to 5.1.12 and 4.1.22.

Noted in 4.1.22, 5.1.12 changelogs.

Available in 4.1.22.