Bug #68877 SqlEditor does not show any query results in Ubuntu 13.04
Submitted: 6 Apr 2013 1:05 Modified: 3 Jun 2013 21:19
Reporter: Rocko Requin Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.47-1ubu1204 OS:Linux
Assigned to: CPU Architecture:Any

[6 Apr 2013 1:05] Rocko Requin
Description:
mysql-workbench-gpl-5.2.47-1ubu1204 (Oracle package; with libctemplate0 from Precise) in Ubuntu 13.0 does not show query results, nor does it populate any tab in the bottom panel (Action Output, Text Output, History).

The Ubuntu repository package mysql-workbench-5.2.40+dfsg-2 exhibits the same bug (and additionally it does not show any schemas in the left hand pane).

Note that mysql-workbench-gpl-5.2.47-1ubu1204 relies on libctemplate2 while Ubuntu 13.04 has libctemplate2, so you need to manually install libctemplate0 from Precise. 

This bug has been confirmed by several users at https://bugs.launchpad.net/ubuntu/+source/mysql-workbench/+bug/1108630.

How to repeat:
1. Install mysql-server in Ubuntu 13.04.

2. Run "mysql -uroot" to get into mysql, and create a schema and with a table with a record in it:

create schema test1;
use test1;
create table1 (id integer, name text);
insert into table1 values (1, 'test');

3. Download the libctemplate0 deb file via the link at http://packages.ubuntu.com/precise/libs/libctemplate0 and install with 'sudo dpkg -i', then download the mysql-workbench.deb file and install it.

4. Open mysql-workbench and create a new connection with default schema test1 for localhost.

5. Open the connection and create the query "select * from table1;" and execute it. The action window and results window appear but both are empty.
[6 Apr 2013 1:08] Rocko Requin
Correction: I should have said that mysql-workbench-gpl-5.2.47-1ubu1204 relies on libctemplate0, not libctemplate2.
[8 Apr 2013 21:45] MySQL Verification Team
Result query

Attachment: ubuntu_1204_and_wb.png (image/png, text), 268.68 KiB.

[8 Apr 2013 21:46] MySQL Verification Team
Thank you for the bug report. Please see attached screen-shot. Thanks.
[8 Apr 2013 21:48] MySQL Verification Team
Sorry I didn't noticed you reported on 13.04 (will test on it).
[9 Apr 2013 1:32] MySQL Verification Team
Verified on 13.04.
[9 Apr 2013 11:25] onhao hi
me too
[12 Apr 2013 3:23] onhao hi
today update the ubuntu 13.04 ,this bug is ok!
[13 Apr 2013 1:38] Rocko Requin
Yes, this looks like it is fixed now on my install of Ubuntu 13.04, too.

Now the only issues I can see with mysql-workbench 5.2.47 are (1) you can't install it without manually downloading and installing libctemplate0, and (2) it crashes when you try to close it (I get a window saying it is no longer responding and I have to force it to close).
[22 Apr 2013 16:07] OLeksii Podriezov
I'm still experiencing this bug under 12.10 with 5.2.47 rev10398 version
[3 Jun 2013 21:19] Alfredo Kojima
I'll close this as Can't Repeat as the original filer says it's working now.
Regardless, one should not expect a package for a different version of Ubuntu to work without problems. We'll have Ubuntu 13.04 packages eventually.
[10 Dec 2013 0:42] Pendem Prasad
As this bug been fixed? I have downloaded Workbench 6.0 and seems like it is still not fixed.