Bug #15251 Mysqld crash when doing multi-table update
Submitted: 25 Nov 2005 18:32 Modified: 26 Dec 2005 10:51
Reporter: Salvatore Sorrentino Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.16 OS:MacOS (Mac OS X)
Assigned to: Bugs System CPU Architecture:Any

[25 Nov 2005 18:32] Salvatore Sorrentino 
Description:
Mysql crashes when doing a multi-table update. Only crashes when the update produces results.

How to repeat:
update t1, t2, t3 set t1.a = 1, t2.b = 1 where t1.id = t3.id and t2.id2 = t1.id2

exact query looks something like this

update fleet_data a, deduction b, vendor c
 set a.payable_id = 123
 ,b.reconciliation_id = 123
 where a.payable_id = 0 and a.date >= '2005-11-22' 
 and a.date < '2005-11-23'
 and b.deduction_id = a.deduction_id 
 and c.user_id = b.vendor_id  
 and a.payable_id = 0 
 and if(b.branch_id = 0 , c.branch_id, b.branch_id) = 12345
[25 Nov 2005 18:34] Salvatore Sorrentino 
crash dump file

Attachment: mysqld.crash.log.zip (application/zip, text), 12.82 KiB.
[26 Nov 2005 10:51] Jorge del Conde 
Hi!

Can you please post the CREATE TABLE statments so that we can execute the queries that you posted ?

Thanks!
[21 Dec 2005 4:04] Michael Yudin 
I am also experiencing this bug with MySql 5.0.17 on Linux RedHat ES 3. 
Here is the query that crashes the server:

UPDATE vsem.adwords, tmp_rptgoogle SET vsem.adwords.KWID = tmp_rptgoogle.KWID WHERE vsem.adwords.SID=tmp_rptgoogle.SID AND tmp_rptgoogle.KWID != 0;
[27 Dec 2005 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".