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


create database if not exists test;
use test;
drop table if exists t3;
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;

set @id:=0;

begin;
 insert into `t4` values (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
 insert into `t4` values (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
 -- truncate t4 on node 3
 insert into `t4` values (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
 insert into `t4` values (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
commit;


-- node 1

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

node1> insert into `t4` values (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
Query OK, 1 row affected (0.00 sec)

node1> insert into `t4` values (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
Query OK, 1 row affected (0.00 sec)

node1> -- truncate on session 2
node1>
node1> insert into `t4` values (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
Query OK, 1 row affected (0.00 sec)

node1> insert into `t4` values (@id:=@id+1,@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
Query OK, 1 row affected (0.00 sec)

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

node1>select * from t4;
Empty set (0.00 sec)


-- node 2, node 3

node2>truncate t4;
Query OK, 0 rows affected (0.00 sec)

node2>select * from t4;
+---------+---------+----------------------------------+----------------------------------+----------------------------------+
| id      | balance | name2                            | name3                            | name4                            |
+---------+---------+----------------------------------+----------------------------------+----------------------------------+
| 3000009 | 3000010 | 63ecad8c32fe955224374cd7ba467419 | 05841e1f28fe5f3e6aea34e892471f90 | bb0bcd2f39f5022b13c39bef629c0b22 |
| 3000011 | 3000012 | b50850c20631df11bd8018e029a452e6 | 8ed5564c83aad1d73b34b766d09e519c | 5279ceba2a7ba06913e6298a27595f21 |
| 3000013 | 3000014 | a8e738038cc3f235db5a7edae61da7dd | b72755e4767c3d7d9d7a7b2904593dba | 5a235153360fdc70b391964db65d2862 |
| 3000015 | 3000016 | 32682be07ce04ad1c468fd2308a716af | 6036d16119b5d80dc2d365334db2194d | 8e6c335483f215ed437c3c173f164969 |
+---------+---------+----------------------------------+----------------------------------+----------------------------------+
4 rows in set (0.00 sec)

node3>select * from t4;
+---------+---------+----------------------------------+----------------------------------+----------------------------------+
| id      | balance | name2                            | name3                            | name4                            |
+---------+---------+----------------------------------+----------------------------------+----------------------------------+
| 3000009 | 3000010 | 63ecad8c32fe955224374cd7ba467419 | 05841e1f28fe5f3e6aea34e892471f90 | bb0bcd2f39f5022b13c39bef629c0b22 |
| 3000011 | 3000012 | b50850c20631df11bd8018e029a452e6 | 8ed5564c83aad1d73b34b766d09e519c | 5279ceba2a7ba06913e6298a27595f21 |
| 3000013 | 3000014 | a8e738038cc3f235db5a7edae61da7dd | b72755e4767c3d7d9d7a7b2904593dba | 5a235153360fdc70b391964db65d2862 |
| 3000015 | 3000016 | 32682be07ce04ad1c468fd2308a716af | 6036d16119b5d80dc2d365334db2194d | 8e6c335483f215ed437c3c173f164969 |
+---------+---------+----------------------------------+----------------------------------+----------------------------------+
4 rows in set (0.00 sec)