MySQL Bugs: #294: Delete key doesn't work in MySQL 4.1.0 Command Line Client

Bug #294	Delete key doesn't work in MySQL 4.1.0 Command Line Client
Submitted:	15 Apr 2003 15:34	Modified:	27 Apr 2003 10:36
Reporter:	Jay G	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	4.1.0	OS:	Linux (RedHat 8.0, Kernel 2.4.20)
Assigned to:	Jani Tolonen	CPU Architecture:	Any

Description:
Upgraded from 4.0.12 to 4.1.0alpha using the RPM's from the MySQL website.
Before the upgrade the mysql command line client had no problem with use of the "DELETE" key.  After the upgrade the mysql command line client (4.1.0) prints a "~" instead of performing a "DELETE" on the current string being typed in/editted.  All other normal key functions seem to work including "BACKSPACE".  Please note this is the "DELETE" key not the "BACKSPACE".  The "DELETE" key still works in all other command line programs that it had worked in before.  Honestly this is more of an announce than anything else and could be considered a feature request, except it existed before now.

How to repeat:
Happens every time I use 4.1.0's command line client.

Suggested fix:
Make the 4.1.0 command line client recognize the command character produced by the "Delete" key.

There is difference, but final result is the same.

RedHat 8.0 and RedHat 9
MySQL 3.23 and 4.0

mysql> abcd

press left arrow 2 times then <delete> 2 times

mysql> ad

same with MySQL 4.1.0 and up

mysql> abcd
mysql> ab~~cd

The reason is that we temporarly switched from readline to libedit for 4.1.

As libedit is not yes as full-features as readline, we will switch back to readline in 4.1.1 for the GPL MySQL distribution.