MySQL Forums
Forum List  »  Memory Storage Engine

Problem using DELETE on HEAP. Deletes just one row.
Posted by: Samuel Benzaquen
Date: April 07, 2005 07:26AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem using DELETE on HEAP. Deletes just one row.
5747
April 07, 2005 07:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.