List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:December 10 2001 3:29am
Subject:Re: User Variables and Replication problem
View as plain text  
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
Thread
User Variables and Replication problemAlexander Keremidarski5 Dec
  • Re: User Variables and Replication problemSinisa Milivojevic5 Dec
    • Re: User Variables and Replication problemMichael Widenius10 Dec