Problem using DELETE on HEAP. Deletes just one row.

[Samuel Benzaquen]

Hi,

Since yesterday I'm having problem with a HEAP table.
When I do a delete like:
DELETE FROM t1 WHERE date < 'date1';
it deletes just one row (several row matches the where clause)
But, when I do it like:
DELETE FROM t1 WHERE date < 'date1' ORDER BY date;
it deletes all rows that match.


I haven't figured out what's happening.
It used to work.
I have other HEAP tables on the DB that work fine.
I have dropped and recreated the table with no change.
I have restarted the server, nothing.

Linux Fedora Core 2.
MySQL 4.1.11 from RPMs from MySQL site.

Any help?

-Samuel