Scott Wong writes:
> I'm not sure if this is a feature or not so i'll just report it as a possible bug.
> I couldnt find anything in the documentation.
>
>
> How to repeat:
>
> create table t1(id int);
> insert into t1 set id=0;
> select @a:max(id)+1 from t1;
> insert into t1 [EMAIL PROTECTED];
>
>
> Result on master:
>
> mysql> select * from t1;
> +------+
> | id |
> +------+
> | 0 |
> | 1 |
> +------+
> 2 rows in set (0.00 sec)
>
>
> result on slave:
>
> mysql> select * from t1;
> +------+
> | id |
> +------+
> | 0 |
> | NULL |
> +------+
>
> Binlog shows
> insert into t1 set [EMAIL PROTECTED];
> on both master and slave.
>
>
> Fix:?
>
> Thank you for your time,
> Scott Wong
> Meiko America, INC
>
Hi!
It is actually neither.
Replication with user variables is working only in version 4.1.
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
