Bug #51848 Display in info column not always readable
Submitted: 8 Mar 2010 22:47 Modified: 27 May 2010 11:17
Reporter: John Haney Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.21 OS:Windows (XP x32)
Assigned to: Mike Lischke CPU Architecture:Any

[8 Mar 2010 22:47] John Haney
Description:
Most times the queries that are being run are not displayed correctly on the info column. It may have something to do with the use of comments in the query and when the query comes through a PHP connection.

select * from table - Shows up in info column when sent from query browser

/* test */select * from table - Shows up in info column when sent from query browser

/* test */select * from table - Fails to display properly in info column when sent from PHP

How to repeat:
Send query through PHP with comments

Suggested fix:
Not sure.
[9 Mar 2010 9:27] Johannes Taxacher
Hi John,

could you explain what you mean by "sent from PHP" and what info column you're referring to?
thanks in advance
[9 Mar 2010 17:17] John Haney
By PHP I mean if the query is sent from our web application which uses PHP to connect to MySQL.

The 'info' column is in the connections tab of an admin tab. So start an admin of a server and then click the connections tab to see the active connections. The last default column is the 'info' column that I see the problem in.
[10 Mar 2010 6:57] Susanne Ebrecht
According to
http://dev.mysql.com/doc/refman/5.1/en/comments.html

you need spaces between the comment command and the next options.

Do you have same failure when you use:

/* test */ select * from table
[11 Mar 2010 0:41] John Haney
Yes it still happens. We have the spaces (always have) and I just did not put them in when I typed the example queries.
[16 Mar 2010 12:17] Valeriy Kravchuk
What do you see in the Info column when you execute 

/* test */ select * from table

and it "fails"? The problem is in missing comment or in something else?
[16 Mar 2010 18:16] John Haney
The display is different at times but most common thing is the queries will be truncated (at random places) and where the query should display there will be what looks like pixels from the bottom of the query string characters. Changing the width of the column has no affect.

If the paragragh above was the actual query text it may display as:

The dis_ _       __      ___   _        _ _
[29 Mar 2010 20:27] MySQL Verification Team
Thank you for the feedback. Could you please provide a screen-shot of the issue reported?. Thanks in advance.
[7 Apr 2010 17:35] John Haney
Image of garbage text as requested.

Attachment: garbage_text_mysql_gui.PNG (image/x-png, text), 7.07 KiB.

[7 Apr 2010 17:37] John Haney
Just to clarify what the image shows - Notice that the text is missing in the 'info' column. Only a few pixels are displayed where the entire query should be displayed.

Also it is still this way in version 5.2.17.

John
[11 Apr 2010 15:36] Valeriy Kravchuk
Please, send the results of Help > System Info menu item.
[13 Apr 2010 14:46] John Haney
Checked server status: Server is stopped.Checked server status: Server is running.get_server_version: parsed (5, 0, 27)

Checked server status: Server is running.get_server_version: parsed (5, 0, 27)

Checked server status: Server is running.get_server_version: parsed (5, 0, 27)

Checked server status: Server is running.get_server_version: parsed (5, 0, 27)

Checked server status: Server is running.get_server_version: parsed (5, 0, 27)

Checked server status: Server is stopped.Checked server status: Server is running.get_server_version: parsed (5, 0, 27)

Checked server status: Server is running.get_server_version: parsed (5, 0, 27)

have_bdb

new

have_bdb

new

have_bdb

new

have_bdb

new

have_bdb

new

have_bdb

new

have_bdb

new

have_bdb

new

have_bdb

new

have_bdb

new

ctrl_be: Query Error Error executing 'show global status':

2006. Error:2006

Failed to connect to MySQL server

Checked server status: Server is running.get_server_version: parsed (5, 0, 89)

ctrl_be: Query Error Error executing 'show global status':

2006. Error:2006

Failed to connect to MySQL server

Checked server status: Server is stopped.ctrl_be: Query Error Error executing 'show global status':

2006. Error:2006

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

Channel closed.

MySQL Workbench OSS for Windows version 5.2.17

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 2.1.7415 Release

OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)

CPU: 2x Intel(R) Core(TM)2 Duo CPU     E8400  @ 3.00GHz, 3.0 GiB RAM

Video adapter info:

Adapter type: ATI Radeon HD 2400 Pro  

Chip Type: ATI Radeon Graphics Processor (0x94C1)

BIOS String: 113-B27602-113

Video Memory: 262144 KB
[26 Apr 2010 7:42] Sveta Smirnova
Thank you for the feedback.

This looks like same problem as in bug #51119. Please provide full exact query you run from PHP script. You can add it as hidden comment.
[17 May 2010 15:53] Mike Lischke
Fixed in repository.
[26 May 2010 20:39] Johannes Taxacher
fix confirmed in repository
[27 May 2010 11:17] Tony Bedford
An entry has been added to the 5.2.22 changelog:

In the Connections tab of the Administrator, queries containing a comment did not always display correctly in the Info column.