[debian-mysql] Bug#608973: mysql-client-5.1: tab completion attempting to complete wrong object type

[Tyler MacDonald]

Package: mysql-client-5.1
Version: 5.1.49-3
Severity: normal


Current behaviour:

When attempting to call a stored procedure, the MySQL client's tab
completion provides table and column completions, but does not provide tab
completion for the stored procedure.

Expected:

When issuing "CALL", completions should be stored procedure names, and
table/column names should /not/ be available as completions because they are
invalid in this context.

I haven't tested stored functions or other objects, but they may suffer from
the same ailment.

To reproduce:

mysql> CREATE TABLE tab_complete (a int);
Query OK, 0 rows affected (0.09 sec)

mysql> CREATE PROCEDURE tab_complete_procedure () LANGUAGE SQL SELECT 1;
Query OK, 0 rows affected (0.03 sec)

mysql> CALL tab_complete
tab_complete    tab_complete.a  

On the statement line, I have pressed "tab" twice to show all available
completions.


  Thanks,
     Tyler




-- System Information:
Debian Release: 6.0
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-5-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-client-5.1 depends on:
ii  debianutils             3.4.2            Miscellaneous utilities specific t
ii  libc6                   2.11.2-7         Embedded GNU C Library: Shared lib
ii  libdbd-mysql-perl       4.016-1          Perl5 database interface to the My
ii  libdbi-perl             1.612-1          Perl Database Interface (DBI)
ii  libgcc1                 1:4.4.5-10       GCC support library
ii  libmysqlclient16        5.1.49-3         MySQL database client library
ii  libncurses5             5.7+20100313-4   shared libraries for terminal hand
ii  libreadline6            6.1-3            GNU readline and history libraries
ii  libstdc++6              4.4.5-10         The GNU Standard C++ Library v3
ii  libwrap0                7.6.q-19         Wietse Venema's TCP wrappers libra
ii  mysql-common            5.1.49-3         MySQL database common files, e.g. 
ii  perl                    5.10.1-16        Larry Wall's Practical Extraction 
ii  zlib1g                  1:1.2.3.4.dfsg-3 compression library - runtime

mysql-client-5.1 recommends no packages.

Versions of packages mysql-client-5.1 suggests:
ii  libterm-readkey-perl          2.30-4     A perl module for simple terminal 

-- debconf-show failed