I have a very strange problem with some indexes. It is a unique index on a column containing null data. when I do a query like
select * from xxx where yyy is null
I get only one row (the first) but I know there is more. recentely, this table switched to innodb and we changed the server. I have the same problem on all databases on this server and I think it worked before innodb and server switch. It is a mysql * 4.0.16 on a debian box. the unique index is on yyy and when I remove this index, I get the result I want.
also if I had conditions, I don't get any results.
can somebody help?
thanks for your help.
Best Regards, mo
*
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]