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. 2) The multi-table delete itself works 100% on BDB. However, on InnoDB, ERROR 1105: Unkown error is output; the first table was 100% updated properly, the second table was partially updated. ##### ENVIRONMENT ######### The MySQL version (binary) I'm using is: mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Server version 4.0.1-alpha-Max-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Machine manufacturer & model: COMPAQ Professional Workstation AP200 My machine platform is: Red Hat Linux release 6.1 (Cartman) Kernel 2.2.12-20 on an i686 [beckymcelroy@indigo bhm]$ uname -a Linux indigo 2.2.12-20 #1 Mon Sep 27 10:40:35 EDT 1999 i686 unknown Becky Michael Widenius wrote: > 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 > >> possibilities of the delete criteria are being exersized. After the > >> multi-table delete command, I can 'select *' from the first table > >> referenced in my multi-table delete just fine, but when I do 'select *' > >> for the second table, I get > >> > >> ERROR 1032: can't find record in 'tblname' > >> > >> If I do it again, then I get the query output just fine for the second > >> table from that point on. > >> (I'm using MySQL-Max-4.0.1-2 on Red Hat linux 6.1) > >> It's looking like a bug. Has anyone else encountered this? > >> > >> 2) Does anyone know when multi-table update will be available? > >> > >> Thanks. > >> > >> -- > >> Becky McElroy > > Sinisa> Hi! > > Sinisa> Regarding the above error with BDB tables, there was a bug in 4.0.0, > Sinisa> which should have been fixed in 4.0.1. > > Becky, as you are already using 4.0.1: > > Any change you could do a test case for us so that we could repeat this > problem? This would enable us to fix this for 4.0.2 > > Regards, > Monty -- Becky McElroy --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php