Thank you for your report.
We shall take a look at it.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www
OK, I sent in something I hope will be useful.
# PROBLEM SUMMARY ###
Two problems seen with multi-table delete:
1) After a multi-table delete, first query of the second table
referenced in
the delete results in ERROR 1032. Subsequent queries are fine. Happens
with
BDB and InnoDB.
hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Becky McElroy writes:
>> Two questions regarding multi-table operations:
>>
>> 1) I've got multi-table delete working with a couple of BDB tables,
>> where it's properly deleting from one or both tables, and all
>> po
Becky McElroy writes:
> Thank you for your response and the info.
>
> Actually I was using 4.0.1 which I downloaded a couple of days ago:
>
> [beckymcelroy@indigo bhm]$ rpm -qa | grep SQL
> MySQL-Max-4.0.1-2
> MySQL-client-4.0.1-2
> MySQL-4.0.1-2
> [beckymcelroy@indigo bhm]$
>
[skip]
> --
> B
Thank you for your response and the info.
Actually I was using 4.0.1 which I downloaded a couple of days ago:
[beckymcelroy@indigo bhm]$ rpm -qa | grep SQL
MySQL-Max-4.0.1-2
MySQL-client-4.0.1-2
MySQL-4.0.1-2
[beckymcelroy@indigo bhm]$
Here's what I did:
mysql>
mysql> select * from cnam1;
+---
Becky McElroy writes:
> Two questions regarding multi-table operations:
>
> 1) I've got multi-table delete working with a couple of BDB tables,
> where it's properly deleting from one or both tables, and all
> possibilities of the delete criteria are being exersized. After the
> multi-table dele
