Bug #86138 mysql cmdline client does not understand help create schema

• Submitted: 28 Apr 2017 21:13
• Modified: 28 Apr 2017 21:34
• Reporter: Peter Brawley (Basic Quality Contributor)
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.7
• OS: Any
• CPU Architecture: Any

[28 Apr 2017 21:13] Peter Brawley

Description:
cmdline client responds to ...

help create schema

... with "Nothing found", user needs to write ...

help create database

suggesting the help engine is too stupid to understand basic keyword synonyms, thus giving a poor impression.

How to repeat:
As above

Suggested fix:
Teach the help widget to understand keyword synonyms.

[28 Apr 2017 21:34] MySQL Verification Team

Thank you for the bug report.

c:\dbs>5.7\bin\mysql -uroot -p
Enter password: **********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.18-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> help create schema

Nothing found
Please try to run 'help contents' for a list of all accessible topics

mysql> help create database
Name: 'CREATE DATABASE'
Description:
Syntax:
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [create_specification] ...

create_specification:
    [DEFAULT] CHARACTER SET [=] charset_name
  | [DEFAULT] COLLATE [=] collation_name

CREATE DATABASE creates a database with the given name. To use this
statement, you need the CREATE privilege for the database. CREATE
SCHEMA is a synonym for CREATE DATABASE.

URL: http://dev.mysql.com/doc/refman/5.7/en/create-database.html