Bug #59315 Kill Query SQL Error 1064

• Submitted: 5 Jan 2011 18:53
• Modified: 11 Mar 2011 17:18
• Reporter: Don Lewis
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 5.2.31
• OS: Linux (Ubuntu 10.10 64 bit)
• Assigned to: Alfredo Kojima
• CPU Architecture: Any

[5 Jan 2011 18:53] Don Lewis

Description:
Mysql Workbench, Admin, Connections. Select a line and click the"Kill Query" button. Error Unhandled exception: Error executing KILL QUERY: Error executing 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1'
KILL QUERY .
SQL Error: 1064

Also get this from the "Kill Connection" Button. 
Downloaded from mysql site: mysql-workbench-gpl-5.2.25-1ubu1004-amd64.deb
Connecting to mysql version 5.0.44 enterprise on Centos 2.6.18-8.el5

How to repeat:
Every time I select this feature I get the error. 

Suggested fix:
Fix the query workbench is using.

[5 Jan 2011 19:10] Valeriy Kravchuk

What exact version of Workbench do you use, 5.2.25 or 5.2.31 (the latest)? I do not see this problem with 5.2.31.

[4 Feb 2011 10:47] charl retief

I am experiencing the same problem.

I started to notice the problem after I switched to MySQL server version 5.5.8.
I am using WB 5.2.31 AND Ubuntu 10.10 64bit.

[4 Feb 2011 12:02] charl retief

I can confirm this bug. 

It started after I switched to MySQL 5.5.8
I am using WB 5.2.31 under Ubuntu 10.10 64bit.

[8 Feb 2011 15:35] Alfredo Kojima

Repeated with MySQL 5.5.8

[11 Mar 2011 17:18] Johannes Taxacher

fix confirmed in release