We have found a bug in MySQL 4.1 (tested on Win2k machine):
create database testdate;
use testdate;
create table a (id int not null auto_increment, dt date, primary key(id));
insert into a (dt) values ('');
insert into a (dt) values ('2004-05-06');
select * from a where dt = '';
Pre Mysql 4.1
id dt
-- ----------
1 0000-00-00
1 Row(s) affected
Mysql 4.1
id dt
-- ----------
0 Row(s) affected
When is MySQL 4.1 planned for production release?
Regards
Bent Audun Hesvik
Software engineer
----------------------------------------------------------------------
it:solutions, O. J. Brochs gate 16B, P.B. 2686 Møhlenpris, N-5836 Bergen,
Norway
+47 55 23 60 96 (office)
+47 95 77 03 29 (cellular phone)
+47 55 23 60 71 (fax)
[EMAIL PROTECTED]
Subscribe to the it:solutions newsletter at http://www.itsolutions.no
----------------------------------------------------------------------
CONFIDENTIALITY NOTICE:
The content of this e-mail is intended solely for the use of the individual
or entity to whom it is addressed. If you have received this communication
in error, be aware that forwarding it, copying it or in any way disclosing
its content to any other person, is strictly prohibited. If you have
received this communication in error, please notify the author by replying
to this e-mail immediately.
http://www.itsolutions.no
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.651 / Virus Database: 417 - Release Date: 05.04.2004
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
