hello,
i wanted to setup a new mysql database slave running a newer version of mysql => 5.1.41 than the master => 5.0.75, which -- as far as i know -- should normally be no problem. however, as it turns out setting up replication fails, because i used a SQL statement in 5.0.75 which apparently does not work in 5.1.41 anylonger:
the statement which causes the trouble looks like:
DELETE FROM tab1 t1
USING tab1 t1, tab2 t2
WHERE t2.field1 = ...
AND t2.field2 = ...
AND t1.field1 = t2.field2;
this statements runs perfectly on 5.0.75, on 5.1.41 i get the following error message in my slave status:
...
Last_SQL_Errno: 1064
Last_SQL_Error: Error 'You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to
use near 't1
USING tab1 t1, tab2 t2
...
...
any ideas, what's going on and what to do?
thanks!
UPDATE
ok, i solved this problem by compiling 5.0.75 on the slave myself ... however, i would still be interested, what's going on and how to deal with such problems. thanks.