Bug #69991 MySQL client is broken without readline

Description:
I removed all MySQL packages from the system:
rpm --erase $(rpm -qa|grep -i mysql)

I then install MySQL 5.6 from rpm tarball

It seems to come with readline.

If I have old .mysql_history then very weird things can happen which really break the new client.

Further, even if the .mysql_history file was not there, there are issue:
moving forward/backward in history with up/down is per-sql-line, instead of combining a complete SQL statement together
CTRL-R backwards searching does not work
CTRL-A/CTRL-E/etc no longer work as expected
most other editline shortcuts are broken. 

How to repeat:
use the new client

Suggested fix:
go back to readline

It seems to come with editline not readline.  Sorry.  It is late where I am at.

Hello Justin,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

update synopsis - was backwards

this is killing me... every time I want to erase the previous word with ctrl-w and it takes the entire line, I scream. Pretty please fix this trivial packaging issue ASAP :)

^w acting as ^u is insanely annoying

^u actually kills in both directions while ^k works as expected

Just wanted to wish this bug a happy birthday.

FYI, MySQL does have some tips on using libedit, including using the .editrc to fix certain control codes:

http://dev.mysql.com/doc/refman/5.6/en/mysql-tips.html

Fair enough, I am using the wrong key strokes for libedit and should get used to the new functionality.

Just retested some of the complaints with the newest version:

mysql --help | head -1
mysql  Ver 14.14 Distrib 5.6.21, for Linux (x86_64) using  EditLine wrapper

The history for a multi line query was collapsed to a single line [check]

CTRL-R backwards searching worked [check]

Testing the .editrc seemed to indicate that it was parsed correctly, 'bind "^W" ed-delete-prev-word' worked as configured [check]

Perhaps this bug is solved as well as can be expected. Justin?

From which bug is this a duplicate?

Is a duplicate of these:
Bug 14634386 - HISTORY WRITTEN BY LIBEDIT IS NOT READABLE BY READLINE 
Bug 16633124 - COMPATIBILITY ISSUE WITH MYSQL HISTORY ("\040" INSTEAD OF SPACE) 
http://bugs.mysql.com/bug.php?id=68925

Closed by mistake, sorry. Reopened. -Stefan

Not 100% sure if this is related to this issue, but I found \n in my prompt is no-longer respected.

.editrc is far from offering the features of readline's .inputrc (won't clutter the bugreport all the examples).
I didn't about the rational for leaving readline, but IHMO it's not a very good choice.
readline is much more powerful and should rather be the default of the mysql-community-client.

(https://github.com/percona/percona-server/pull/57)