At 1:32 PM +1000 7/16/01, Noel Clarkson wrote:
>> >interestingly, if I type sh<tab> I get 'show ' but if I type show
>> >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.
You might wanna check to see if you have no-auto-rehash specified in
your .my.cnf file. That's probably not so if completion worked before,
Paul DuBois, paul@stripped