Bug #36201 Tables with 'join' in the name cause MySql Query Browser to crash
Submitted: 18 Apr 2008 9:12 Modified: 26 May 2009 13:15
Reporter: John Yorke Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.12 OS:Linux (SLED 10)
Assigned to: CPU Architecture:Any

[18 Apr 2008 9:12] John Yorke 
Description:
When I try to do a select query in MySQL Query Browser on a table with 'join' in the name MySQL Query Browser crashes when the Execute button is clicked.    

How to repeat:
The table doesn't need to exist.  Typing "select * from my_joint" in the query area and clicking execute will crash the application.
[18 Apr 2008 10:00] Susanne Ebrecht 
Many thanks for writing a bug report.

What MySQL version do you use?
[19 Apr 2008 4:32] John Yorke 
I am on MySQL 5.0.26 on SLES 10.
[20 Apr 2008 1:01] MySQL Verification Team 
Thank you for the bug report.
[26 Jun 2008 19:10] Bob Dankert 
This bug is driving me nuts - working on a large data project I have had to rename tons of tables, consequently updating tons of scripts, due to this bug..  Any plans on fising this?
[26 Jun 2008 23:03] John Yorke 
Based on how the bug list is growing and no new releases seem to be coming out I would say the answer is "no".  It seems all the development is on MySQL Workbench which will "replace" Query Browser.
[10 Mar 2009 23:10] Morgan Christiansson 
This bug is easily reproduced by executing the following (invalid SQL):

SELECT FROM _JOIN
[26 May 2009 13:15] Susanne Ebrecht 
Many thanks for writing a bug report. 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/