Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <sinisa@stripped> writes:
Sinisa> On Wed, 05 Dec 2001 11:39:35 +0200
Sinisa> Alexander Keremidarski <salle@stripped> wrote:
>> Hi,
>> I have following scenario:
>> Replication with both master and slave running MySQL 4.00
>> Update script which uses following sequence of statements
>>
>> 1. select @min_time:=min(time_col) + interval 1 hour from table1;
>> 2. insert into table2 select .... from table1 where time_col < @min_time;
>> 3. delete from table1 where time_col < @min_time;
<cut>
Sinisa> Proper replication of queries with user variables is still in the works.
This is documented in the 'Replication Features and Known Problems'
manual section.
This is targeted to be fixed in the 4.0 release tree.
Regards,
Monty