| 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: | |
| Category: | MySQL Query Browser | Severity: | S3 (Non-critical) |
| Version: | 1.0.7-beta | OS: | Windows (Win XP / SP1) |
| Assigned to: | Vladimir Kolesnikov | CPU Architecture: | Any |
[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)
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.