I just filed bug #22317 about this. The following script fails to
return a row under 4.1.21 (on x86_64, anyway), but works correctly on
4.1.20 (and .18):
drop table if exists test1;
create table test1
(
datetimeval datetime,
dateval1 date,
dateval2 date
);
insert into test1
(datetimeval, dateval1, dateval2)
values
('2006-09-13 08:47:32', '2006-01-01', '2007-01-01');
select datetimeval
from test1
where datetimeval between dateval1 and dateval2;
If datetimeval is cast to a date in the where clause, the row is
returned in both versions.
--Pete
----------------------------------
Pete Harlan
ArtSelect, Inc.
[EMAIL PROTECTED]
http://www.artselect.com
ArtSelect is a subsidiary of a21, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
