Bug #70272 space bar doesn't work into mysql workbench editor
Submitted: 8 Sep 2013 18:58 Modified: 2 Jan 2014 10:56
Reporter: PhLinuX Tux Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.0.7 OS:Linux (ubuntu 12.04.02 LTS 64b)
Assigned to: CPU Architecture:Any

[8 Sep 2013 18:58] PhLinuX Tux
Description:
I installed mysql-workbench 6.0.7-1ubu1204 from the workbench site into my distro 12.04.02LTS 64b, but there is a trouble when using the SQL Editor: the space bar doesn't write a blank space anymore and do nothing.
I found out that it works using the key combination windows + space bar.

I uninstalled it and reinstalled the 5.2.38 from universe Ubuntu distro and it works then I did the same on my dev box with same distro and WB releases: same results.

I suppose there is a key mapping to do but didn't find where.

Anyone can get me ont the way?

I extracted the control file from the package to find the maintener but its E-mail adress is wrong:
Package: mysql-workbench-community
Source: mysql-workbench
Version: 6.0.7-1ubu1204
Architecture: amd64
Maintainer: MySQL Workbench team <workbench@sun.com>

How to repeat:
Install 6.0.7-1ubu1204 amd64 package.
Connect to a database
Open the SQL editor
Write down a simple request containing white spaces like:
  select count(*) from ....
[8 Sep 2013 22:37] MySQL Verification Team
Thank you for the bug report. What you mean with space bar doesn't works? your query looks like selectcount(*)from... ? Thanks.
[9 Sep 2013 11:25] PhLinuX Tux
Yes that's it. Thus, if you execute that request like it is, it returns a syntax error. This means that the space bar doesn't do anything or send a not displayable caracter.
To work around, you must maintain down the windows key and strike the space bar.
[9 Sep 2013 16:12] MySQL Verification Team
Query and space

Attachment: wb_space_bar.png (image/png, text), 84.59 KiB.

[9 Sep 2013 16:13] MySQL Verification Team
Thank you for the feedback. Please see attached picture.
[9 Sep 2013 20:23] PhLinuX Tux
Ok, I understand it works for you ...

I just uninstalled WB 5.2.38 and reinstall WB 6.0.7: The bug is back.
I reinstalled 5.2.38 : the bug is not there anymore

Do you know if it could be some key mapping for WB womewhere? May be into gnome?
I crawled into dconf but didn't find anything that may be related to
[9 Sep 2013 20:27] PhLinuX Tux
OOPS I see in your picture I missed one thing: I don't use unity but gnome classic.
Could that be the difference ?
[9 Sep 2013 20:42] PhLinuX Tux
Well : just made new tries with WB 6.0.7 and unity => same issue
[26 Oct 2013 19:22] PhLinuX Tux
I am still having this issue.
Anyone may help about this key mapping trouble?
[27 Oct 2013 15:35] PhLinuX Tux
Just do some additional tries:
On my laptop running ubuntu 12.04 LTS 32b (up to date) and WB 5.2.38 all is fine
On my laptop running ubuntu 12.04 LTS 32b (up to date) and WB 6.0.7-1ubu1204 same trouble (need to strike down window key to get space bar working)
I have a VirtualBox installed on the box where I have this trouble:
With that VM running ubuntu 12.10 32b (up to date) and WB 5.2.38 all is fine
With that VM running ubuntu 12.10 32b (up to date) and WB 6.0.7-1ubu1204 all is fine

So I have 2 real boxes running machines running ubuntu 12.04 (32b and 63b) that have the same trouble
On a virtual box I do not see that trouble (but it is running ubuntu 12.10 instead of 12.04) even If I hade to manually add the libctemplate0 which doesn't exist anymore at ubuntu 12.10 release (replaced by libctemplate2)

Thanks for any help
[11 Nov 2013 9:45] PhLinuX Tux
Sorry, I am still stuck with this issue.
Any status on it?
[11 Nov 2013 10:05] PhLinuX Tux
I created an ubuntu 12.04 VM 32bit ans installed workbench 6.0.7 last week and it works fine.
So it seems to be limited to both of my real boxes running ubuntu 12.04 32 and 64bit.
[11 Nov 2013 10:35] PhLinuX Tux
Query and nospace

Attachment: bug_wb-6.0.7_u-12.04.png (image/png, text), 196.22 KiB.

[2 Jan 2014 10:56] PhLinuX Tux
I finally found how to work around this bug.
In case it could help others, do this:
Go to edit/preferences.
Go to SQL Editor and untick "Productivity - Enable Code Completion in Editors"

This bug also exists in workbench 6.0.8 and reproductible
[10 Mar 2014 9:53] Jean-Sébastien HEDDE
Reproduced with 6.0.9 on ubuntu 12.04 64bits.

The work arround save me !