left join where not_null_datetime is null fails

>Description: When performing a left join with a table including a non-null datetime column, saying "where a.non_null_datetime is null" always returns the empty set. It works if the column is either not non-null or not datetime. This used to work (on 3.22.32). >How-To-Repeat: cre

Dual Xeon EM64T fedora3 x86_64

Hello, I just installed MySQL-server-4.0.23-0.x86_64.rpm on Dual Xeon 3.2 64 bit 8G of RAM with Fedora3 x86_64. I noticed (doing a ps ax|grep mysql) that there is only one mysqld process running. Is this normal? BR Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq