-- Setup GR with 3 nodes - pls see setup steps/conf files etc in the
attached file 82505.results of Bug #82505 

-- node 1

node1>use test;
Database changed
node1>drop table if exists t3;
Query OK, 0 rows affected, 1 warning (0.00 sec)

node1>CREATE TABLE `t3` (
    ->   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    ->   `balance` bigint(20),
    ->   `name2` varchar(100),
    ->   `name3` varchar(100),
    ->   `name4` varchar(100),
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=innodb;

Query OK, 0 rows affected (0.01 sec)

node1>
node1>set @id:=0;
Query OK, 0 rows affected (0.00 sec)

node1>
node1> insert into `t3` values
    ->   (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> ,  (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> , (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> , (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));

 insert into `t3`(`id`,`balance`,`name2`,`name3`,`name4`)
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

node1>
node1> insert into `t3`(`id`,`balance`,`name2`,`name3`,`name4`)
    ->    select  @id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)  from
    ->     `t3` k1, `t3` k2, `t3` k3, `t3` k4,`t3` k5,`t3` k6, `t3` k7, `t3` k8, `t3` k9,
    -> `t3` k0,`t3` ka, `t3` kb, `t3` kc, `t3` kd limit  1500000;
Query OK, 1500000 rows affected (48.15 sec)
Records: 1500000  Duplicates: 0  Warnings: 0

node1>create database if not exists test;
Query OK, 1 row affected, 1 warning (0.00 sec)

node1>use test;
Database changed
node1>drop table if exists t4;
Query OK, 0 rows affected, 1 warning (0.00 sec)

node1>CREATE TABLE `t4` (
    ->   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    ->   `balance` bigint(20),
    ->   `name2` varchar(100),
    ->   `name3` varchar(100),
    ->   `name4` varchar(100),
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=innodb;

Query OK, 0 rows affected (0.01 sec)

node1>
node1>set @id:=0;
Query OK, 0 rows affected (0.00 sec)

node1>
node1> insert into `t4` values
    ->   (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> ,  (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> , (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> , (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

node1>
node1> insert into `t4`(`id`,`balance`,`name2`,`name3`,`name4`)
    ->    select  @id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)  from
    ->     `t4` k1, `t4` k2, `t4` k3, `t4` k4,`t4` k5,`t4` k6, `t4` k7, `t4` k8, `t4` k9,
    -> `t4` k0,`t4` ka, `t4` kb, `t4` kc, `t4` kd limit  1500000;
Query OK, 1500000 rows affected (46.66 sec)
Records: 1500000  Duplicates: 0  Warnings: 0

node1>begin;
Query OK, 0 rows affected (0.00 sec)

node1>update t3 set balance=1000;
Query OK, 1500003 rows affected (25.16 sec)
Rows matched: 1500004  Changed: 1500003  Warnings: 0

node1>update t4 set balance=1000;
Query OK, 1500003 rows affected (25.54 sec)
Rows matched: 1500004  Changed: 1500003  Warnings: 0

node1>commit;
Query OK, 0 rows affected (9.83 sec)

-- Goto node2 and update - update t4 set balance=200 where id>1000000 and id < 1000100;

node1>select balance from t4 where id>1000000 and id < 1000100;
+---------+
| balance |
+---------+
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
|     200 |
+---------+
50 rows in set (0.34 sec)


-- node 2

node2>use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
node2>update t4 set balance=200 where id>1000000 and id < 1000100;
Query OK, 50 rows affected (0.01 sec)
Rows matched: 50  Changed: 50  Warnings: 0

node2>select balance from t4 where id>1000000 and id < 1000100;
+---------+
| balance |
+---------+
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
|    1000 |
+---------+
50 rows in set (0.01 sec)

node2>