Bug #96238 innodb_sys_tables referenced in 8.0 documentation, but does not exist
Submitted: 17 Jul 2019 20:35 Modified: 18 Jul 2019 20:14
Reporter: John Krieger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:MySQL 8.0 OS:Any
Assigned to: CPU Architecture:Any

[17 Jul 2019 20:35] John Krieger 
Description:
Query in Point 8 on the following page references innodb_sys_tables:

https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html

When attempting to execute the query, one receives the error:

Unknown table 'INNODB_SYS_TABLES' in information_schema

The innodb_sys_tables is also missing from the following page:

https://dev.mysql.com/doc/refman/8.0/en/innodb-i_s-tables.html

The innodb_sys_tables was present in 5.7 documentation.

https://dev.mysql.com/doc/refman/5.7/en/innodb-i_s-tables.html

How to repeat:
Follow above referenced links.

Suggested fix:
Correct the documentation.
[18 Jul 2019 4:19] MySQL Verification Team 
Hello John,

Thank you for the report and feedback.

regards,
Umesh
[18 Jul 2019 20:14] Daniel Price 
Posted by developer:
 
The query should reference INFORMATION_SCHEMA.INNODB_TABLES if upgrading from an earlier 8.0 release. The referenced documentation has been updated. Changes should appear online soon.

Thank you for the bug report.