From: Date: July 16 2001 5:32am
Subject: RE: Client Command Line interface "auto" compellation 3.23.39
List-Archive: http://lists.mysql.com/mysql/79693
Message-Id: <A184AF03977FD311966600A0C98E312163760D@MELFS003>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

<cut>
> >
> >interestingly, if I type sh<tab> I get 'show ' but if I type show 
ta<tab> I
> >don't get 'show tables' which is what I would expect.
>
> Does "show tables" actually produce a list of tables, or no tables?
> On some systems, there is a bug in glibc that prevents it from working
> properly, in which case auto-completion won't work.  (I have one such
> system, and I see the same behavior you do, even if I type "rehash"
> to force re-hashing of the names.)
>

Thanks Paul rehash fixed my problems with it not showing up (I've never had 
to use rehash before).  I was actually getting a list of tables with show 
tables, now the only thing that doesn't work is the two worded commands 
where one word is common to multiple commands (eg show tables, show 
database etc completes the show but then thinks that it is the start of 
another separate command for the next word - and tables or database aren't 
commands), but I guess that's a reasonable thing because there might be 
times when that behaviour is needed.

cheers,

noel