Replication problem

[Terry Riley]

We are running 4.1.13 standard on Linux as a master, and 4.1.14 on NT4 
as a slave.

Replication seems to work extremely well, except in the following 
circumstance.

On the master server, running a query similar to:

insert into zmast.leagueinfo
(countieslist, defaultleaguecode, leaguename .......)
select
countieslist, 'DDLS2005', leaguename ......
from zmast.leagueinfo
where defaultleaguecode='ddls2004'.

using the same table as source and target, with the only changes being 
the defaultleaguecode and the autoincrement ID field, without any problem.

However, this does not seem to replicate to the slave, and no error shows  
until later when an attempt is made to insert a record into a table where 
a relationship to this record is required ('Cannot update child 
record'-type message).

The manual that I have does specify that "currently you cannot insert into 
a table and select from the same table in a subquery." Clearly this is not 
actually the case, but for some reason, it will not replicate.

Anyone else had/got this problem?

Is there a sensible solution - the only one I can come up with is changing 
the intitial 'insert ... select' into a 'create table temp select 
from...'/'insert ... select from temp'/ 'drop table temp' set.

This insert ... select stuff is not done on a regular basis, and then only 
by an administrator.

Ideas welcome........

Cheers
Terry