Bug #24134 | deal the query against to NULL value and the blank string by different way | ||
---|---|---|---|
Submitted: | 9 Nov 2006 10:03 | Modified: | 10 Nov 2006 12:24 |
Reporter: | ming lu | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.19 | OS: | Windows (windows) |
Assigned to: | CPU Architecture: | Any |
[9 Nov 2006 10:03]
ming lu
[9 Nov 2006 10:49]
MySQL Verification Team
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php mysql> select * from t1 where name IS NULL; +----+------+ | jd | name | +----+------+ | 5 | NULL | | 6 | NULL | +----+------+ 2 rows in set (0.00 sec)
[10 Nov 2006 8:17]
ming lu
select * from t1 where name<>'' +----+-------+ | jd | name | +----+-------+ | 1 | name1 | | 2 | name2 | +----+-------+ Why don't the result include the NULL value like this: +----+-------+ | jd | name | +----+-------+ | 1 | name1 | | 2 | name2 | | 5 | NULL | | 6 | NULL | +----+-------+
[10 Nov 2006 12:24]
MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL.