MySQL Bugs: #12503: readline broken - can't enter umlauts, history garbles screen

Bug #12503	readline broken - can't enter umlauts, history garbles screen
Submitted:	10 Aug 2005 15:42	Modified:	25 Oct 2005 8:30
Reporter:	Axel Schwenke	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.0.12	OS:	Linux (Linux (SuSE 9.x, SLES-9))
Assigned to:		CPU Architecture:	Any

Description:
When compiling MySQL with the bundled readline library the command line client 'mysql' behaves badly:

- I cannot enter umlauts (äöü) any more
- when using the history functions (cursor up/down) the screen gets garbled
- when typing over the end of the line, DELETE works only to the start of the new line

Workaround: configure MySQL --without-readline (thus using the systems libreadline)

How to repeat:
start 'mysql' and play with it

Works like a charm for me (SuSE 9.3, xterm, compile-pentium-debug-max build from yesters BK)

Just retried it. Still a bug for me. Environment:

~ #cat /etc/SuSE-release 
SuSE Linux 9.0 (i586)

~ #locale
LANG=POSIX
LC_CTYPE=de_DE@euro
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

/usr/local/src/mysql-5.0 #bk changes | head -1
ChangeSet@1.1907, 2005-08-28 20:21:47+02:00, kent@mysql.com

configure line: ./configure --without-berkeley-db

'mysql' client is running in xterm

Typical symptoms:

- after entering an umlaut (äöü), backspace deletes more characters than typed before. I.e. I can delete the mysql> promt.
- after executing some commands, use the history function. Press <cursor up> <cursor down> a few times. That makes the cursor jump in the middle of the line.
- type a line longer than the screen, execute it. Then use history <cursor up>. Only part of the line comes up.

Another environment:

ls3235:~ # cat /etc/SuSE-release 
SUSE LINUX Enterprise Server 9 (x86_64)

ls3235:~ # locale
LANG=
LC_CTYPE=en_US.UTF-8
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

configure line: ./configure

client/mysql running in xterm

same symptoms as above, plus
-can't enter umlauts (get a <beep> from terminal)

works fine with LANG=de_DE or LANG=en_US but fails with LANG=C or LANG=POSIX

I bet this is a duplicate of Bug #3982.

Please reverify against 5.0.14. Thanks.

Seems to be ok for me now with latest bk sources.

Axel?