Bug #32494 Strange behaviour in counting rows part two
| Submitted: | 19 Nov 2007 14:39 | Modified: | 19 Nov 2007 18:33 |
|---|---|---|---|
| Reporter: | Anton Dischner | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
| Version: | 5.0.45 | OS: | Linux (SLES9 SP3) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | count(*), curdate, date, null, SELECT | ||
[19 Nov 2007 18:33]
Valeriy Kravchuk
Sorry, but this is a duplicate of bug #31709. This is a known bug (I still can repeat it on 5.0.45) that is already fixed in current sources.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: selecting count(*) from a tables produces different results How to repeat: create table ttt (datumsfeld date); insert into ttt values (curdate()); insert into ttt values (null); insert into ttt values ('2007-01-01'); select * from ttt; +------------+ | datumsfeld | +------------+ | 2007-11-19 | | NULL | | 2007-01-01 | +------------+ select count(*) from ttt where date(datumsfeld) < curdate() and datumsfeld is not null; +----------+ | count(*) | +----------+ | 0 | +----------+ This is wrong select count(*) from ttt where datumsfeld is not null and date(datumsfeld) < curdate(); +----------+ | count(*) | +----------+ | 1 | +----------+ This is correct