MySQL Bugs: #37110: ndb_use_exact_count default setting is contradictory in documentation

Bug #37110	ndb_use_exact_count default setting is contradictory in documentation
Submitted:	30 May 2008 22:13	Modified:	24 Jun 2008 10:46
Reporter:	Tim Soderstrom	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.0, 5.1, 6.0	OS:	Any
Assigned to:	Jon Stephens	CPU Architecture:	Any
Tags:	Documentation Default

Description:
The MySQL documentation has a contradiction in regards to the ndb_use_exact_count variable on the following pages:

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-system-variables.html
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-system-variables.html
http://dev.mysql.com/doc/refman/6.0/en/mysql-cluster-system-variables.html

In the table, it says the default is OFF, however the description shows that the default is set to ON:

#

ndb_use_exact_count
Variable Name 	ndb_use_exact_count
Variable Scope 	Both
Dynamic Variable 	Yes
Value Set 	
Type 	boolean
Default 	OFF  <--- This should be ON according to the description

Forces NDB to use a count of records during SELECT COUNT(*) query planning to speed up this type of query. ********The default value is ON********. For faster queries overall, disable this feature by setting the value of ndb_use_exact_count to OFF.
#

How to repeat:
N/A

Suggested fix:
Pick either OFF or ON. Using both implies some sort of crazy Quantum Mechanical principles that I was unaware MySQL had to begin with :)

Thank you for the report.

Verified as described.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.