MySQL Bugs: #71348: space bar doesn't work into mysql workbench editor

Bug #71348	space bar doesn't work into mysql workbench editor
Submitted:	11 Jan 2014 18:35	Modified:	12 Nov 2014 0:16
Reporter:	PhLinuX Tux	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.0.8	OS:	Linux (Ubuntu 12.04.4 LTS)
Assigned to:		CPU Architecture:	Any

Description:
This is the same bug as Bug #70272 but in different OS and Workbench releases  releases which is totaly ignored because it was not reproduced.

I have this issue with 2 ubuntu boxes (32bits and 64bits). I don't have it on virtual machines.

Recently I found this trouble is due to the code completion into the SQL Editor and the way to work around is to untick "Productivity - Enable Code Completion in Editors" in preferences.

System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 6.0.8  revision 11354 build 833
	Configuration Directory: /home/phl/.mysql/workbench
	Data Directory: /usr/share/mysql-workbench
	Cairo Version: 1.10.2
	OS: Linux 3.2.0-58-generic
	CPU: 2x AMD Athlon(tm) 64 X2 Dual Core Processor 4600+ 2000.000 MHz, 3,9 GB RAM
	Distribution: Ubuntu 12.04.4 LTS

How to repeat:
Type a query in the SQL editor containing spaces
  select count(*) from mysql.user;

I couldn't repeat on Ubuntu 64-bits English Language maybe is necessary more
details about your environment. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Sorry, I didn't get any email asking for information request.

The version I am running is not translated and use English.
I suppose this is the "Common" version.

If you need more details, do not hesitate to ask.

Here is what I can read in the logs :
 	MySQL Workbench Community (GPL) for Linux/Unix version 6.0.8  revision 11354 build 833
	Configuration Directory: /home/phl/.mysql/workbench
	Data Directory: /usr/share/mysql-workbench
	Cairo Version: 1.10.2
	OS: Linux 3.2.0-60-generic
	CPU: 2x AMD Athlon(tm) 64 X2 Dual Core Processor 4600+ 1000.000 MHz, 3,9 GB RAM
	Distribution: Ubuntu 12.04.4 LTS

I can see the information I just sent was already given ...
What kind of environment information do you need ?

mysql --version
mysql  Ver 14.14 Distrib 5.5.35, for debian-linux-gnu (x86_64) using readline 6.2

Here is my setup env: (i removed LS_COLORS)
COLORTERM=gnome-terminal
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-NY3EKzUzl3,guid=4be0c21e09de032977bc03a400000071
DEFAULTS_PATH=/usr/share/gconf/gnome-fallback.default.path
DESKTOP_SESSION=gnome-fallback
DISPLAY=:0.0
GDMSESSION=gnome-fallback
GIT_DIR=/home/phl/.git
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GNOME_KEYRING_CONTROL=/tmp/keyring-CQsmuc
GNOME_KEYRING_PID=3694
GPG_AGENT_INFO=/tmp/keyring-CQsmuc/gpg:0:1
GTK_MODULES=canberra-gtk-module
HISTCONTROL=ignoredups
HOME=/home/phl
LANG=fr_FR.UTF-8
LANGUAGE=fr_FR:en
LESSCLOSE=/usr/bin/lesspipe %s %s
LESSOPEN=| /usr/bin/lesspipe %s
LIBGL_DRIVERS_PATH=/usr/lib/fglrx/dri:/usr/lib/x86_64-linux-gnu/dri:/usr/lib/dri:/usr/lib32/fglrx/dri:/usr/lib/i386-linux-gnu/dri
LOGNAME=phl
MANDATORY_PATH=/usr/share/gconf/gnome-fallback.mandatory.path
OLDPWD=/home/phl
PATH=/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
PWD=/home/phl/.mozilla
SD_REPO=/home/phl/.git/sd
SESSION_MANAGER=local/phlsys:@/tmp/.ICE-unix/3705,unix/phlsys:/tmp/.ICE-unix/3705
SHELL=/bin/bash
SHLVL=1
SSH_AGENT_PID=3764
SSH_AUTH_SOCK=/tmp/keyring-CQsmuc/ssh
TERM=xterm
UBUNTU_MENUPROXY=libappmenu.so
USER=phl
_=/usr/bin/env
WINDOWID=33554436
XAUTHORITY=/home/phl/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-gnome-fallback:/etc/xdg
XDG_CURRENT_DESKTOP=GNOME
XDG_DATA_DIRS=/usr/share/gnome-fallback:/usr/share/gnome:/usr/local/share/:/usr/share/
XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0
XDG_SESSION_COOKIE=ac8bb018ce6802fa238622e4485d7fb5-1394953052.89094-1415018166
XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0

I just made this try:
$ export LANG=C
$ export LANGUAGE=en
$ mysql-workbench
  => tick  Edit/preferences/SQL Editor/Enable Code Completion in Editors
  The trouble is reproduced: No white space given using space bar into SQL Editor
  => untick Edit/preferences/SQL Editor/Enable Code Completion in Editors
  It is OK, the space bar do its job

Incidently I found that an other person is also affected by this bug at WB release 6.0.9.
Please see Bug #70272 comments

[10 Mar 9:53] Jean-Sébastien HEDDE
Reproduced with 6.0.9 on ubuntu 12.04 64bits.
The work arround save me !

Please try version 6.1.4. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Just install WB 6.14.
Sorry, the problem is still here.

08:46:40 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 6.1.4  revision 11773 build 1454
	Configuration Directory: /home/phl/.mysql/workbench
	Data Directory: /usr/share/mysql-workbench
	Cairo Version: 1.10.2
	OS: Linux 3.2.0-61-generic
	CPU: 2x AMD Athlon(tm) 64 X2 Dual Core Processor 4600+ (1800.000MHz) - 3,86GiB RAM
	Distribution: Ubuntu 12.04.4 LTS

Please try version 6.2.3. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".