[MDEV-27399] Missing help items Created: 2022-01-01  Updated: 2022-07-03

Status: Open
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.6.4, 10.7.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Karl Levik Assignee: Ian Gilfillan
Resolution: Unresolved Votes: 0
Labels: None
Environment:

podman pulling from docker.io/library/mariadb:10.6 and quay.io/mariadb-foundation/mariadb-devel:10.7


Issue Links:
PartOf
is part of MDEV-28701 Update server HELP contents Closed

 Description   

MariaDB [(none)]> help contents
You asked for help about help category: "Contents"
For more information, type 'help <item>', where <item> is one of the following
categories:
   Account Management
   Administration
   Compound Statements
   Data Definition
   Data Manipulation
   Data Types
   Functions and Modifiers for Use with GROUP BY
   Functions
   Geographic Features
   Help Metadata
   Language Structure
   Plugins
   Procedures
   Sequences
   Table Maintenance
   Transactions
   User-Defined Functions
   Utility
 
MariaDB [(none)]> help Procedures
 
Nothing found
Please try to run 'help contents' for a list of all accessible topics
 
MariaDB [(none)]> help Language Structure
 
Nothing found
Please try to run 'help contents' for a list of all accessible topics

I assume this affects other versions as well.

Anecdotally, these help items were there in 10.3, but seemed very short / unfinished, so removing them was probably deliberate.

I suppose they must have been deleted from the mysql.help_topic table:

MariaDB [mysql]> SELECT * FROM help_category WHERE help_category_id IN(35, 29, 33);
+------------------+--------------------+--------------------+-----+
| help_category_id | name               | parent_category_id | url |
+------------------+--------------------+--------------------+-----+
|               29 | Language Structure |                 35 |     |
|               33 | Procedures         |                 35 |     |
|               35 | Contents           |                  0 |     |
+------------------+--------------------+--------------------+-----+
3 rows in set (0.005 sec)
 
MariaDB [mysql]> SELECT help_topic_id, name, help_category_id FROM help_topic WHERE help_category_id IN (29, 33);
Empty set (0.002 sec)

"Procedures" could maybe just be made to refer to the procedure-related help topics?

MariaDB [mysql]> SELECT help_topic_id, name, help_category_id FROM help_topic WHERE name LIKE '%procedure%';
+---------------+-----------------------+------------------+
| help_topic_id | name                  | help_category_id |
+---------------+-----------------------+------------------+
|           214 | PROCEDURE ANALYSE     |               17 |
|           431 | PROCEDURE             |               27 |
|           657 | CREATE PROCEDURE      |               39 |
|           362 | SHOW CREATE PROCEDURE |               26 |
|           387 | SHOW PROCEDURE CODE   |               26 |
|           388 | SHOW PROCEDURE STATUS |               26 |
|           645 | ALTER PROCEDURE       |               39 |
|           670 | DROP PROCEDURE        |               39 |
+---------------+-----------------------+------------------+
8 rows in set (0.001 sec)


Generated at Thu Feb 08 09:52:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.