Bug #33488 Help tables in mysql database are empty.

• Submitted: 23 Dec 2007 9:44
• Modified: 11 Feb 2008 17:16
• Reporter: Santo Leto
• Status: Can't repeat
• Category: MySQL Server: Packaging
• Severity: S3 (Non-critical)
• Version: 5.0.52
• OS: Windows (XPSP2)
• CPU Architecture: Any
• Tags: help_category, help_keyword, help_relation, help_topic, mysql help tables

[23 Dec 2007 9:44] Santo Leto

Description:
Help tables in mysql database are empty (in 'unzip in C:\' package).

How to repeat:
SELECT CURRENT_USER(), VERSION();
SELECT COUNT(DISTINCT `parent_category_id`) FROM `mysql`.`help_category` ORDER BY `parent_category_id`;
SELECT COUNT(*) FROM `mysql`.`help_keyword`;
SELECT COUNT(*) FROM `mysql`.`help_relation`;
SELECT COUNT(*) FROM `mysql`.`help_topic`;

Output:

mysql> SELECT CURRENT_USER(), VERSION();
+----------------+--------------------------+
| CURRENT_USER() | VERSION()                |
+----------------+--------------------------+
| root@localhost | 5.0.52-enterprise-nt-log |
+----------------+--------------------------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(DISTINCT `parent_category_id`) FROM `mysql`.`help_category` ORDER BY `parent_category_id`;
+--------------------------------------+
| COUNT(DISTINCT `parent_category_id`) |
+--------------------------------------+
|                                    0 |
+--------------------------------------+
1 row in set (0.03 sec)

mysql> SELECT COUNT(*) FROM `mysql`.`help_keyword`;
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(*) FROM `mysql`.`help_relation`;
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(*) FROM `mysql`.`help_topic`;
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

Suggested fix:
MYD Data files are empty (0 KB).

[24 Dec 2007 17:46] Valeriy Kravchuk

Thank you for a bug report. Verified just as described. All help*.MYD files are 0 bytes long in mysql-enterprise-gpl-noinstall-5.0.52-win32.

Yo may copy these tables from other package, but I understand that this workaround may be unaccaptable.

[11 Feb 2008 17:16] Valeriy Kravchuk

Looks like this is already fixed since 5.0.54:

mysql> select version();
+------------------------------+
| version()                    |
+------------------------------+
| 5.0.54-enterprise-gpl-nt-log |
+------------------------------+
1 row in set (0.00 sec)

mysql> select COUNT(*) FROM `mysql`.`help_topic`;
+----------+
| COUNT(*) |
+----------+
|      462 |
+----------+
1 row in set (0.05 sec)