> 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
./ premax@stripped
./ koniec i bomba, a kto czytal ten traba. w.g.
