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

[11 Jan 2014 18:35] PhLinuX Tux
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;
[21 Jan 2014 15:11] MySQL Verification Team
I couldn't repeat on Ubuntu 64-bits English Language maybe is necessary more
details about your environment. Thanks.
[22 Feb 2014 1:00] Bugs System
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".
[16 Mar 2014 8:43] PhLinuX Tux
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
[16 Mar 2014 8:52] PhLinuX Tux
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
[16 Mar 2014 9:08] PhLinuX Tux
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
[16 Mar 2014 9:16] PhLinuX Tux
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 !
[1 Apr 2014 13:53] MySQL Verification Team
Please try version 6.1.4. Thanks.
[2 May 2014 1:00] Bugs System
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".
[4 May 2014 6:50] PhLinuX Tux
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
[12 Oct 2014 0:16] MySQL Verification Team
Please try version 6.2.3. Thanks.
[12 Nov 2014 1:00] Bugs System
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".