resizing terminal - display issue

[Ryan Brothers]

I am running Percona Server 5.6.17-66.0 on CentOS 6.5. I connect to this machine using putty on Windows.

I noticed that after I start a mysql console, if I resize my putty window, the display doesn't always display correctly.

For example:

1) Run: mysql -u root -p

2) Resize putty window.

3) Press up to see the last run query.

When I do the above, the display appears as:

root@localhost/(none)> root@localhost/(none)> select * from user;

rather than:

root@localhost/(none)> select * from user;

I'm also seeing similar issues if I type a long query that wordwraps, then resize my putty window, and then press tab to use auto-complete for a field name in my query.

Is it possible that these issues could be fixed?

Thanks for your help.

Ryan

[Valerii Kravchuk (valerii-kravchuk)]

I can reproduce this with the same version and OS as yours, using putty from Windows. When I change width (to Nx24 instead of 80*24) of putty window, I get prompt copied when I press arrow up:

mysql> mysql> show plugins;

Query just works when Enter is pressed. I am also not sure is it a problem caused/related to putty or TERM setting:

[root@centos openxs]# echo $TERM
xterm
[root@centos openxs]# mysql --version
mysql Ver 14.14 Distrib 5.6.17-66.0, for Linux (x86_64) using EditLine wrapper
[root@centos openxs]# cat /etc/issue
CentOS release 6.5 (Final)
Kernel \r on an \m

[root@centos openxs]#

or mysql client itself.

[Valerii Kravchuk (valerii-kravchuk)]

Same happens with this mysql client version:

[root@centos openxs]# /home/openxs/dbs/p5.5/bin/mysql --version
/home/openxs/dbs/p5.5/bin/mysql Ver 14.14 Distrib 5.5.36-34.0, for Linux (x86_64) using EditLine wrapper

but does not happen with this one:

[root@centos openxs]# /home/openxs/dbs/5.5/bin/mysql --version
/home/openxs/dbs/5.5/bin/mysql Ver 14.14 Distrib 5.5.29, for Linux (x86_64) using readline 5.1

So, probably it's about EditLine vs readline builds.

[Laurynas Biveinis (laurynas-biveinis)]

This will be fixed as a part of bug 1266386 work then.

[Tomislav Plavcic (tplavcic)]

Did some testing (I have tested with putty on linux) and it behaved just like described in the bug when using editline build - and it worked ok with readline build so it will be fixed in https://bugs.launchpad.net/bugs/1266386

[Laurynas Biveinis (laurynas-biveinis)]

Is this an upstream bug?

[Tomislav Plavcic (tplavcic)]

Reported upstream: https://bugs.mysql.com/bug.php?id=77148

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1512