Bug #67067 Cannot returns any error message
Submitted: 3 Oct 2012 8:51 Modified: 28 Dec 2012 9:05
Reporter: Zoltn Kbl Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.38/5.2.44 OS:Linux (ubuntu 12.04 LTS)
Assigned to: CPU Architecture:Any
Tags: error message

[3 Oct 2012 8:51] Zoltn Kbl
I cannot find any error message if I make an syntax or any kind of error in SQL command. The editor identifies the error - red cross appears in the left side of the editors panel but I cannot see any error message. Now the Workbench is inconvenient to use. Please let me know what to do.

How to repeat:
// systax error
SELECTx * FROM table;

// query on nonexisting table
SELECT * FROM table_not_exists;

// or any bad SQL command
[3 Oct 2012 11:19] MySQL Verification Team
Thank you for the bug report. I can't repeat with version 5.2.44. Thanks.
[3 Oct 2012 11:23] MySQL Verification Team
Sorry I had missed the // comment before. I was able to repeat with 5.2.44 too.
[5 Oct 2012 9:21] David Cimadevilla
I guess I have same problem here. Just installed 5.2.44 in ubuntu 12.04 + gnome3 and moving mouse over the last action output shows nothing. However, moving the mouse over previous output messages does properly show the messages as expected.

It seems to be the typical bounds checking bug such as "if i < count" instead of "if i <= count" with indexes starting at 1.
[22 Nov 2012 13:27] Mike Lischke
Error reporting in editors has always been via tooltips. Hover your mouse over the marked word(s) and a tooltip shows up that contains the error message.

However, it seems this is broken, at least on some platforms, so it needs a check.
[28 Dec 2012 9:05] Philip Olson
Fixed as of 5.2.45, and here's the changelog entry:

An error tooltip would sometimes fail to be displayed while hovering
the mouse pointer over an error marker in the SQL editor.

Thank you for the bug report.