weird behavior of mysql 4.0.16 for pc linux

[Ginger Cheng]

Hello, MySQL Gurus,
        I am just wondering if anyone has seen this before querying an innoDB table:
select count(*) from Table where field1=3;
returned 782 rows
select count(*) from Table where field1=3 and field2 is not null;
returned 666 rows
Here comes the shocking part:
        select count(*) from Table where field1=3 and field2 is null;
        returned 1 row
If I do sth like
select count(*) from Table where field1=3 and (field2 is not null or field2 
is null);
returned 782 rows

	I just don't know what is going on. I tried different connection, 
different login but still the same. Could anyone give me some clue.
	Thanks a lot
	ginger

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]