MySQL Bugs: #28156: Home/End/PgUp/PgDn/DEL keys no longer function

Bug #28156	Home/End/PgUp/PgDn/DEL keys no longer function
Submitted:	30 Apr 2007 0:48	Modified:	30 Apr 2007 10:36
Reporter:	Scott Lawrence	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.0.33	OS:	Linux (Redhat ES)
Assigned to:		CPU Architecture:	Any

Description:
Since upgrading from MySQL 4.0.20 to MySQL 5.0.33, the 'Home', 'End', 'PageUp', 'Page Down' and 'Delete' keys no longer function in the command line interface - instead, the '~' character is displayed.

For example, the following output was generated by typing 'select<home><end><pgup><pgdn><delete>' :

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1487809
Server version: 5.0.33 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select~~~~~~

Please note: This problem sounds identical to the one reported by Guilhem Bichot back in April 2003 for Version 4.1.  That probolem was assigned bug #315.  (http://bugs.mysql.com/bug.php?id=315)

Best regards,
Scott Lawrence

How to repeat:
Invoke the MySQL 5.0.33 CLI and press the 'Home', 'End', 'PageDown', 'PageUp', and/or 'Delete' keys.

Thank you for a problem report. Please, send the results of:

mysql --version

Have you compiled 5.0.33 yourself from sources?

Here are the results of 'mysql --version':

mysql  Ver 14.12 Distrib 5.0.33, for pc-linux-gnu (i686) using  EditLine wrapper

If was complied locally, the configure command was:

$ ./configure --prefix=/usr

Regards,
Scott

EditLine is a problem, it seems. Please, add --with-readline to configure command line, rebuild, and check if it will make any difference.

Recompiling with readline did indeed resolve the problem.  Thank you!

Regards,
Scott

Thank you for the feedback.