| Bug #46623 | 5.1.31 help gives URLs of 5.0 manual | ||
|---|---|---|---|
| Submitted: | 9 Aug 2009 23:03 | Modified: | 10 Aug 2009 5:07 |
| Reporter: | Chris Hennick | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.1.31-1ubuntu2 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
[10 Aug 2009 5:07]
Sveta Smirnova
Thank you for the report. I download help tables for versiion 5.1 as described in our manual from http://downloads.mysql.com/docs/fill_help_tables-5.1.sql.gz I get: mysql> help drop table; Name: 'DROP TABLE' Description: ... URL: http://dev.mysql.com/doc/refman/5.1/en/drop-table.html So this just looks you use wrong help tables. If you use binaries provided by Ubuntu and these tables are already filled please file a bug in Ubuntu bug tracker.
Description: The output of the HELP command on MySQL Server 5.1.31 contains links to the MySQL 5.0 manual, not the 5.1 manual, online. How to repeat: mysql> help drop table; Name: 'DROP TABLE' Description: Syntax: DROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name] ... [RESTRICT | CASCADE] DROP TABLE removes one or more tables. You must have the DROP privilege for each table. All table data and the table definition are removed, so be careful with this statement! If any of the tables named in the argument list do not exist, MySQL returns an error indicating by name which non-existing tables it was unable to drop, but it also drops all of the tables in the list that do exist. *Important*: When a table is dropped, user privileges on the table are not automatically dropped. See [HELP GRANT]. Use IF EXISTS to prevent an error from occurring for tables that do not exist. A NOTE is generated for each non-existent table when using IF EXISTS. See [HELP SHOW WARNINGS]. RESTRICT and CASCADE are allowed to make porting easier. In MySQL 5.0, they do nothing. *Note*: DROP TABLE automatically commits the current active transaction, unless you use the TEMPORARY keyword. URL: http://dev.mysql.com/doc/refman/5.0/en/drop-table.html Suggested fix: Change 5.0 to 5.1 in all URLs.