Ginger Cheng <[EMAIL PROTECTED]> wrote:
> 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.
It's a known bug that is already fixed:
http://bugs.mysql.com/bug.php?id=2483
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
