MySQL Bugs: #43281: Query Browser doesn't display results when there are some

Bug #43281	Query Browser doesn't display results when there are some
Submitted:	28 Feb 2009 21:18	Modified:	11 Mar 2009 13:13
Reporter:	Bruce Norgan	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.17	OS:	Windows (2008 Vista Business)
Assigned to:		CPU Architecture:	Any

Description:
A SELECT statement finds records (i.e. tells you how many on status line).  But the data is supposed to be displayed in the results pane.  There are the correct number of lines for the records found but no data is shown in the fields.  Created a program to select records and display them in a grid.  They were displayed programatically which shows they are in the table.  Also, if you run Administrator you can see the table layout, but when you try to edit using Query Browser there's an error message of its not working.  This version is supposed to work with MySQL 5.1 but I wonder if there's a bug.

How to repeat:
Run Query Browser and try to edit data from a SELECT.

Suggested fix:
Displaying the data is supposed to be automatic so there's not a VIEW setting to say you want to see it.

Thank you for the bug report. According your how to repeat instructions:
"Run Query Browser and try to edit data from a SELECT". I am able to edit
data so my question is: The table you are trying to edit has a primary key?.
Thanks in advance.

In reply to your question, yes, the table does have a primary key.  Also, the SQL is SELECT * so everything should show up.

Thank you for the feedback. Could you please try the new version 1.2.17 and if still you get the same behavior please provide a dump of a table which presents the behavior reported. Thanks in advance.

I checked the download site before trying to find a later version of Query Browser.  It is only downloadable as a package under GUI-Tools (i.e. MySqlAdmin etc.).  There is no way you can download just the browser because I couldn't find any options for getting a later version.

You won't be able to download just the Query Browser. MySQL Query Browswer and MySQL Administrator are depending from each other. They have lots of common tools like the editor that they both are using.

The actual version of MySQL Query Browser, Administration, Migration Toolkit is 1.2.17.

Please try actual version here because we are pretty sure that your issue already is fixed.

Yesterday at the library I downloaded MySQL GUI Tools 5.0-r17-win32.msi and installed it last night.  The "r17" must be version 1.2.17.  When I ran Query Browser afterwards the SELECT * on the table retrieved the seven records there but nothing was displayed.  I was asked what composes the table.  There is an integer primary key, and since its an auto-incr, the numbering goes from 1 to 7.  There's a 20 char string brief description field in each record and that's it.  I'm running MySQL version 5.1 with x64 processing for a HP laptop that's got Windows Vista Business.  The 5.0 tools are supposed to work with this setup.  As I said before, I created an ASP.Net program with an SQL statement and displayed the results in a grid just to make sure the data was there.  MySQLAdmin has a data display capability which seems to use Query Browser.  I've used it in the past.  But now it says the browser isn't working and goes into an error mode.  So other than my program, there's no way to use the GUI tools to even display any data.

Had a chance to test MySQLAdmin with version 1.2.17.  It no longer says that the Query Browser isn't working so that has been fixed.  But when going to edit table data it has the same problem as the browser itself.  In the result area there are seven lines for data and a status message that seven rows have been retrieved.  There are even two columns for the two fields.  But no data is in the columns.  Its possible there's a flag somewhere to say to actually display the data but I can't find it.  As far as I know its supposed to automatically appear when you execute (i.e. lightning bolt) the query.

Please provide your table and content. As you will see in screenshot below I can't repeat this behaviour.

screenshot from test

Attachment: bug43281.PNG (image/png, text), 71.70 KiB.

It happens with every table in the database.  The simplest example is
first field:  integer (primary key)
second  "  :  varchar(16)
data:
1  course #1
2  course #2
3  course #3
...
7  course #7
When version #17 was installed it overlays the old one, so when you run the latest one the new one is used.  This is MySQL 5.1 on a x64 Windows Vista Business platform.  All the service packs are installed.  Perhaps it would be difficult for you to duplicate this exact system.

This seems to be OS related.

We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/

Can this bug be related to the Application Font Settings (inside Tools->Options->General Options)?  I'm trying to re-set the font for the Default, Data and Code Font.  Whenever i set/reset the fonts in the Choose Button, the "Font Style" is always set to blank, even if i previously set it to Regular/Italic/Bold/etc.