Martin,
this bug in multi-table UPDATE on InnoDB tables was reported 3 weeks ago and
Sinisa has fixed it to upcoming 4.0.11.
Regards,
Heikki
Innobase Oy
sql query
..
Subject: Bug? Update on 3 tables crashes in InnoDB
From: Martin Thoma
Date: Mon, 17 Feb 2003 11:57:12 +0100
Can somebody confirm this please?
Martin
Subject: UPDATE over 3 tables crashes in InnoDB
Description:
I have 3 InnoDB-tables with about 6000 records each:
customer 1:n orders 1:n invoices
When trying to make the following update:
update customer, orders, invoice