Bug #58070 analyze table syntax : BDB has disappeared since 5.1 as supported table
Submitted: 9 Nov 2010 8:07 Modified: 9 Nov 2010 12:10
Reporter: Martijn Korse Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: analyze, analyze table, bdb

[9 Nov 2010 8:07] Martijn Korse
Description:
In the 5.0 manual, the page about the ANALYZE TABLE syntax states that it works for BDB tables. However, in the 5.1 and 5.5 manual, BDB is no longer included in the list of possible tables.

How to repeat:
Goto: http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html
Here is says : "This statement works with MyISAM, BDB, and InnoDB tables."

Now goto: http://dev.mysql.com/doc/refman/5.1/en/analyze-table.html
Here is says : "This statement works with MyISAM and InnoDB tables"

Dito for the 5.5 manual. So it seems BDB has disappeared in 5.1

Suggested fix:
If it really is not supported since 5.1 I think this should be mentioned somewhere. And if it still is, then it should be included.
[9 Nov 2010 8:58] Valeriy Kravchuk
5.0 manual clearly states that BDB will not be supported in 5.1, see http://dev.mysql.com/doc/refman/5.0/en/bdb-storage-engine.html. 5.1 manual clearly does NOT mention BDB among supported engines, see http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html.

If you can suggest some 5.1 manual page where you'd prefer to see this additionally documented, please, do. For now I think the fact that BDB is not supported in 5.1 is well known and clearly visible in the manual.
[9 Nov 2010 11:30] Martijn Korse
> If you can suggest some 5.1 manual page where you'd prefer to see this 
> additionally documented, please, do. 

I think i already did that in my bug-report.

What i reported is that this information can not be found in the ANALYZE TABLE pages. 5.0 mentions BDB is supported and in 5.1 it's suddenly missing.

These pages always mention once when a new table is included and from what version. For example:

http://dev.mysql.com/doc/refman/5.1/en/check-table.html
=> Starting with MySQL 5.1.9, CHECK TABLE is also valid for CSV tables

Similarly it should mention in the 5.1 manual that BDB support has been discontinued. Now it is not clear whether the 5.1 manual simply forgot to mention it, or that it is really not supported.
[9 Nov 2010 12:10] Martijn Korse
Ah, my bad. I didn't realize that support for the whole engine had stopped in 5.1
Ignore my last comment