> I'm executing on master a long and complicated query such:
> UPDATE (lots of tables, lots of LEFT JOIN) SET ... WHERE .
Okey, I simplified the query to:
-----
UPDATE
tKsidata,
tKsiabeksiazki
SET
tKsidata.STAN_REALNY=tKsiabeksiazki.STAN
WHERE
tKsidata.ksi='0815120877' and
tKsidata.KSI=tKsiabeksiazki.KSI
-----
This query shows up in both master's and slave's log, but it DOES NOT
execute on slave. Table tKsidata on slave remains unmodified.
Executing the query manually works perfectly on slave.
Is seems that multi-table update badly replicates in MySQL 4.1.
./ premax
./ [EMAIL PROTECTED]
./ koniec i bomba, a kto czytal ten traba. w.g.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
