> The bug manifests itself in the following situation. A temporary > table has been created on the master server. A query is executed > using an alias for that temporary table. The connection is dropped > without explicitly dropping that temporary table. In the binary log, > mysql records a drop of the temporary table using the table alias. > When the replication server reads this command, it is unaware of a > table of this name and replication is dropped. > > ... > >Release: mysql-3.23.41 (Source distribution)
This bug seems to have been fixed in 3.23.46. From the change log: --- D.2.2 Changes in release 3.23.46 Fixed problem with aliased temporary tables replication --- / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php