Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27399

Missing help items

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.6.4, 10.7.2
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      podman pulling from docker.io/library/mariadb:10.6 and quay.io/mariadb-foundation/mariadb-devel:10.7

      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)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              greenman Ian Gilfillan
              Reporter:
              karll Karl Levik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.