代码: 全选
CREATE TABLE `t1` (
`id` int(11) NOT NULL auto_increment,
`balance_dt` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `t1` VALUES ('1', null);
INSERT INTO `t1` VALUES ('2', '2008-01-13 15:48:19');
INSERT INTO `t1` VALUES ('3', '2008-01-15 15:48:19');
INSERT INTO `t1` VALUES ('4', null);
版本号: Server version: 5.0.45-Debian_1ubuntu3.3-log Debian etch distribution
代码: 全选
select * from t1 where date(balance_dt) >= date('2007-1-14');
Empty set (0.00 sec)
代码: 全选
select * from t1 where balance_dt is not null and date(balance_dt) >= date('2007-1-14');
+----+---------------------+
| id | balance_dt |
+----+---------------------+
| 2 | 2008-01-13 15:48:19 |
| 3 | 2008-01-15 15:48:19 |
+----+---------------------+
2 rows in set (0.00 sec)
http://bugs.mysql.com/bug.php?id=32291
不知道各位高手有什么解决方案, 另外, Ubuntu server 版应该是很稳定的版本才对, 为什么这个Bug 是 2007 年的, 但是现在预装的 mysql 版本还没被这个BUG. 简直不可思议