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)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.