Bug #59315 Kill Query SQL Error 1064
Submitted: 5 Jan 2011 18:53 Modified: 11 Mar 2011 17:18
Reporter: Don Lewis Email Updates:
Status: Closed Impact on me:
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
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'
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