Bug #54503 SQL Query Results incorrectly shows 'BLOB' for null varbinary fields

• Submitted: 14 Jun 2010 22:52
• Modified: 15 Jun 2010 5:01
• Reporter: Nathan Moon
• Status: Can't repeat
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2
• OS: MacOS
• CPU Architecture: Any

[14 Jun 2010 22:52] Nathan Moon

Description:
In query results, NULL varbinary values are incorrectly displayed as 'BLOB' instead of 'NULL'. There is no way to tell if a varbinary value is NULL or not.

I'm not sure if this is only Mac OS X, that is the only platform I have run Workbench on, so I'm reporting it as OS X.

How to repeat:
Run the following in the SQL Query view:

create table with_varbinary
(
id INTEGER PRIMARY KEY,
bin VARBINARY(16),
text VARCHAR(16)
) ENGINE=InnoDB;

insert into with_varbinary(id, bin) values (1, 'abc');
insert into with_varbinary(id, text) values (2, 'abc');

select * from with_varbinary;

The results will display with both rows showing 'BLOB' for the bin column, instead of showing row 2 having a value of 'NULL'.

Suggested fix:
show the 'NULL' image instead of the 'BLOB' image for null varbinary fields

[15 Jun 2010 5:01] Valeriy Kravchuk

I can not repeat this with recent version, 5.2.23. So, please, wait for it to be released officially.