Bug #33196 Cannot display binary data
Submitted: 13 Dec 2007 3:53 Modified: 15 Oct 2009 12:26
Reporter: Diego Medina Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.12 OS:Windows (Fedora 7/Windows)
Assigned to: CPU Architecture:Any
Tags: CHECKED

[13 Dec 2007 3:53] Diego Medina 
Description:
After executing a Select statement, I get an error: "Commands out of sync: you can't run this query now"
But from the mysql command line client I get no errors.

How to repeat:
Create table

[code]
CREATE TABLE `t1` (
  `data` binary(4) NOT NULL
) ENGINE=MyISAM

[/code]

Insert this value
[code]
insert into t1 values (b'111111111111') 
[/code]
or this one
[code]
insert into t1 values (x'FFFFFFFFFFFFFF') 
[/code]

Then run 
[code]
SELECT * FROM t1 t LIMIT 0,100
[/code]
and you will get the error.
[16 Dec 2007 4:04] MySQL Verification Team 
Thank you for the bug report. The Windows version presents that error message
too.
[15 Oct 2009 12:26] 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. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/