1insert into tt (id) values (1),(2),(3) on duplicate key update x = 0;
2insert into tt (id) values (1) on duplicate key update y = 0, z = 42;
3insert into tt (id) values (1) on duplicate key update y = y + 1, z = z + 50;
4insert into tt (id) values (1) on duplicate key update y = y - 1;
5insert into tt (id) values (1) on duplicate key update z = z - 50;
6
7create table ti like tt;
8alter table ti engine=innodb;
9insert into ti (id) values (1),(2),(3) on duplicate key update x = 0;
10insert into ti (id) values (1) on duplicate key update y = 0, z = 42;
11insert into ti (id) values (1) on duplicate key update y = y + 1, z = z + 50;
12insert into ti (id) values (1) on duplicate key update y = y - 1;
13insert into ti (id) values (1) on duplicate key update z = z - 50;
14
15let $diff_tables = test.tt, test.ti;
16source include/diff_tables.inc;
17
18drop table tt, ti;
19
20