Bug #5775 NULL value is not displayed as NULL in the result area
Submitted: 27 Sep 2004 19:37 Modified: 25 Aug 2005 10:33
Reporter: Shuichi Tamagawa Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.7-beta OS:Microsoft Windows (Win XP / SP1)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[27 Sep 2004 19:37] Shuichi Tamagawa
Description:
NULL value is not displayed as blank instead of NULL in the result area while it is displayed as NULL in mysql client.

How to repeat:
CREATE TABLE t1(a CHAR(1));
INSERT INTO t1 VALUES(NULL),('');

and execute SELECT * FROM t1 from both QB and mysql client.

Suggested fix:
It should be displayed as NULL.
[27 Sep 2004 19:39] Shuichi Tamagawa
Correction:
"NULL value is not displayed as blank instead of NULL" -> "NULL value IS displayed as blank instead of NULL"
[15 Nov 2004 10:30] Michael G. Zinner
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html
[25 Aug 2005 10:33] Vladimir Kolesnikov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

it works ok in the version GA 1.1.13 (windows)