On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: > After even more tracking stuff down, I managed to isolate it to a > change made in MySQL 4.0.1. ?The query in question was doing: > > ? INSERT INTO ... SELECT ... > > rather than > > ? INSERT IGNORE INTO ... SELECT ... > > MySQL 3.23.xx lets the first sneak by without errors even if there are > duplicates. ?4.0.2 does not. ?It stops. ?Since our master is 3.23 and > this particular slave is 4.0.2, the two didn't agree.
That would be a bug in 4.0.2. Can you provide a test case for it? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/?ref=mspa __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ --------------------------------------------------------------------- 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
