Bug #67114 NULL values not shown in first column of result set
Submitted: 6 Oct 2012 16:38 Modified: 12 Jun 2013 5:40
Reporter: Gary Trachier Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S1 (Critical)
Version:5.2.45 OS:MacOS (OS X v10.7.5)
Assigned to: CPU Architecture:Any
Tags: null, Result Set

[6 Oct 2012 16:38] Gary Trachier
NULL values are not being displayed in first column of a result set.  This bug also present in v5.2.43 .

While I would not normally categorize this as "critical", by the reporting guidelines, that's the category when there is no work-around.

How to repeat:
Sample query:

select `tmpl_hartland`, `tmpl_hartland` from `columnsCrossRef`;

NULL values in the first column show up as empty cells.  The same NULL values in the second column appear with the normal "NULL" graphic.
[6 Oct 2012 22:57] MySQL Verification Team
Thank you for the bug report. Please provide a screen-shot and the create table script for the ofended table. Thanks.
[7 Nov 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[7 Nov 2012 1:16] Gary Trachier
I e-mailed the requested information on 6 October, so this bug should remain open.
[22 Jan 2013 13:11] MySQL Verification Team
Verified on MacBook Pro Mountain Lion.
[12 Jun 2013 5:40] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.x release, and here's the changelog entry:

"´╗┐NULL" values were not being displayed in the first column of a result
set, and were instead being displayed as empty cells.

Thank you for the bug report.
[13 Jun 2013 6:21] Philip Olson
Related bug: Oracle Bug #11765064 / MySQL Bug #57983