MySQL Bugs: #71338: http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql

Bug #71338	http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_a
Submitted:	10 Jan 2014 6:52	Modified:	14 Jun 2014 0:35
Reporter:	Fazir Fahmy	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:		OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	auto complete, auto-rehash

Description:
In the mysql console auto complete is not working.

configuration enabled in my.ini added entry auto-rehash
and tried command line option during the logging appending --auto-rehash
And tried the \# command in mysql prompt but the auto complete not wokring

documentation was given in below link for this
http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_auto-rehash

How to repeat:
After above configuration or command line command, type select * from te (some part of existing table) and hit tab key

Suggested fix:
When user types a query and tab for syntax for a database object ( tables, column name etc) mysql command line should suggest possible entries based on the typed part of text

Can we have any similar bug reports and cascade this

auto-rehash depends on the readline libs which are not available in windows build of the client.  However, this fact is not mentioned in the docs, so verifying as a docs bug.

http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_auto-rehash

for the actual client feature, see http://bugs.mysql.com/bug.php?id=52374

The auto-rehash documentation was updated to include this information, including:

  This feature requires a MySQL client that is compiled with 
  the "readline" library. Typically, the "readline" library is
  not available on Windows. 

Thank you for the bug report.