LP #1266386: mysql client is built with EditLine instead of readline (percona-server-client-5.6)
General
Escalation
General
Escalation
Description
**Reported in Launchpad by Alexey Molchanov last update 23-06-2015 15:59:54
Latest mysql client 5.6 binary package from Percona repository is built with EditLine library instead of GNU readline, while previous versions were traditionally built with readline support (at least GPL builds of mysql server).
This issue applies to both deb package for Ubuntu (package: percona-server-client-5.6, version: 5.6.15-rel63.0-519.saucy) and rpm package for RHEL6. ============================== $ mysql --version mysql Ver 14.14 Distrib 5.6.15, for Linux (x86_64) using EditLine wrapper
$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5055 Server version: 5.6.15-63.0 Percona Server (GPL), Release 63.0
Copyright (c) 2009-2013 Percona LLC and/or its affiliates Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. ... mysql> select version(); -------------
version()
-------------
5.6.15-63.0
------------- 1 row in set (0,00 sec) ==============================
The switch from readline to EditLine alters traditional behavior of many commonly used keybindings in mysql client in an unexpected and annoying way. Among most commonly used keybindings which behave differently since then I can provide at least two examples:
1. Control+r (reverse-search-history) - this key combination still calls the same function as before (search input history backwards), but the function itself behaves differently now and its usability is much worse then before.
2. Control+w (unix-word-rubout) - it used to delete the single word behind point, using white space as a word boundary. Now (with editline) it deletes everything backward from point to the beginning of the line.
I understand that Oracle is pushing everyone to switch to the BSD-licenced EditLine, but I think we should not sacrifice usability of the great product just because of their corporate interests. Guys, could you please switch back your builds to the good old GNU readline which we all used to through the years?
P.S. Bug 631667 contains a very similar report related to percona-server-client-5.1.
Environment
None
Smart Checklist
Activity
Show:
lpjirasync January 21, 2018 at 4:03 PM
**Comment from Launchpad by: Valerii Kravchuk on: 23-06-2015 15:59:54
In 5.6.24 we have the following now on CentOS:
[openxs@centos ~]$ mysql --version mysql Ver 14.14 Distrib 5.6.24-72.2, for Linux (x86_64) using 6.0 [openxs@centos ~]$ ldd `which mysql` | grep readline libreadline.so.6 => /lib64/libreadline.so.6 (0x00007fb00d169000)
So, readline is used and linked dynamically
lpjirasync January 21, 2018 at 4:03 PM
**Comment from Launchpad by: Tomislav Plavcic on: 06-05-2015 08:01:51
**Comment from Launchpad by: Tomislav Plavcic on: 05-05-2015 12:04:40
Seems for 5.5 it was like 50:50 or something - on centos it was built with readline and on ubuntu with editline so I'll target it for next 5.5 milestone also.
lpjirasync January 21, 2018 at 4:03 PM
**Comment from Launchpad by: monty solomon on: 13-07-2014 17:38:41
**Reported in Launchpad by Alexey Molchanov last update 23-06-2015 15:59:54
Latest mysql client 5.6 binary package from Percona repository is built with EditLine library instead of GNU readline, while previous versions were traditionally built with readline support (at least GPL builds of mysql server).
This issue applies to both deb package for Ubuntu (package: percona-server-client-5.6, version: 5.6.15-rel63.0-519.saucy) and rpm package for RHEL6.
==============================
$ mysql --version
mysql Ver 14.14 Distrib 5.6.15, for Linux (x86_64) using EditLine wrapper
$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5055
Server version: 5.6.15-63.0 Percona Server (GPL), Release 63.0
Copyright (c) 2009-2013 Percona LLC and/or its affiliates
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
...
mysql> select version();
-------------
version()
-------------
5.6.15-63.0
-------------
1 row in set (0,00 sec)
==============================
The switch from readline to EditLine alters traditional behavior of many commonly used keybindings in mysql client in an unexpected and annoying way. Among most commonly used keybindings which behave differently since then I can provide at least two examples:
1. Control+r (reverse-search-history) - this key combination still calls the same function as before (search input history backwards), but the function itself behaves differently now and its usability is much worse then before.
2. Control+w (unix-word-rubout) - it used to delete the single word behind point, using white space as a word boundary. Now (with editline) it deletes everything backward from point to the beginning of the line.
I understand that Oracle is pushing everyone to switch to the BSD-licenced EditLine, but I think we should not sacrifice usability of the great product just because of their corporate interests.
Guys, could you please switch back your builds to the good old GNU readline which we all used to through the years?
P.S. Bug 631667 contains a very similar report related to percona-server-client-5.1.