MySQL Bugs: #4731: Table-completion fails

Bug #4731	Table-completion fails
Submitted:	23 Jul 2004 21:12	Modified:	12 May 2005 20:29
Reporter:	Gili	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	4.0.20a	OS:	Windows (Windows XP sp1)
Assigned to:		CPU Architecture:	Any

Description:
Table auto-complete was working fine for mysql.exe back in version 4.0.15 but it is broken in 4.0.20a.

mysqlc.exe's table completion works fine.

I have auto-rehash enabled and yet when I enable mysql.exe it does not display the standard "Reading table information for completion of table and column names" message as it used to.

How to repeat:
1) Enter mysql.exe
2) use database test
3) select * from auction<tab>

   Assuming a database called 'test' exists and a table called 'auctionlist' exists within that database.

Suggested fix:
Diff against 4.0.15 and investigate the changes.

Sergei: The readline library changes ?

Are you sure it was mysql.exe and not mysqlc.exe in 4.0.15 that you tried ?
As far as I know command completion NEVER worked in mysql.exe but only in mysqlc.exe

Yes, I am 100% sure I was using mysql.exe before and table auto-completion was working. I've been using the older release for almost a year when I recently upgraded to 4.0.20a and it suddenly stopped working.

Frankly I don't understand why mysql.exe should not have it working. Either way this is something you should add/fix.

I was not able to repeat it.
I just downloaded 4.0.15 - command completion in mysql.exe is NOT working, as expected.

It was never working in mysql.exe because we were not able to make readline to compile with VC++. mysqlc.exe is a cygwin build, and it is linked with readline.

Seeing as there is no more cygwin build (at least not in 4.1.11-nt), can we reopen this issue as an enhancement request to make yet another attempt to fix this issue? It is extremely painful to operate without tab-completion.

It looks like there is such a thing as a windows build of readline: http://gnuwin32.sourceforge.net/packages/readline.htm - maybe you can try re-use this code?

Can someone from the MySQL team please reopen this issue? We need to investigate whether the version Michael mentioned is usable. This is a major usability issue under Windows!

Can someone from the MySQL team please reopen this issue? We need to investigate whether the version Michael mentioned is usable. This is a major usability issue under Windows!

Sorry for the duplicate post :(