现象:
[@more@]SQL> select * from bundle
2 where deactivate_date >= to_date('1000-01-01','yyyy-mm-dd') AND deactivate_date < null;
no rows selected
SQL> select * from bundle
2 where deactivate_date <= to_date('3000-01-01','yyyy-mm-dd') AND deactivate_date > null;
no rows selected
SQL> select * from bundle
2 where deactivate_date <= to_date('3000-01-01','yyyy-mm-dd') AND deactivate_date >= to_date('1000-01-01','yyyy-mm-dd');
1112 rows selected.
结论:
NULL 是不可比较的,如果把对NULL的比较放在条件里,那么该条件返回FALSE。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20294/viewspace-975787/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20294/viewspace-975787/