Bug #39441 Autocomplete in mysql for "call" offers databases not procedure

• Submitted: 14 Sep 2008 13:33
• Modified: 29 Sep 2009 10:22
• Reporter: Janek Bogucki
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S4 (Feature request)
• Version: 5.0, 5.1
• OS: Linux (Kubuntu 8.04)
• CPU Architecture: Any

[14 Sep 2008 13:33] Janek Bogucki

Description:
When using mysql and tab to autocomplete a stored procedure call a list of databases is offered not a list of procedures.

How to repeat:
Have some procedures,

mysql> show procedure status;
+-------+--------------------+-----------+---------+---------------------+---------------------+---------------+---------+
| Db    | Name               | Type      | Definer | Modified            | Created             | Security_type | Comment |
+-------+--------------------+-----------+---------+---------------------+---------------------+---------------+---------+
| cert2 | circle_area        | PROCEDURE | jdb@%   | 2008-09-14 14:16:34 | 2008-09-14 14:16:34 | DEFINER       |         |
| cert2 | world_record_count | PROCEDURE | jdb@%   | 2008-09-14 14:26:10 | 2008-09-14 14:26:10 | DEFINER       |         |
+-------+--------------------+-----------+---------+---------------------+---------------------+---------------+---------+

Start a call statement and press tab twice to see the autocomplete options,

mysql> call
cert                cert2               information_schema  world

Instead of being a list of procedures (circle_area, world_record_count) it is a list of databases.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cert               |
| cert2              |
| world              |
+--------------------+

Suggested fix:
Use the call keyword to show a list of procedure names instead of databases.

[15 Sep 2008 8:03] Janek Bogucki

Fixed OS version

[29 Sep 2009 10:22] Susanne Ebrecht

Many thanks for writing a bug report.

I think this is a bug and not a feature request.

Neither "call" nor "select" works with auto completion in MySQL 5.1 client.