Bug #13670 4.1.10 win32 server still crash upon delete with table-qualified 'order by'
Submitted: 30 Sep 2005 20:34 Modified: 30 Sep 2005 20:49
Reporter: Quartz 12h Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.10 OS:Windows (win xp)
Assigned to: MySQL Verification Team CPU Architecture:Any

[30 Sep 2005 20:34] Quartz 12h
Description:
delete from raw_session_tb 
where raw_session_tb.end_time<0 and raw_session_tb.completion!=0 
order by raw_session_tb.end_time desc  limit 4000

this is exactly bug 
http://bugs.mysql.com/bug.php?id=8392

but is does still exist in 4.1.10.

How to repeat:
see bug #8392

Suggested fix:
change your statements.
[30 Sep 2005 20:49] MySQL Verification Team
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.14-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE TABLE `foo` (
    ->   `LOGID` int(10) unsigned NOT NULL auto_increment,
    ->   `MID` int(10) unsigned NOT NULL default '0',
    ->   `Datum` timestamp(10) NOT NULL,
    ->   `Query` blob NOT NULL,
    ->   PRIMARY KEY  (`LOGID`)
    -> );
Query OK, 0 rows affected (0.09 sec)

mysql> DELETE from foo WHERE LOGID > 0 ORDER BY foo.LOGID;
Query OK, 0 rows affected (0.00 sec)