\r flush tables; set global innodb_flush_log_at_trx_commit=0; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; create table t1(id smallint unsigned not null auto_increment primary key,data smallint unsigned not null,unique key(data))engine=innodb; create table t2(id smallint unsigned not null auto_increment primary key,data smallint unsigned not null,unique key(data))engine=myisam; create table t3(id smallint unsigned not null primary key,data smallint unsigned,unique(data,id))engine=innodb; create table t4(id smallint unsigned not null primary key,data smallint unsigned,unique(data,id))engine=myisam; create table t5(id smallint unsigned not null,data smallint unsigned,primary key(id,data))engine=innodb; create table t6(id smallint unsigned not null,data smallint unsigned,primary key(id,data))engine=myisam; create table t7(id smallint unsigned,data smallint,key(id,data),key(id),key(data))engine=innodb; create table t8(id smallint unsigned,data smallint,key(id,data),key(id),key(data))engine=myisam; drop table if exists innodb_lock_monitor; start transaction; insert ignore into t2(data) values (abs(-23223)%25),(abs(-15019)%25),(abs(16087)%25); update ignore t2 set data=abs(-4733)%25 where id=abs(-29732)%25; replace into t1(id,data) values (abs(9318)%25,abs(30897)%25); replace into t2(id,data) values (null,abs(-12950)%25),(null,abs(29068)%25),(abs(-29759)%25,abs(-3428)%25); insert into t2(id,data) values (abs(-30303)%25,abs(16363)%25),(abs(11432)%25,abs(13375)%25),(abs(-23537)%25,abs(29428)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-13175)%25 where data=abs(-22568)%25; insert ignore into t1(data) values (abs(-1489)%25),(abs(29792)%25),(abs(-27407)%25); insert ignore into t1(id,data) values (abs(-19721)%25,abs(-32373)%25),(null,abs(-14788)%25); insert into t1(id,data) values (abs(-5415)%25,abs(686)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(154)%25),(abs(-15132)%25),(abs(-3675)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(1163)%25; rollback; delete from t2 where id=abs(2335)%25; insert ignore into t1(id,data) values (abs(27752)%25,abs(-9928)%25),(abs(-23678)%25,abs(-6819)%25); insert into t2(id,data) values (abs(-16011)%25,abs(1827)%25),(abs(-8318)%25,abs(-21328)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(14288)%25),(null,abs(23632)%25),(abs(1737)%25,abs(7317)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (null,abs(12503)%25),(null,abs(-4835)%25),(abs(18848)%25,abs(-10973)%25); insert ignore into t1(id,data) values (abs(-28088)%25,abs(-9515)%25); update ignore t2 set data=abs(-4745)%25 where id=abs(11077)%25; start transaction; insert into t2(id,data) values (abs(15583)%25,abs(27804)%25),(null,abs(-11813)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(-29560)%25),(null,abs(-14386)%25),(abs(-21329)%25,abs(-18707)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(-17410)%25; insert ignore into t1 select * from t2 where data=abs(-32373)%25; insert ignore into t1(id,data) values (abs(20688)%25,abs(6601)%25); insert into t1(data) values (abs(-11163)%25) on duplicate key update id=values(id),data=values(data); rollback; insert ignore into t2(id,data) values (abs(31977)%25,abs(-5124)%25),(abs(3064)%25,abs(13976)%25),(abs(-5866)%25,abs(8480)%25); insert ignore into t1(id,data) values (null,abs(6751)%25),(null,abs(-15479)%25),(abs(-4179)%25,abs(21175)%25); insert into t2(data) values (abs(25135)%25),(abs(-5868)%25),(abs(-17576)%25) on duplicate key update id=values(id),data=values(data); rollback; insert ignore into t2(data) values (abs(-6461)%25),(abs(-11088)%25); insert ignore into t2(id,data) values (abs(-1077)%25,abs(-2939)%25); start transaction; insert into t1(id,data) values (abs(-7778)%25,abs(27026)%25),(null,abs(-4336)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(22759)%25,abs(17653)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(12399)%25,abs(-4178)%25),(abs(-24238)%25,abs(748)%25),(abs(-27567)%25,abs(-31670)%25); start transaction; delete from t1 where data=abs(30408)%25; insert into t1(id,data) values (abs(-21833)%25,abs(-17711)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-1088)%25,abs(6709)%25); insert ignore into t2 select * from t1 where id=abs(17432)%25; insert ignore into t1(id,data) values (abs(-30605)%25,abs(13007)%25); insert ignore into t1(id,data) values (null,abs(-20963)%25),(null,abs(-13310)%25),(abs(-12076)%25,abs(-9478)%25); insert ignore into t1(id,data) values (abs(-29938)%25,abs(-9303)%25),(null,abs(28576)%25); replace into t1 select * from t2 where id=abs(5150)%25; insert ignore into t2(id,data) values (abs(14772)%25,abs(9767)%25),(null,abs(-24383)%25); start transaction; start transaction; replace into t1(id,data) values (abs(-8841)%25,abs(-15368)%25); update ignore t1 set data=abs(27802)%25 where data=abs(-25343)%25; replace into t1 select * from t2 where id=abs(9856)%25; insert into t1(id,data) values (null,abs(-6978)%25),(null,abs(-20005)%25),(abs(-28930)%25,abs(9189)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(31855)%25),(abs(-3470)%25); insert into t2(id,data) values (abs(-7691)%25,abs(-17399)%25),(abs(15381)%25,abs(-14307)%25),(abs(-32588)%25,abs(6946)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(-14975)%25 where id=abs(-32462)%25; commit; insert into t2(data) values (abs(-9645)%25),(abs(18623)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-10496)%25; insert into t1(id,data) values (abs(-31519)%25,abs(25968)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(10345)%25 where data=abs(-6731)%25; replace into t1(id,data) values (null,abs(8586)%25),(null,abs(-18263)%25),(abs(28819)%25,abs(-3200)%25); update ignore t2 set id=abs(6291)%25,data=abs(-543)%25 where id=abs(6332)%25; replace into t2(id,data) values (null,abs(23912)%25),(null,abs(21487)%25),(abs(-26453)%25,abs(22990)%25); start transaction; insert ignore into t2(id,data) values (abs(23551)%25,abs(22155)%25),(null,abs(31762)%25); insert into t2(data) values (abs(14662)%25),(abs(-2618)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(4789)%25); start transaction; insert into t2(id,data) values (abs(12711)%25,abs(22648)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-18121)%25,abs(19136)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(24778)%25,data=abs(22468)%25 where data=abs(4201)%25; rollback; insert into t1(id,data) values (abs(22495)%25,abs(4177)%25) on duplicate key update id=values(id),data=values(data); rollback; commit; replace into t1(id,data) values (null,abs(2078)%25),(null,abs(-6226)%25),(abs(-7043)%25,abs(-4311)%25); insert into t1(id,data) values (abs(-23479)%25,abs(6209)%25) on duplicate key update id=values(id),data=values(data); start transaction; rollback; insert into t2(id,data) values (abs(-3685)%25,abs(11772)%25),(abs(-1787)%25,abs(-3059)%25),(abs(21372)%25,abs(12058)%25) on duplicate key update id=values(id),data=values(data); commit; rollback; insert into t1(id,data) values (abs(2524)%25,abs(30572)%25),(abs(16494)%25,abs(-3554)%25),(abs(15393)%25,abs(-17792)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(32502)%25,abs(31996)%25),(null,abs(16902)%25); replace into t1 select * from t2 where data=abs(-28190)%25; insert ignore into t2(id,data) values (abs(19715)%25,abs(15877)%25); start transaction; update ignore t1 set id=abs(26188)%25,data=abs(-12842)%25 where id=abs(-16813)%25; insert ignore into t1(id,data) values (abs(-29538)%25,abs(-5483)%25),(abs(-20741)%25,abs(-15998)%25); insert into t2(id,data) values (null,abs(-17271)%25),(null,abs(-23043)%25),(abs(-31821)%25,abs(11258)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-22305)%25,abs(-857)%25); insert into t2(id,data) values (abs(2637)%25,abs(-19015)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-27158)%25); replace into t2 select * from t1 where data=abs(17941)%25; insert ignore into t2 select * from t1 where data=abs(13672)%25; insert into t1(data) values (abs(-434)%25),(abs(-2361)%25),(abs(373)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-11220)%25),(abs(16204)%25),(abs(-21089)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(data) values (abs(7676)%25),(abs(-31074)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(-30048)%25),(null,abs(6643)%25),(abs(30219)%25,abs(29387)%25); start transaction; insert ignore into t1(data) values (abs(-14579)%25),(abs(-17300)%25),(abs(-10118)%25); insert ignore into t1(data) values (abs(10478)%25); insert into t1(id,data) values (abs(31721)%25,abs(-30455)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(1144)%25,abs(-6908)%25); replace into t1(id,data) values (abs(-22008)%25,abs(20597)%25),(null,abs(-25253)%25); insert into t2(data) values (abs(21979)%25),(abs(9898)%25),(abs(12135)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-7748)%25 where data=abs(-22562)%25; insert into t1(id,data) values (abs(-13321)%25,abs(-18580)%25) on duplicate key update id=values(id),data=values(data); replace into t2 select * from t1 where id=abs(-29316)%25; delete from t2 where id=abs(14144)%25; insert into t1(data) values (abs(-30683)%25),(abs(-5150)%25),(abs(-7150)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(data) values (abs(-5609)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-2408)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-3558)%25,abs(-32450)%25),(abs(-19136)%25,abs(19177)%25),(abs(-19337)%25,abs(10592)%25); insert into t1(id,data) values (abs(-25220)%25,abs(24219)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(-22460)%25 where data=abs(209)%25; delete from t1 where data=abs(25270)%25; insert ignore into t1(id,data) values (abs(-20627)%25,abs(-32148)%25),(null,abs(-10548)%25); insert into t2(data) values (abs(-18565)%25),(abs(25087)%25),(abs(-24521)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(30640)%25 where data=abs(18589)%25; insert into t1(id,data) values (abs(817)%25,abs(32398)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-10908)%25,data=abs(-18801)%25 where id=abs(24532)%25; update ignore t1 set data=abs(-5483)%25 where id=abs(3782)%25; insert into t1(id,data) values (abs(32007)%25,abs(20298)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-3976)%25),(abs(20051)%25),(abs(27727)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(-20235)%25),(null,abs(21464)%25),(abs(-17078)%25,abs(-10491)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(25477)%25,abs(25762)%25),(null,abs(20467)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(5077)%25),(null,abs(20026)%25),(abs(-20587)%25,abs(-28787)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-21158)%25,abs(-22037)%25),(abs(-31377)%25,abs(-30549)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-28462)%25,abs(13156)%25),(null,abs(15583)%25); insert ignore into t2(data) values (abs(26062)%25),(abs(7972)%25); start transaction; insert ignore into t2(data) values (abs(-29159)%25),(abs(18347)%25); insert ignore into t2(id,data) values (abs(14494)%25,abs(29712)%25),(abs(-25839)%25,abs(-10213)%25),(abs(13857)%25,abs(28327)%25); insert ignore into t2(data) values (abs(22195)%25),(abs(-30623)%25); replace into t1 select * from t2 where data=abs(6197)%25; replace into t1(id,data) values (abs(15106)%25,abs(1848)%25); replace into t1 select * from t2 where id=abs(-2097)%25; update ignore t2 set data=abs(23332)%25 where id=abs(22793)%25; replace into t2 select * from t1 where data=abs(24072)%25; insert ignore into t2 select * from t1 where data=abs(-8345)%25; insert into t1(id,data) values (abs(24577)%25,abs(9031)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(-1338)%25; update ignore t1 set id=abs(-627)%25,data=abs(7167)%25 where id=abs(11007)%25; rollback; insert into t2(data) values (abs(19996)%25),(abs(-1331)%25),(abs(9667)%25) on duplicate key update id=values(id),data=values(data); rollback; replace into t1 select * from t2 where data=abs(2046)%25; insert ignore into t2(id,data) values (abs(5382)%25,abs(13261)%25),(abs(19932)%25,abs(-12867)%25),(abs(727)%25,abs(-32323)%25); insert ignore into t2(id,data) values (abs(-31748)%25,abs(-4160)%25); rollback; update ignore t1 set id=abs(-7608)%25,data=abs(27217)%25 where data=abs(24652)%25; insert ignore into t2(id,data) values (abs(-26010)%25,abs(3739)%25); insert ignore into t2 select * from t1 where id=abs(8872)%25; insert ignore into t1(data) values (abs(29584)%25); insert ignore into t1(data) values (abs(2401)%25),(abs(19570)%25),(abs(10367)%25); start transaction; insert into t1(id,data) values (abs(-22193)%25,abs(11513)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(9362)%25; rollback; insert ignore into t2(id,data) values (abs(-15698)%25,abs(-11585)%25),(null,abs(-30027)%25); start transaction; commit; insert ignore into t2(id,data) values (abs(-10399)%25,abs(-7319)%25),(null,abs(2251)%25); insert ignore into t2 select * from t1 where id=abs(-29241)%25; insert into t2(id,data) values (abs(-832)%25,abs(-6777)%25),(null,abs(20959)%25) on duplicate key update id=values(id),data=values(data); start transaction; replace into t2 select * from t1 where data=abs(16933)%25; delete from t2 where id=abs(-18704)%25; insert into t1(data) values (abs(-4241)%25),(abs(-14012)%25),(abs(-12578)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t1(id,data) values (abs(30462)%25,abs(-4673)%25); insert into t1(id,data) values (abs(-5951)%25,abs(-3315)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-10761)%25,abs(-13788)%25),(abs(11635)%25,abs(8290)%25),(abs(-29390)%25,abs(-31163)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-6440)%25 where data=abs(-13709)%25; rollback; start transaction; insert into t1(id,data) values (abs(-25346)%25,abs(-18248)%25),(null,abs(2889)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-925)%25,abs(3762)%25),(null,abs(-26141)%25); insert ignore into t2(id,data) values (abs(13324)%25,abs(13232)%25),(null,abs(27737)%25); update ignore t2 set data=abs(-19978)%25 where data=abs(22495)%25; replace into t2(id,data) values (abs(-13583)%25,abs(-14856)%25); insert into t1(data) values (abs(27541)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-2131292243); insert into t2(id,data) values (abs(-31754)%25,abs(27472)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-27998)%25,abs(-9342)%25),(abs(2902)%25,abs(-9624)%25),(abs(-4398)%25,abs(-17735)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-13891)%25,abs(24260)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-19714)%25,abs(12319)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(2866)%25,abs(21982)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(10104)%25,data=abs(6832)%25 where data=abs(-19541)%25; insert ignore into t1(id,data) values (abs(-12722)%25,abs(31347)%25); insert into t2(id,data) values (abs(23251)%25,abs(4718)%25),(null,abs(10839)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(12217)%25; replace into t2(id,data) values (null,abs(9361)%25),(null,abs(-19529)%25),(abs(4654)%25,abs(-16902)%25); insert into t1(id,data) values (abs(17957)%25,abs(30676)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(18094)%25 where data=abs(21985)%25; insert ignore into t2(id,data) values (abs(17556)%25,abs(25510)%25),(abs(-10028)%25,abs(886)%25); update ignore t1 set id=abs(22084)%25,data=abs(21757)%25 where id=abs(-44)%25; replace into t1(id,data) values (abs(2525)%25,abs(-3554)%25); insert ignore into t2(id,data) values (abs(21957)%25,abs(-134)%25),(abs(-17429)%25,abs(13716)%25); insert into t1(id,data) values (abs(3627)%25,abs(-23383)%25),(abs(-23703)%25,abs(-30263)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(4275)%25 where data=abs(-11504)%25; update ignore t1 set id=abs(-14356)%25,data=abs(8511)%25 where data=abs(15)%25; insert ignore into t2(id,data) values (abs(2525)%25,abs(21607)%25); insert into t2(data) values (abs(-25526)%25),(abs(-29927)%25),(abs(29527)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(-7868)%25 where data=abs(-11801)%25; insert into t2(id,data) values (abs(22087)%25,abs(-23666)%25),(abs(-31752)%25,abs(-29918)%25),(abs(-29810)%25,abs(-16392)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(-13257)%25),(null,abs(1980)%25),(abs(-16124)%25,abs(-27452)%25); replace into t2(id,data) values (null,abs(-3800)%25),(null,abs(-18233)%25),(abs(-20068)%25,abs(-653)%25); insert into t1(id,data) values (abs(7914)%25,abs(-21745)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(29098)%25,abs(-8798)%25); start transaction; insert into t2(id,data) values (abs(-21554)%25,abs(17921)%25),(null,abs(-14141)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(31349)%25),(null,abs(-29225)%25),(abs(24893)%25,abs(13762)%25); update ignore t1 set id=abs(31739)%25,data=abs(2378)%25 where id=abs(17286)%25; update ignore t2 set data=abs(-21179)%25 where data=abs(12272)%25; update ignore t2 set data=abs(15942)%25 where id=abs(-8199)%25; insert ignore into t1(id,data) values (abs(-20570)%25,abs(18907)%25); insert into t2(id,data) values (abs(-22460)%25,abs(-15853)%25),(null,abs(25589)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(11279)%25),(abs(3862)%25); delete from t2 where data=abs(-7626)%25; insert ignore into t2(id,data) values (abs(5410)%25,abs(19272)%25); insert ignore into t1(id,data) values (abs(24178)%25,abs(25692)%25); commit; delete from t1 where id=abs(11350)%25; start transaction; update ignore t1 set id=abs(-338)%25,data=abs(9381)%25 where id=abs(-10187)%25; start transaction; replace into t2 select * from t1 where id=abs(14882)%25; insert ignore into t1(data) values (abs(-26768)%25),(abs(-22618)%25),(abs(5337)%25); rollback; replace into t2(id,data) values (null,abs(-25238)%25),(null,abs(4749)%25),(abs(18262)%25,abs(14647)%25); insert ignore into t1(data) values (abs(-27494)%25),(abs(-23342)%25); insert ignore into t1(id,data) values (abs(11075)%25,abs(-2858)%25),(abs(4891)%25,abs(-23027)%25); insert into t1(id,data) values (abs(-14882)%25,abs(18452)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-21620)%25,data=abs(-28133)%25 where id=abs(23569)%25; insert ignore into t2 select * from t1 where data=abs(2535)%25; replace into t2(id,data) values (abs(-18743)%25,abs(-10469)%25),(null,abs(-3619)%25); insert into t1(id,data) values (abs(18199)%25,abs(-20047)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(31542)%25 where id=abs(12217)%25; insert into t1(data) values (abs(18119)%25) on duplicate key update id=values(id),data=values(data); commit; replace into t2(id,data) values (abs(15919)%25,abs(-18367)%25); insert ignore into t1(id,data) values (abs(-24563)%25,abs(31970)%25); insert ignore into t1(id,data) values (abs(20572)%25,abs(-53)%25); insert ignore into t2(id,data) values (abs(-30908)%25,abs(-28042)%25); insert ignore into t2(id,data) values (abs(-10318)%25,abs(18772)%25),(abs(28320)%25,abs(-5315)%25),(abs(-19311)%25,abs(-27392)%25); insert ignore into t1(data) values (abs(22493)%25),(abs(22156)%25),(abs(27011)%25); update ignore t2 set data=abs(-12283)%25 where data=abs(-11418)%25; start transaction; start transaction; insert ignore into t2(data) values (abs(17101)%25),(abs(-15258)%25); insert ignore into t2(id,data) values (abs(-8810)%25,abs(-16691)%25),(abs(4132)%25,abs(12575)%25); rollback; insert ignore into t1(data) values (abs(-15370)%25),(abs(23873)%25); delete from t1 where id=abs(28867)%25; insert into t1(data) values (abs(-23204)%25),(abs(17399)%25),(abs(-13430)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-12421)%25,abs(-13988)%25),(abs(21112)%25,abs(32533)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-25788)%25,abs(-29753)%25); commit; replace into t1 select * from t2 where data=abs(4027)%25; insert into t2(id,data) values (abs(-14516)%25,abs(-3733)%25) on duplicate key update id=values(id),data=values(data); commit; start transaction; update ignore t1 set id=abs(18616)%25,data=abs(-26662)%25 where id=abs(-12408)%25; start transaction; insert into t1(data) values (abs(-23041)%25),(abs(10514)%25),(abs(-23102)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(20647)%25),(null,abs(10180)%25),(abs(6662)%25,abs(-10910)%25); insert into t2(id,data) values (abs(17059)%25,abs(15634)%25),(null,abs(19113)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t2(data) values (abs(-16091)%25),(abs(-344)%25),(abs(5071)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-29669)%25,abs(-1898)%25),(abs(-24575)%25,abs(-8063)%25),(abs(-9068)%25,abs(31741)%25); rollback; replace into t2 select * from t1 where data=abs(-31299)%25; start transaction; replace into t1 select * from t2 where data=abs(-4070)%25; start transaction; delete from t1 where data=abs(-29349)%25; insert into t2(id,data) values (abs(22414)%25,abs(-23171)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(3688)%25,abs(-22047)%25); insert ignore into t2(id,data) values (null,abs(-21193)%25),(null,abs(18193)%25),(abs(30292)%25,abs(-4289)%25); insert ignore into t1 select * from t2 where data=abs(16569)%25; insert into t2(data) values (abs(13505)%25),(abs(27262)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(4282)%25,abs(-18567)%25),(null,abs(4188)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(18318)%25; insert into t2(data) values (abs(10339)%25),(abs(15367)%25),(abs(15919)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-4817)%25,abs(-18959)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-25136)%25),(abs(-4708)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-9479)%25 where data=abs(18380)%25; delete from t2 where id=abs(18506)%25; delete from t2 where id=abs(-13317)%25; insert into t1(id,data) values (abs(3589)%25,abs(5482)%25),(null,abs(-23908)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(17830)%25 where id=abs(30575)%25; insert into t2(id,data) values (abs(-14138)%25,abs(-6209)%25),(abs(-21458)%25,abs(20307)%25),(abs(-30387)%25,abs(-31018)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(12334)%25),(null,abs(-24233)%25),(abs(15818)%25,abs(-21161)%25); insert into t2(id,data) values (abs(17836)%25,abs(3734)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(27696)%25,abs(11953)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(9381)%25 where id=abs(30234)%25; set sql_mode=abs(-2129906577); update ignore t1 set id=abs(-18518)%25,data=abs(-17171)%25 where id=abs(12721)%25; update ignore t2 set id=abs(3438)%25,data=abs(5195)%25 where id=abs(-4411)%25; commit; insert ignore into t1(id,data) values (abs(-18539)%25,abs(-7844)%25),(abs(6598)%25,abs(4577)%25),(abs(-24601)%25,abs(-8981)%25); insert ignore into t1(id,data) values (abs(-15003)%25,abs(9453)%25),(abs(10909)%25,abs(-7229)%25); replace into t1(id,data) values (abs(-2294)%25,abs(3412)%25); insert ignore into t2(id,data) values (abs(-26036)%25,abs(5939)%25),(abs(-24063)%25,abs(25614)%25),(abs(17887)%25,abs(10777)%25); insert into t1(id,data) values (abs(-26036)%25,abs(-10453)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(21064)%25,abs(-3918)%25) on duplicate key update id=values(id),data=values(data); commit; update ignore t1 set id=abs(-5201)%25,data=abs(19545)%25 where data=abs(-10826)%25; start transaction; insert ignore into t2(id,data) values (abs(16768)%25,abs(8899)%25); delete from t2 where data=abs(7549)%25; delete from t2 where id=abs(70)%25; replace into t1(id,data) values (abs(-3728)%25,abs(-22325)%25),(null,abs(-2678)%25); insert ignore into t2(id,data) values (abs(18302)%25,abs(-23893)%25),(abs(30296)%25,abs(9595)%25),(abs(21220)%25,abs(18977)%25); start transaction; commit; insert into t2(id,data) values (abs(-29457)%25,abs(16111)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(13054)%25,abs(10603)%25),(abs(27696)%25,abs(-26474)%25),(abs(-30626)%25,abs(-28188)%25); select @@autocommit; rollback; xa start 'xid1'; insert ignore into t2 select * from t1 where data=abs(-28040)%25; replace into t2(id,data) values (abs(5497)%25,abs(-12633)%25); update ignore t1 set id=abs(32510)%25,data=abs(20362)%25 where id=abs(-28379)%25; insert ignore into t1 select * from t2 where data=abs(-29887)%25; insert ignore into t1(id,data) values (abs(4653)%25,abs(-20972)%25); insert into t1(id,data) values (abs(-2350)%25,abs(32518)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(27742)%25,abs(-3471)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(id,data) values (abs(-12674)%25,abs(12853)%25),(null,abs(24176)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(data) values (abs(-27068)%25),(abs(31781)%25),(abs(-5808)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-12887)%25,abs(28899)%25),(abs(-8873)%25,abs(-15642)%25),(abs(1662)%25,abs(-22344)%25) on duplicate key update id=values(id),data=values(data); start transaction; replace into t2 select * from t1 where id=abs(-30908)%25; insert into t1(id,data) values (abs(-14486)%25,abs(-8458)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(24527)%25,abs(4129)%25),(null,abs(21679)%25); replace into t1(id,data) values (abs(-18076)%25,abs(-31147)%25); replace into t1 select * from t2 where data=abs(1722)%25; insert ignore into t1(id,data) values (abs(-4889)%25,abs(18877)%25); rollback; start transaction; rollback; insert ignore into t2(data) values (abs(19067)%25); update ignore t1 set id=abs(10215)%25,data=abs(14338)%25 where id=abs(-6884)%25; insert ignore into t1 select * from t2 where id=abs(24463)%25; replace into t1 select * from t2 where data=abs(-10277)%25; insert ignore into t2(id,data) values (abs(-28775)%25,abs(23995)%25),(null,abs(11213)%25); set sql_mode=abs(-1737270829); insert ignore into t1(data) values (abs(18012)%25); insert into t1(id,data) values (null,abs(-18829)%25),(null,abs(-4228)%25),(abs(3337)%25,abs(-3358)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(25640)%25,abs(30712)%25),(abs(-14033)%25,abs(-7058)%25),(abs(-32588)%25,abs(11325)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(8787)%25; insert into t2(data) values (abs(16289)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t1(id,data) values (null,abs(20161)%25),(null,abs(17692)%25),(abs(-28808)%25,abs(8542)%25); insert ignore into t1(data) values (abs(-20232)%25),(abs(-17956)%25),(abs(21734)%25); insert ignore into t1(id,data) values (abs(-24847)%25,abs(11302)%25),(null,abs(-23955)%25); insert ignore into t1(id,data) values (abs(27812)%25,abs(22220)%25),(abs(26702)%25,abs(17179)%25); replace into t2(id,data) values (abs(-193)%25,abs(24200)%25); rollback; insert ignore into t1(data) values (abs(-22814)%25); insert ignore into t1(id,data) values (abs(-20468)%25,abs(-23927)%25),(null,abs(-19916)%25); insert into t2(data) values (abs(-12410)%25),(abs(-383)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-4358)%25,data=abs(-19671)%25 where id=abs(-3924)%25; replace into t2(id,data) values (abs(9190)%25,abs(10477)%25),(null,abs(-25649)%25); insert ignore into t2(id,data) values (abs(32407)%25,abs(-15361)%25),(null,abs(18337)%25); delete from t1 where data=abs(3453)%25; insert ignore into t2(id,data) values (abs(24494)%25,abs(-2359)%25); insert ignore into t1(data) values (abs(-12269)%25),(abs(1035)%25),(abs(20210)%25); insert ignore into t1(data) values (abs(-2933)%25),(abs(-27408)%25),(abs(-4947)%25); replace into t2(id,data) values (abs(12258)%25,abs(1909)%25),(null,abs(27939)%25); commit; insert ignore into t1(id,data) values (null,abs(-7064)%25),(null,abs(15157)%25),(abs(28693)%25,abs(-17663)%25); rollback; insert ignore into t2(data) values (abs(-21296)%25),(abs(23986)%25),(abs(3006)%25); insert into t1(data) values (abs(11833)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-903)%25,abs(-30638)%25),(null,abs(-15093)%25); insert ignore into t1(data) values (abs(16923)%25),(abs(-8513)%25),(abs(-18479)%25); update ignore t1 set id=abs(-2124)%25,data=abs(4176)%25 where id=abs(-29383)%25; start transaction; insert ignore into t2(id,data) values (abs(4797)%25,abs(-26882)%25); commit; replace into t2(id,data) values (null,abs(-26993)%25),(null,abs(4635)%25),(abs(-28024)%25,abs(-20817)%25); insert into t1(id,data) values (abs(26532)%25,abs(-4980)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-6930)%25; insert into t1(id,data) values (abs(27760)%25,abs(23417)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-20916)%25),(abs(-5818)%25),(abs(8972)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(6477)%25,abs(-3213)%25); insert into t1(data) values (abs(-13148)%25),(abs(-23831)%25),(abs(-25673)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where data=abs(6271)%25; insert ignore into t2(data) values (abs(-3378)%25); delete from t2 where id=abs(-21024)%25; insert ignore into t2(id,data) values (abs(-18683)%25,abs(9013)%25); replace into t1(id,data) values (abs(31429)%25,abs(15588)%25),(null,abs(-31858)%25); rollback; rollback; insert into t1(id,data) values (abs(-18633)%25,abs(-23099)%25),(abs(13124)%25,abs(4347)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(-9983)%25 where data=abs(-18233)%25; start transaction; insert into t2(id,data) values (abs(-29099)%25,abs(3466)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-7091)%25,abs(-795)%25); rollback; replace into t2(id,data) values (null,abs(18697)%25),(null,abs(17119)%25),(abs(-28042)%25,abs(6553)%25); set sql_mode=abs(-1968789103); start transaction; insert ignore into t1 select * from t2 where data=abs(-14369)%25; update ignore t2 set data=abs(-26093)%25 where data=abs(20680)%25; commit; set sql_mode=abs(-1699030567); delete from t1 where data=abs(-13267)%25; replace into t1(id,data) values (null,abs(-20808)%25),(null,abs(12265)%25),(abs(-11870)%25,abs(32677)%25); insert ignore into t1(id,data) values (abs(-3213)%25,abs(-25427)%25); replace into t1 select * from t2 where id=abs(27577)%25; insert ignore into t1(id,data) values (abs(2710)%25,abs(-24744)%25),(abs(24418)%25,abs(27343)%25); insert ignore into t1(id,data) values (abs(-5843)%25,abs(12862)%25); replace into t1 select * from t2 where id=abs(-31283)%25; insert ignore into t2 select * from t1 where id=abs(4564)%25; insert ignore into t2(id,data) values (abs(14057)%25,abs(-28335)%25); rollback; update ignore t1 set id=abs(7453)%25,data=abs(14182)%25 where id=abs(16702)%25; replace into t1 select * from t2 where data=abs(-10388)%25; insert into t2(data) values (abs(-25722)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(5632)%25,abs(32298)%25),(null,abs(16635)%25); start transaction; insert into t1(id,data) values (abs(-21463)%25,abs(1540)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(12511)%25,abs(-24988)%25),(abs(-18008)%25,abs(20944)%25),(abs(-11337)%25,abs(12465)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(12047)%25,abs(-10910)%25),(null,abs(-29738)%25); commit; insert into t1(id,data) values (null,abs(3547)%25),(null,abs(2849)%25),(abs(-13873)%25,abs(-17909)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(568)%25),(abs(-7823)%25),(abs(20587)%25); insert ignore into t2(id,data) values (abs(19172)%25,abs(8788)%25),(null,abs(1756)%25); start transaction; delete from t1 where id=abs(29857)%25; replace into t1(id,data) values (abs(19183)%25,abs(-6811)%25),(null,abs(6210)%25); replace into t1(id,data) values (abs(7477)%25,abs(-8088)%25),(null,abs(-21752)%25); commit; insert ignore into t2(id,data) values (abs(-17343)%25,abs(-11660)%25),(null,abs(-2916)%25); update ignore t2 set data=abs(-7604)%25 where data=abs(980)%25; rollback; insert ignore into t2(data) values (abs(-32610)%25),(abs(23618)%25); insert ignore into t2 select * from t1 where id=abs(-9110)%25; insert into t2(data) values (abs(25885)%25),(abs(10891)%25),(abs(13608)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-15479)%25),(abs(22234)%25),(abs(-11277)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(-4640)%25; insert ignore into t2(data) values (abs(-3422)%25); insert ignore into t1(data) values (abs(18847)%25),(abs(4960)%25),(abs(25855)%25); replace into t1 select * from t2 where data=abs(-6558)%25; insert ignore into t1(data) values (abs(21421)%25),(abs(-27638)%25),(abs(10576)%25); start transaction; update ignore t1 set id=abs(-3303)%25,data=abs(26968)%25 where data=abs(9592)%25; delete from t2 where data=abs(-310)%25; insert ignore into t1 select * from t2 where id=abs(-30722)%25; rollback; insert ignore into t1(data) values (abs(-24333)%25),(abs(-697)%25); rollback; insert into t1(id,data) values (abs(-17738)%25,abs(-10275)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(29185)%25 where data=abs(-27872)%25; commit; insert into t1(data) values (abs(-3375)%25),(abs(-29500)%25),(abs(2281)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-32378)%25,abs(9430)%25),(abs(-3040)%25,abs(-7923)%25),(abs(6274)%25,abs(-12320)%25); insert into t1(id,data) values (null,abs(-5183)%25),(null,abs(-22085)%25),(abs(9871)%25,abs(3758)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(-22232)%25 where id=abs(27900)%25; insert into t1(id,data) values (abs(-24707)%25,abs(19137)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(-23072)%25; insert ignore into t1(id,data) values (abs(5021)%25,abs(-853)%25),(abs(26659)%25,abs(-5738)%25),(abs(18927)%25,abs(-24503)%25); update ignore t2 set id=abs(-7640)%25,data=abs(-25080)%25 where data=abs(-19907)%25; insert into t2(id,data) values (abs(-29808)%25,abs(15136)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(32028)%25),(abs(6946)%25),(abs(-29)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(-21176)%25),(null,abs(-11130)%25),(abs(-17207)%25,abs(-2232)%25); insert ignore into t2(id,data) values (abs(10990)%25,abs(-8593)%25),(abs(-503)%25,abs(6162)%25); insert ignore into t1(id,data) values (abs(-2402)%25,abs(25897)%25); replace into t2 select * from t1 where data=abs(-32591)%25; insert into t1(id,data) values (null,abs(-15610)%25),(null,abs(-13531)%25),(abs(-31120)%25,abs(-9504)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t1(id,data) values (abs(607)%25,abs(-3676)%25); insert ignore into t1(data) values (abs(-11681)%25),(abs(-26323)%25),(abs(-8630)%25); update ignore t1 set id=abs(-31607)%25,data=abs(-15716)%25 where data=abs(16467)%25; insert into t1(data) values (abs(30506)%25),(abs(-25403)%25),(abs(1012)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(31657)%25,abs(12094)%25) on duplicate key update id=values(id),data=values(data); commit; insert ignore into t2(id,data) values (abs(25627)%25,abs(-27224)%25),(abs(-22636)%25,abs(1899)%25),(abs(21139)%25,abs(15220)%25); start transaction; update ignore t1 set id=abs(-15063)%25,data=abs(-5003)%25 where id=abs(-27283)%25; insert into t2(data) values (abs(-1763)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(2371)%25,abs(24538)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(-32215)%25),(null,abs(3754)%25),(abs(-6425)%25,abs(-12226)%25) on duplicate key update id=values(id),data=values(data); rollback; commit; start transaction; replace into t2(id,data) values (null,abs(10870)%25),(null,abs(8744)%25),(abs(21462)%25,abs(5349)%25); insert into t2(id,data) values (abs(4372)%25,abs(18742)%25),(abs(-9317)%25,abs(31682)%25),(abs(-18257)%25,abs(-1778)%25) on duplicate key update id=values(id),data=values(data); commit; replace into t2(id,data) values (null,abs(-154)%25),(null,abs(-10741)%25),(abs(30792)%25,abs(-18744)%25); rollback; start transaction; start transaction; insert into t2(id,data) values (abs(7169)%25,abs(-5588)%25) on duplicate key update id=values(id),data=values(data); replace into t2 select * from t1 where id=abs(-20471)%25; insert ignore into t1(id,data) values (abs(-19780)%25,abs(-12731)%25); start transaction; insert ignore into t1(id,data) values (abs(-22313)%25,abs(-17681)%25); insert ignore into t1(id,data) values (abs(-13074)%25,abs(-4925)%25); insert into t1(id,data) values (abs(12547)%25,abs(-6655)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(15775)%25,abs(-13665)%25),(abs(739)%25,abs(-15105)%25),(abs(-5671)%25,abs(-3248)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(16855)%25),(abs(-18543)%25); update ignore t2 set id=abs(-6197)%25,data=abs(-14887)%25 where id=abs(-13872)%25; delete from t1 where data=abs(16184)%25; delete from t2 where id=abs(5561)%25; replace into t1(id,data) values (abs(-28188)%25,abs(-27403)%25),(null,abs(6327)%25); insert ignore into t2(id,data) values (abs(-9888)%25,abs(-32075)%25),(null,abs(-15464)%25); insert into t1(id,data) values (abs(-14582)%25,abs(14761)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(22201)%25,abs(-26759)%25),(abs(-11213)%25,abs(-29478)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(-27976)%25),(null,abs(-1304)%25),(abs(8207)%25,abs(-22750)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(28282)%25,abs(-31250)%25),(null,abs(-4182)%25); commit; insert into t1(id,data) values (abs(812)%25,abs(12766)%25) on duplicate key update id=values(id),data=values(data); rollback; update ignore t2 set data=abs(7219)%25 where data=abs(6666)%25; insert into t2(id,data) values (abs(13052)%25,abs(-27568)%25),(null,abs(29017)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(26852)%25,abs(21007)%25),(abs(26265)%25,abs(5482)%25),(abs(6471)%25,abs(6526)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-12602)%25,abs(-17402)%25),(abs(-13278)%25,abs(10146)%25),(abs(-28043)%25,abs(-6399)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-1108)%25),(abs(-12373)%25),(abs(28197)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(12544)%25),(abs(25542)%25),(abs(-27361)%25); delete from t2 where id=abs(-22079)%25; insert ignore into t1 select * from t2 where data=abs(-16733)%25; insert into t1(id,data) values (abs(-18029)%25,abs(-17333)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-556)%25,data=abs(2780)%25 where id=abs(-8080)%25; rollback; insert ignore into t2 select * from t1 where id=abs(-10427)%25; start transaction; insert into t2(id,data) values (abs(31262)%25,abs(25202)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(23577)%25; commit; start transaction; commit; insert ignore into t1(id,data) values (abs(19765)%25,abs(-27668)%25); insert ignore into t2(data) values (abs(-23387)%25),(abs(-25498)%25); insert into t1(id,data) values (abs(22642)%25,abs(5032)%25),(abs(-19815)%25,abs(20530)%25),(abs(-14513)%25,abs(-1818)%25) on duplicate key update id=values(id),data=values(data); rollback; insert into t2(data) values (abs(-31178)%25),(abs(-9260)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(-7283)%25; start transaction; replace into t1 select * from t2 where data=abs(-25342)%25; update ignore t2 set data=abs(-3637)%25 where data=abs(-21893)%25; insert ignore into t1(data) values (abs(25321)%25); insert into t1(id,data) values (abs(-2231)%25,abs(22156)%25),(abs(-2493)%25,abs(15902)%25),(abs(-30407)%25,abs(21017)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-2096)%25,abs(-25970)%25),(null,abs(24977)%25); update ignore t1 set id=abs(28917)%25,data=abs(28177)%25 where id=abs(-24446)%25; rollback; replace into t2(id,data) values (abs(-32168)%25,abs(-20075)%25); insert ignore into t1(data) values (abs(7963)%25),(abs(-32571)%25); replace into t2 select * from t1 where data=abs(-23138)%25; rollback; rollback; start transaction; update ignore t1 set id=abs(20649)%25,data=abs(-16505)%25 where id=abs(22037)%25; replace into t1 select * from t2 where data=abs(292)%25; update ignore t1 set id=abs(17688)%25,data=abs(16668)%25 where data=abs(14407)%25; insert into t2(data) values (abs(-1671)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(-31655)%25),(null,abs(20072)%25),(abs(-5418)%25,abs(-31133)%25); insert into t2(id,data) values (abs(-31542)%25,abs(12795)%25),(abs(4408)%25,abs(-18602)%25),(abs(23978)%25,abs(-4808)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where id=abs(31500)%25; insert into t1(data) values (abs(-5203)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-1773)%25,abs(-13067)%25); insert ignore into t2 select * from t1 where id=abs(10123)%25; insert into t1(id,data) values (abs(20137)%25,abs(18922)%25),(null,abs(2302)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(data) values (abs(25012)%25),(abs(-15983)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-20103)%25,abs(3374)%25),(null,abs(17083)%25); insert ignore into t1(id,data) values (abs(-26756)%25,abs(6553)%25),(null,abs(-8028)%25); insert into t2(id,data) values (abs(14882)%25,abs(20908)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(26881)%25,abs(-3633)%25),(abs(9232)%25,abs(3619)%25),(abs(-15134)%25,abs(-31918)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(22722)%25,abs(30568)%25),(abs(-9164)%25,abs(5231)%25) on duplicate key update id=values(id),data=values(data); set session transaction isolation level serializable; insert into t1(data) values (abs(8371)%25),(abs(23356)%25),(abs(4744)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(31744)%25; update ignore t1 set id=abs(-9610)%25,data=abs(-3047)%25 where data=abs(-1949)%25; insert ignore into t2 select * from t1 where data=abs(-5000)%25; delete from t2 where id=abs(-27743)%25; insert ignore into t1(id,data) values (abs(2258)%25,abs(-12043)%25); update ignore t2 set data=abs(1840)%25 where data=abs(-12008)%25; insert into t1(data) values (abs(-11142)%25),(abs(16014)%25),(abs(-1058)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(id,data) values (abs(15760)%25,abs(-4167)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-27218)%25,abs(1338)%25),(null,abs(10342)%25); insert ignore into t2 select * from t1 where id=abs(-12188)%25; replace into t1 select * from t2 where data=abs(1332)%25; insert into t1(data) values (abs(19677)%25),(abs(10786)%25),(abs(-14937)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-21813)%25),(abs(-7477)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(22507)%25),(null,abs(-29199)%25),(abs(3112)%25,abs(-23007)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2(id,data) values (abs(-22988)%25,abs(-27380)%25),(abs(-31928)%25,abs(-21013)%25); delete from t1 where id=abs(22720)%25; insert ignore into t1(id,data) values (abs(19710)%25,abs(-25337)%25),(null,abs(-3171)%25); insert ignore into t1(id,data) values (abs(-6347)%25,abs(-19326)%25); replace into t2(id,data) values (abs(-20562)%25,abs(-2066)%25); rollback; replace into t1 select * from t2 where data=abs(-7601)%25; update ignore t1 set id=abs(8576)%25,data=abs(-1922)%25 where id=abs(-12738)%25; insert ignore into t1(id,data) values (abs(3678)%25,abs(2308)%25); replace into t1 select * from t2 where data=abs(18678)%25; insert into t1(data) values (abs(6103)%25),(abs(-23199)%25),(abs(-28072)%25) on duplicate key update id=values(id),data=values(data); rollback; update ignore t1 set id=abs(-31964)%25,data=abs(-26382)%25 where data=abs(-11707)%25; replace into t1 select * from t2 where data=abs(-18461)%25; insert ignore into t2(id,data) values (abs(-24362)%25,abs(15055)%25); replace into t2(id,data) values (null,abs(13870)%25),(null,abs(-26279)%25),(abs(-7508)%25,abs(17617)%25); insert into t2(id,data) values (abs(29983)%25,abs(11600)%25),(abs(-24013)%25,abs(20248)%25),(abs(20822)%25,abs(-25847)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(30592)%25,abs(26212)%25),(null,abs(27322)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-4869)%25,abs(-13382)%25),(null,abs(-5569)%25); insert into t1(data) values (abs(26314)%25),(abs(7004)%25),(abs(-5908)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-12119)%25,abs(-7153)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-27256)%25,abs(-25868)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(24937)%25; update ignore t1 set data=abs(27604)%25 where data=abs(-16480)%25; update ignore t1 set data=abs(-218)%25 where id=abs(-6875)%25; insert ignore into t1(id,data) values (abs(6241)%25,abs(1552)%25),(abs(2237)%25,abs(-28292)%25); insert into t2(id,data) values (null,abs(-7707)%25),(null,abs(11706)%25),(abs(30522)%25,abs(4762)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(17239)%25),(abs(-9672)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(-3943)%25),(null,abs(-14678)%25),(abs(-3944)%25,abs(-16787)%25); replace into t1 select * from t2 where data=abs(29893)%25; insert into t1(id,data) values (abs(-6392)%25,abs(-3766)%25),(abs(4120)%25,abs(17906)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(2992)%25,abs(-10670)%25),(abs(5199)%25,abs(16576)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-8798)%25 where id=abs(22990)%25; insert into t1(id,data) values (abs(3987)%25,abs(26326)%25) on duplicate key update id=values(id),data=values(data); commit; rollback; rollback; insert into t2(data) values (abs(-25403)%25),(abs(6349)%25),(abs(5792)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-30418)%25; update ignore t2 set id=abs(20560)%25,data=abs(-5)%25 where id=abs(-20884)%25; replace into t1 select * from t2 where data=abs(-16562)%25; insert ignore into t1(id,data) values (null,abs(28537)%25),(null,abs(-10854)%25),(abs(3563)%25,abs(-5731)%25); rollback; insert into t2(id,data) values (abs(13863)%25,abs(-1597)%25),(abs(23680)%25,abs(14866)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(24491)%25,abs(-31712)%25),(null,abs(-16282)%25); update ignore t1 set id=abs(7328)%25,data=abs(29326)%25 where id=abs(24994)%25; update ignore t1 set data=abs(-31143)%25 where id=abs(24717)%25; insert into t2(data) values (abs(4245)%25),(abs(16807)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (null,abs(20944)%25),(null,abs(1640)%25),(abs(-10133)%25,abs(-23263)%25); insert ignore into t2 select * from t1 where id=abs(-2918)%25; replace into t2 select * from t1 where data=abs(8587)%25; insert into t1(id,data) values (abs(31149)%25,abs(-32018)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2 select * from t1 where data=abs(-27746)%25; set sql_mode=abs(-1779241519); insert into t1(id,data) values (abs(20767)%25,abs(637)%25),(abs(-18847)%25,abs(8770)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(-11852)%25),(abs(29813)%25); insert ignore into t2 select * from t1 where data=abs(-5927)%25; start transaction; insert ignore into t2(id,data) values (abs(-29792)%25,abs(-9155)%25),(null,abs(30082)%25); commit; insert ignore into t1(data) values (abs(-30394)%25),(abs(-22701)%25),(abs(-18971)%25); replace into t2(id,data) values (abs(24541)%25,abs(-12707)%25); delete from t2 where id=abs(-2223)%25; insert ignore into t1(id,data) values (abs(-22550)%25,abs(2526)%25); commit; insert into t2(id,data) values (abs(-30998)%25,abs(17994)%25),(null,abs(18982)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-23298)%25),(abs(18523)%25); replace into t2(id,data) values (null,abs(28687)%25),(null,abs(-9441)%25),(abs(24183)%25,abs(19881)%25); insert ignore into t2(id,data) values (abs(8537)%25,abs(32026)%25),(null,abs(20534)%25); insert ignore into t2 select * from t1 where data=abs(2812)%25; insert into t2(id,data) values (abs(3229)%25,abs(-167)%25),(abs(-24939)%25,abs(2467)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(8994)%25,abs(5133)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(13718)%25 where data=abs(10093)%25; insert into t1(data) values (abs(1942)%25),(abs(27945)%25),(abs(11932)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-1698)%25,abs(-15151)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(17356)%25 where data=abs(21394)%25; update ignore t1 set data=abs(10549)%25 where id=abs(10856)%25; start transaction; insert ignore into t2 select * from t1 where data=abs(-13251)%25; insert ignore into t2 select * from t1 where id=abs(-20073)%25; update ignore t1 set data=abs(17892)%25 where id=abs(15392)%25; insert ignore into t2(id,data) values (abs(-32512)%25,abs(19433)%25); delete from t1 where id=abs(9322)%25; insert into t1(id,data) values (null,abs(-16335)%25),(null,abs(-7505)%25),(abs(-5271)%25,abs(24127)%25) on duplicate key update id=values(id),data=values(data); start transaction; rollback; update ignore t1 set id=abs(-21539)%25,data=abs(-29150)%25 where id=abs(8695)%25; insert into t1(id,data) values (abs(-7408)%25,abs(6335)%25),(abs(-21107)%25,abs(-4268)%25),(abs(-30875)%25,abs(-24012)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(10542)%25),(abs(-32060)%25),(abs(-4073)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(-20167)%25); insert ignore into t1(data) values (abs(25756)%25),(abs(-24608)%25),(abs(7752)%25); insert into t2(data) values (abs(-7906)%25),(abs(-6565)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(-29258)%25),(null,abs(7755)%25),(abs(13242)%25,abs(16501)%25); set sql_mode=abs(-1830758511); insert into t2(id,data) values (abs(-4389)%25,abs(28752)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(26115)%25; insert ignore into t1(data) values (abs(-1989)%25),(abs(25377)%25),(abs(-31085)%25); insert into t1(data) values (abs(-11186)%25),(abs(-12485)%25),(abs(-29836)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(17789)%25,abs(-16176)%25),(abs(7147)%25,abs(11266)%25),(abs(-26367)%25,abs(197)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(28492)%25,abs(-17549)%25),(abs(9322)%25,abs(20328)%25),(abs(-24482)%25,abs(-30416)%25); replace into t1(id,data) values (abs(-6878)%25,abs(9577)%25),(null,abs(5348)%25); insert ignore into t1 select * from t2 where data=abs(16232)%25; insert into t1(id,data) values (abs(-26114)%25,abs(23299)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(-24773)%25; update ignore t1 set data=abs(14237)%25 where id=abs(21615)%25; insert ignore into t2 select * from t1 where data=abs(9253)%25; insert ignore into t2(data) values (abs(24737)%25),(abs(-15445)%25); replace into t1(id,data) values (abs(743)%25,abs(-5150)%25),(null,abs(28060)%25); replace into t1 select * from t2 where id=abs(11277)%25; insert ignore into t2(data) values (abs(-4609)%25),(abs(23352)%25); commit; insert into t2(id,data) values (abs(-17164)%25,abs(-19995)%25),(abs(-31629)%25,abs(-1913)%25) on duplicate key update id=values(id),data=values(data); commit; rollback; update ignore t1 set data=abs(19813)%25 where id=abs(-9644)%25; insert into t1(data) values (abs(-27238)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-7684)%25,abs(-9971)%25),(abs(31877)%25,abs(12457)%25),(abs(2542)%25,abs(32166)%25); insert ignore into t1(id,data) values (abs(889)%25,abs(-2636)%25); replace into t1 select * from t2 where id=abs(24503)%25; insert into t2(data) values (abs(-14141)%25),(abs(29376)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(30686)%25,abs(11796)%25),(null,abs(-31818)%25); insert into t1(data) values (abs(776)%25),(abs(-2996)%25),(abs(-6533)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(12125)%25 where data=abs(-27380)%25; rollback; insert into t2(id,data) values (abs(16132)%25,abs(27507)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(11506)%25,abs(-2518)%25),(abs(14377)%25,abs(-23420)%25),(abs(-30658)%25,abs(21442)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(30127)%25),(abs(14357)%25),(abs(30502)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(13470)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(-23333)%25; insert into t2(id,data) values (abs(-17105)%25,abs(-22483)%25),(abs(20188)%25,abs(-25289)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(12768)%25,abs(13342)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(-15783)%25; delete from t1 where id=abs(6877)%25; replace into t1 select * from t2 where data=abs(-11609)%25; insert into t2(data) values (abs(-29957)%25),(abs(17222)%25),(abs(-20048)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(17677)%25,abs(31972)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(14027)%25),(abs(-32119)%25),(abs(-5198)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-30424)%25,abs(-21653)%25),(null,abs(-30129)%25); insert ignore into t2(id,data) values (abs(12631)%25,abs(22293)%25),(abs(-7720)%25,abs(-21834)%25),(abs(7482)%25,abs(23521)%25); replace into t2(id,data) values (null,abs(17956)%25),(null,abs(24580)%25),(abs(-30756)%25,abs(18802)%25); insert ignore into t2(id,data) values (abs(24742)%25,abs(-8078)%25),(null,abs(-25268)%25); insert into t2(data) values (abs(-13733)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-25373)%25 where data=abs(-13559)%25; insert ignore into t2(data) values (abs(-30983)%25),(abs(-32506)%25); insert ignore into t1 select * from t2 where id=abs(-3117)%25; insert ignore into t2(id,data) values (abs(31137)%25,abs(-31898)%25),(abs(28249)%25,abs(-13798)%25),(abs(-11006)%25,abs(-6404)%25); insert into t1(id,data) values (abs(-7265)%25,abs(27060)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-14756)%25),(abs(-19633)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(12497)%25,abs(-23993)%25),(null,abs(32057)%25); insert ignore into t1(data) values (abs(-11452)%25),(abs(17884)%25),(abs(26456)%25); replace into t2 select * from t1 where data=abs(-29354)%25; insert into t2(id,data) values (abs(-26867)%25,abs(-19636)%25),(null,abs(23308)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(22140)%25,abs(-18030)%25),(null,abs(-17128)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(11545)%25,data=abs(-21581)%25 where id=abs(29282)%25; replace into t2 select * from t1 where data=abs(4533)%25; update ignore t2 set data=abs(-5063)%25 where data=abs(-6485)%25; insert ignore into t2(id,data) values (abs(-32359)%25,abs(27136)%25),(abs(-28043)%25,abs(-25319)%25),(abs(-32583)%25,abs(2091)%25); insert ignore into t1(id,data) values (abs(16930)%25,abs(-30185)%25); insert into t2(data) values (abs(-22373)%25),(abs(18081)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(2577)%25,abs(217)%25); insert ignore into t2(id,data) values (abs(-31408)%25,abs(2490)%25),(abs(-28559)%25,abs(-12897)%25),(abs(-15158)%25,abs(5646)%25); insert into t1(data) values (abs(29169)%25),(abs(14992)%25),(abs(-4006)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-16652)%25,abs(570)%25),(abs(-8401)%25,abs(19471)%25),(abs(32039)%25,abs(16006)%25); replace into t1(id,data) values (abs(1187)%25,abs(9997)%25),(null,abs(-17944)%25); insert into t2(id,data) values (abs(-31408)%25,abs(-12604)%25) on duplicate key update id=values(id),data=values(data); start transaction; start transaction; insert into t1(id,data) values (abs(-572)%25,abs(12384)%25),(abs(-25145)%25,abs(27550)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-6818)%25,abs(-14532)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(31172)%25,abs(-30638)%25),(null,abs(-11757)%25); start transaction; insert into t1(data) values (abs(30037)%25) on duplicate key update id=values(id),data=values(data); set session autocommit=1; insert ignore into t1(data) values (abs(-30583)%25); replace into t2(id,data) values (abs(-26309)%25,abs(4949)%25); insert into t2(id,data) values (null,abs(-8527)%25),(null,abs(-31917)%25),(abs(30937)%25,abs(-28974)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(20753)%25,data=abs(6554)%25 where id=abs(-20999)%25; insert ignore into t1(id,data) values (null,abs(-20201)%25),(null,abs(20704)%25),(abs(23162)%25,abs(10123)%25); update ignore t2 set id=abs(11936)%25,data=abs(-18692)%25 where data=abs(-28099)%25; start transaction; start transaction; insert ignore into t2(data) values (abs(-26255)%25),(abs(-8234)%25); insert ignore into t2(id,data) values (abs(28042)%25,abs(-21803)%25),(null,abs(28)%25); update ignore t1 set id=abs(21528)%25,data=abs(-16883)%25 where data=abs(16464)%25; insert into t1(data) values (abs(-21215)%25),(abs(23860)%25),(abs(16429)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(445)%25,data=abs(1919)%25 where id=abs(-9703)%25; insert into t2(data) values (abs(18997)%25),(abs(-8999)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(11037)%25),(null,abs(6196)%25),(abs(-13280)%25,abs(7537)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-30845)%25,abs(-7547)%25); insert into t1(id,data) values (null,abs(-17633)%25),(null,abs(10525)%25),(abs(5167)%25,abs(5053)%25) on duplicate key update id=values(id),data=values(data); rollback; replace into t2(id,data) values (abs(-3632)%25,abs(-10499)%25); delete from t1 where data=abs(-27035)%25; insert into t2(data) values (abs(28623)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(17581)%25; insert ignore into t2(id,data) values (abs(4572)%25,abs(29417)%25),(abs(-316)%25,abs(24124)%25); set sql_mode=abs(-1274641047); insert into t1(data) values (abs(16302)%25),(abs(-9733)%25),(abs(-23033)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-16297)%25,abs(-7954)%25) on duplicate key update id=values(id),data=values(data); commit; start transaction; rollback; insert ignore into t2 select * from t1 where id=abs(22789)%25; rollback; insert ignore into t2(id,data) values (null,abs(-21341)%25),(null,abs(-6437)%25),(abs(-9877)%25,abs(20671)%25); update ignore t1 set id=abs(-6221)%25,data=abs(7759)%25 where id=abs(29332)%25; insert ignore into t2 select * from t1 where data=abs(-5830)%25; insert into t1(id,data) values (abs(-21468)%25,abs(-6173)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(30764)%25; insert into t2(id,data) values (abs(-23996)%25,abs(13092)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t1(id,data) values (abs(28664)%25,abs(26410)%25); insert into t2(data) values (abs(23863)%25),(abs(-18717)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(10498)%25,abs(29212)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(-10608)%25; insert into t2(id,data) values (abs(-4582)%25,abs(-23886)%25),(null,abs(-9761)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(id,data) values (abs(31150)%25,abs(20143)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(106)%25),(abs(20927)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (null,abs(15682)%25),(null,abs(20106)%25),(abs(29707)%25,abs(-4160)%25); replace into t1(id,data) values (abs(13927)%25,abs(19546)%25),(null,abs(12262)%25); insert into t2(id,data) values (abs(20604)%25,abs(-14327)%25),(abs(-11541)%25,abs(-32594)%25),(abs(-8348)%25,abs(-18104)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(5346)%25,abs(7174)%25),(abs(-23464)%25,abs(-4308)%25),(abs(-22463)%25,abs(6724)%25); insert into t1(id,data) values (abs(10858)%25,abs(-13412)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(17128)%25),(null,abs(-5213)%25),(abs(31558)%25,abs(-18891)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-22043)%25,abs(-9932)%25),(abs(17494)%25,abs(23797)%25),(abs(14615)%25,abs(-22009)%25); insert ignore into t2 select * from t1 where id=abs(-31198)%25; update ignore t2 set data=abs(17374)%25 where data=abs(-11977)%25; replace into t1(id,data) values (null,abs(-10841)%25),(null,abs(32023)%25),(abs(9889)%25,abs(5897)%25); insert ignore into t2(data) values (abs(-16907)%25),(abs(12402)%25); insert ignore into t2 select * from t1 where id=abs(31781)%25; insert into t1(id,data) values (null,abs(-15158)%25),(null,abs(15982)%25),(abs(-16807)%25,abs(28301)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(18848)%25; insert into t1(id,data) values (null,abs(-23657)%25),(null,abs(-24508)%25),(abs(-28694)%25,abs(-7565)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-23288)%25,abs(-9428)%25); insert ignore into t1(id,data) values (abs(9688)%25,abs(5146)%25),(null,abs(13477)%25); insert into t2(id,data) values (abs(-29789)%25,abs(27541)%25),(abs(-23110)%25,abs(28933)%25),(abs(-17075)%25,abs(-3284)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t2(data) values (abs(5716)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where data=abs(-15803)%25; start transaction; insert into t2(id,data) values (abs(-31022)%25,abs(10861)%25),(null,abs(25592)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(19792)%25),(abs(20068)%25),(abs(32368)%25) on duplicate key update id=values(id),data=values(data); replace into t2 select * from t1 where id=abs(-19983)%25; commit; delete from t1 where data=abs(-4640)%25; insert ignore into t2(id,data) values (null,abs(27154)%25),(null,abs(692)%25),(abs(-1845)%25,abs(30601)%25); insert into t1(data) values (abs(30456)%25),(abs(-25628)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(6572)%25),(abs(1189)%25),(abs(20102)%25); update ignore t2 set data=abs(-2644)%25 where data=abs(-5597)%25; replace into t1(id,data) values (abs(-9748)%25,abs(-1279)%25),(null,abs(-29738)%25); insert ignore into t1(id,data) values (null,abs(22112)%25),(null,abs(-12644)%25),(abs(-15803)%25,abs(22580)%25); insert into t1(id,data) values (null,abs(15687)%25),(null,abs(-26474)%25),(abs(-16136)%25,abs(-20916)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-7557)%25,abs(2872)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(28657)%25,abs(2215)%25),(null,abs(-4076)%25); rollback; insert ignore into t1(id,data) values (abs(-13667)%25,abs(29776)%25),(null,abs(19765)%25); commit; rollback; insert ignore into t2 select * from t1 where data=abs(30094)%25; insert ignore into t1(data) values (abs(16207)%25),(abs(32761)%25); commit; insert ignore into t2(id,data) values (abs(-7342)%25,abs(-21361)%25),(null,abs(13695)%25); insert into t2(data) values (abs(-28718)%25),(abs(11411)%25),(abs(9427)%25) on duplicate key update id=values(id),data=values(data); start transaction; update ignore t1 set id=abs(-21420)%25,data=abs(49)%25 where id=abs(6169)%25; commit; delete from t1 where data=abs(31204)%25; insert ignore into t1(id,data) values (abs(5860)%25,abs(13366)%25); insert ignore into t2 select * from t1 where data=abs(7658)%25; update ignore t1 set data=abs(-30293)%25 where id=abs(-11156)%25; insert ignore into t2(id,data) values (abs(5482)%25,abs(31412)%25); update ignore t2 set data=abs(-18073)%25 where id=abs(-4871)%25; insert into t2(id,data) values (abs(17862)%25,abs(-30773)%25),(null,abs(-29297)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(-10283)%25),(null,abs(12612)%25),(abs(-26323)%25,abs(1531)%25); set sql_mode=abs(-1486227391); insert ignore into t2(id,data) values (abs(-119)%25,abs(29314)%25); insert into t2(id,data) values (abs(16387)%25,abs(-15807)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(-18665)%25),(null,abs(9703)%25),(abs(-3716)%25,abs(17300)%25); insert ignore into t1(id,data) values (abs(6553)%25,abs(-15491)%25); replace into t1(id,data) values (abs(844)%25,abs(-28940)%25); insert into t1(id,data) values (abs(-24386)%25,abs(-30707)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(25149)%25),(null,abs(-26387)%25),(abs(-22389)%25,abs(13070)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(30592)%25,abs(-15156)%25),(abs(-17285)%25,abs(14837)%25); start transaction; delete from t1 where data=abs(2982)%25; insert into t2(id,data) values (abs(2576)%25,abs(12245)%25),(null,abs(6021)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(8863)%25),(abs(-9204)%25); insert into t2(id,data) values (abs(-19220)%25,abs(19245)%25),(null,abs(-1666)%25) on duplicate key update id=values(id),data=values(data); rollback; update ignore t2 set data=abs(31072)%25 where data=abs(23263)%25; replace into t2 select * from t1 where data=abs(23176)%25; insert ignore into t2(id,data) values (abs(13198)%25,abs(31577)%25); rollback; commit; start transaction; replace into t2 select * from t1 where data=abs(-6164)%25; insert into t2(id,data) values (abs(28377)%25,abs(18256)%25) on duplicate key update id=values(id),data=values(data); start transaction; start transaction; insert ignore into t2(id,data) values (null,abs(3018)%25),(null,abs(4411)%25),(abs(-32612)%25,abs(18045)%25); rollback; insert into t1(id,data) values (abs(24165)%25,abs(-18942)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(27293)%25 where id=abs(-5355)%25; insert into t1(id,data) values (abs(-9058)%25,abs(9851)%25),(abs(-19661)%25,abs(-2371)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(-22541)%25; insert ignore into t1(data) values (abs(2382)%25),(abs(-31907)%25),(abs(1086)%25); insert into t1(id,data) values (abs(24931)%25,abs(32046)%25) on duplicate key update id=values(id),data=values(data); replace into t2 select * from t1 where id=abs(15682)%25; insert into t1(data) values (abs(-16376)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(17758)%25 where id=abs(-9299)%25; replace into t1(id,data) values (null,abs(12878)%25),(null,abs(-11161)%25),(abs(-29204)%25,abs(6741)%25); replace into t1(id,data) values (abs(8698)%25,abs(18334)%25),(null,abs(-29960)%25); start transaction; insert ignore into t2(id,data) values (abs(-20393)%25,abs(4218)%25),(null,abs(3873)%25); insert ignore into t2 select * from t1 where data=abs(21616)%25; rollback; commit; update ignore t2 set data=abs(26515)%25 where id=abs(5873)%25; insert ignore into t1(id,data) values (abs(-8585)%25,abs(21802)%25),(abs(8644)%25,abs(1165)%25),(abs(23672)%25,abs(16447)%25); rollback; insert into t1(data) values (abs(-7403)%25),(abs(15560)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(2302)%25),(null,abs(-1307)%25),(abs(21890)%25,abs(7363)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-18272)%25,abs(-5783)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(4334)%25,abs(27185)%25); insert ignore into t1(id,data) values (null,abs(16269)%25),(null,abs(25443)%25),(abs(85)%25,abs(-31450)%25); commit; replace into t2(id,data) values (null,abs(-7363)%25),(null,abs(19702)%25),(abs(-25645)%25,abs(10289)%25); replace into t2(id,data) values (abs(20821)%25,abs(15050)%25); set sql_mode=abs(-1562237343); replace into t1 select * from t2 where data=abs(-23208)%25; insert ignore into t2 select * from t1 where data=abs(11682)%25; replace into t1 select * from t2 where data=abs(-9839)%25; update ignore t2 set data=abs(-19415)%25 where data=abs(-3047)%25; insert ignore into t1(data) values (abs(32353)%25),(abs(13027)%25),(abs(-26460)%25); delete from t2 where id=abs(23328)%25; insert into t1(data) values (abs(-28203)%25),(abs(-30221)%25),(abs(-3283)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-26388)%25,data=abs(-7288)%25 where data=abs(-23051)%25; insert into t1(id,data) values (abs(-13223)%25,abs(20971)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-11094)%25); replace into t2(id,data) values (abs(8956)%25,abs(27302)%25); set sql_mode=abs(-1764968520); update ignore t2 set data=abs(-11438)%25 where id=abs(3040)%25; insert ignore into t1(id,data) values (null,abs(29355)%25),(null,abs(23812)%25),(abs(14178)%25,abs(9200)%25); rollback; insert into t2(id,data) values (abs(-473)%25,abs(-16328)%25),(abs(-22375)%25,abs(-25829)%25),(abs(26533)%25,abs(19921)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(20093)%25,abs(-9048)%25),(null,abs(-21106)%25); update ignore t2 set data=abs(10728)%25 where data=abs(-6104)%25; start transaction; set sql_mode=abs(-2084841743); replace into t1 select * from t2 where data=abs(1582)%25; replace into t1 select * from t2 where data=abs(-31833)%25; replace into t1(id,data) values (abs(32360)%25,abs(-31283)%25),(null,abs(23173)%25); insert ignore into t1 select * from t2 where data=abs(-16823)%25; insert ignore into t2(id,data) values (abs(20167)%25,abs(-9798)%25); update ignore t2 set data=abs(-20408)%25 where data=abs(-21128)%25; insert ignore into t2(data) values (abs(26698)%25),(abs(-10582)%25); commit; replace into t1 select * from t2 where id=abs(-25980)%25; insert ignore into t2(id,data) values (abs(-7853)%25,abs(13802)%25),(null,abs(-2168)%25); insert ignore into t1(id,data) values (abs(-31613)%25,abs(18517)%25); insert into t2(id,data) values (abs(-27663)%25,abs(-8677)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(17757)%25); rollback; commit; replace into t1 select * from t2 where data=abs(27990)%25; insert ignore into t1(id,data) values (abs(71)%25,abs(-15162)%25); replace into t1(id,data) values (abs(-26810)%25,abs(7457)%25); delete from t2 where id=abs(4243)%25; insert into t1(id,data) values (abs(20321)%25,abs(-28960)%25),(abs(-25447)%25,abs(-23858)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-4340)%25,data=abs(-2337)%25 where data=abs(4048)%25; insert into t1(id,data) values (abs(-32214)%25,abs(9931)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(17881)%25); insert into t1(id,data) values (abs(-19145)%25,abs(-3080)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t1(id,data) values (abs(4180)%25,abs(-24813)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(19775)%25,abs(-2778)%25),(null,abs(-23442)%25); insert into t2(id,data) values (abs(-27539)%25,abs(-22007)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(4120)%25,abs(21007)%25),(abs(-32003)%25,abs(28687)%25),(abs(7036)%25,abs(21583)%25); start transaction; insert into t1(id,data) values (abs(6457)%25,abs(2332)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(25906)%25,abs(-10220)%25); insert ignore into t1 select * from t2 where data=abs(16754)%25; replace into t1(id,data) values (abs(-2678)%25,abs(-9857)%25),(null,abs(20221)%25); insert into t1(data) values (abs(-3665)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(17017)%25; insert into t2(data) values (abs(-17285)%25),(abs(-7026)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1920280969); insert into t1(id,data) values (abs(-11279)%25,abs(-16935)%25) on duplicate key update id=values(id),data=values(data); replace into t2 select * from t1 where data=abs(-8661)%25; insert into t2(id,data) values (abs(31375)%25,abs(20739)%25),(abs(-16683)%25,abs(14436)%25),(abs(-21869)%25,abs(-9371)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-1738)%25 where data=abs(-4710)%25; insert ignore into t2(id,data) values (abs(-27063)%25,abs(27527)%25); rollback; update ignore t1 set id=abs(15806)%25,data=abs(3037)%25 where id=abs(-3425)%25; insert ignore into t2(id,data) values (abs(23277)%25,abs(-17934)%25); start transaction; insert into t1(id,data) values (abs(-13648)%25,abs(25002)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-571)%25,abs(27556)%25),(abs(-17927)%25,abs(1147)%25),(abs(17782)%25,abs(19957)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-10731)%25,abs(28037)%25),(null,abs(-353)%25); insert into t1(id,data) values (abs(20878)%25,abs(-9578)%25),(abs(-12546)%25,abs(-4094)%25),(abs(-12549)%25,abs(25034)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-5068)%25,abs(31147)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(22448)%25,abs(31018)%25),(null,abs(22493)%25); replace into t1 select * from t2 where data=abs(-395)%25; insert into t2(id,data) values (null,abs(-15371)%25),(null,abs(-8581)%25),(abs(8107)%25,abs(18013)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(5936)%25; replace into t2(id,data) values (abs(-28688)%25,abs(-3181)%25); insert into t2(id,data) values (abs(-7778)%25,abs(-30907)%25),(null,abs(-14914)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(25003)%25),(abs(-4378)%25); insert ignore into t1(id,data) values (null,abs(-3206)%25),(null,abs(-28357)%25),(abs(-32111)%25,abs(-13643)%25); insert into t2(id,data) values (abs(27802)%25,abs(-30864)%25),(abs(-9638)%25,abs(19479)%25),(abs(-15909)%25,abs(-11159)%25) on duplicate key update id=values(id),data=values(data); rollback; insert into t1(id,data) values (null,abs(23446)%25),(null,abs(-28343)%25),(abs(5181)%25,abs(-17018)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(29044)%25),(abs(7767)%25); insert ignore into t2(id,data) values (abs(24769)%25,abs(9100)%25),(abs(17329)%25,abs(16534)%25),(abs(-14918)%25,abs(31174)%25); update ignore t1 set id=abs(-22026)%25,data=abs(-9638)%25 where id=abs(-13393)%25; delete from t1 where data=abs(-11926)%25; insert into t1(data) values (abs(-2803)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-13403)%25,abs(26535)%25),(null,abs(-23453)%25); insert into t2(id,data) values (abs(-31730)%25,abs(-27696)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(-13753)%25); update ignore t2 set id=abs(-8993)%25,data=abs(-12759)%25 where id=abs(-16348)%25; update ignore t2 set data=abs(31102)%25 where data=abs(16195)%25; delete from t1 where data=abs(14497)%25; insert into t2(id,data) values (abs(-28859)%25,abs(-12458)%25),(abs(16972)%25,abs(27122)%25),(abs(13633)%25,abs(17635)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-2420)%25; insert into t1(data) values (abs(26869)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-4488)%25,abs(-23522)%25),(null,abs(17950)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-7513)%25,abs(9721)%25),(abs(17362)%25,abs(19037)%25),(abs(-23900)%25,abs(31282)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(14497)%25; insert into t1(id,data) values (abs(25537)%25,abs(31932)%25),(abs(22111)%25,abs(-5500)%25),(abs(13252)%25,abs(-10358)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2(data) values (abs(1415)%25),(abs(-20128)%25); insert ignore into t1(id,data) values (abs(-14683)%25,abs(1423)%25); insert ignore into t2(id,data) values (abs(-3581)%25,abs(14571)%25),(abs(-26297)%25,abs(-29162)%25),(abs(6307)%25,abs(-8789)%25); insert ignore into t1(data) values (abs(18172)%25),(abs(3545)%25),(abs(-11093)%25); insert ignore into t1(id,data) values (null,abs(-2558)%25),(null,abs(-24405)%25),(abs(-17177)%25,abs(-2433)%25); insert ignore into t2(id,data) values (abs(-4745)%25,abs(-26993)%25); insert ignore into t2(data) values (abs(1825)%25),(abs(-179)%25); insert ignore into t1 select * from t2 where data=abs(-20510)%25; insert ignore into t1(id,data) values (abs(11358)%25,abs(-5298)%25),(abs(29692)%25,abs(2237)%25),(abs(-29498)%25,abs(22390)%25); insert into t1(id,data) values (abs(7148)%25,abs(5122)%25) on duplicate key update id=values(id),data=values(data); rollback; replace into t2(id,data) values (null,abs(-3656)%25),(null,abs(772)%25),(abs(8426)%25,abs(-31552)%25); insert into t2(data) values (abs(-15045)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(25567)%25,abs(16332)%25),(null,abs(-13340)%25); delete from t1 where data=abs(-28286)%25; commit; update ignore t1 set id=abs(10765)%25,data=abs(28636)%25 where data=abs(-18118)%25; insert into t1(id,data) values (abs(-14513)%25,abs(22063)%25),(abs(3536)%25,abs(-29790)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(-32474)%25; insert ignore into t2(id,data) values (abs(7537)%25,abs(-9080)%25),(null,abs(25778)%25); insert ignore into t2(id,data) values (abs(-23218)%25,abs(21571)%25); delete from t2 where data=abs(-21317)%25; insert ignore into t1(id,data) values (abs(27400)%25,abs(31050)%25),(abs(9779)%25,abs(-4751)%25); insert into t1(id,data) values (abs(-23103)%25,abs(-14864)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-8123)%25,abs(19705)%25),(abs(15448)%25,abs(8095)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(-9148)%25; start transaction; insert ignore into t2(id,data) values (abs(12294)%25,abs(-5399)%25); insert into t2(id,data) values (abs(-27203)%25,abs(18392)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(-9992)%25),(null,abs(10204)%25),(abs(5947)%25,abs(-4523)%25); insert into t2(id,data) values (abs(13333)%25,abs(19345)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(5362)%25,abs(7405)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2(id,data) values (abs(-26528)%25,abs(-3521)%25),(null,abs(11551)%25); insert ignore into t1(data) values (abs(29227)%25),(abs(29098)%25); replace into t2 select * from t1 where data=abs(-6405)%25; insert ignore into t1 select * from t2 where data=abs(-26273)%25; rollback; insert ignore into t1(id,data) values (abs(27042)%25,abs(10633)%25),(abs(12219)%25,abs(2568)%25),(abs(2742)%25,abs(-18581)%25); insert into t2(id,data) values (abs(-25203)%25,abs(6669)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-21533)%25,abs(-23864)%25),(abs(11247)%25,abs(-31747)%25),(abs(-7418)%25,abs(23002)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(2887)%25,abs(9790)%25); insert into t2(data) values (abs(-5288)%25),(abs(32367)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-31772)%25,data=abs(23407)%25 where id=abs(11115)%25; insert into t1(data) values (abs(-3638)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where id=abs(1109)%25; replace into t2(id,data) values (abs(6658)%25,abs(-27785)%25),(null,abs(-7792)%25); start transaction; insert ignore into t1(id,data) values (null,abs(10555)%25),(null,abs(-28458)%25),(abs(-26303)%25,abs(-20426)%25); commit; insert ignore into t2 select * from t1 where data=abs(-1513)%25; insert into t2(id,data) values (abs(-25847)%25,abs(9940)%25),(null,abs(-3270)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-27049)%25,abs(10684)%25),(abs(-19473)%25,abs(-4490)%25),(abs(-32290)%25,abs(-14298)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-24893)%25,abs(-30455)%25),(abs(29005)%25,abs(-2089)%25); update ignore t1 set id=abs(-24429)%25,data=abs(-20674)%25 where id=abs(21490)%25; commit; insert into t2(id,data) values (abs(21397)%25,abs(-21165)%25),(abs(-1413)%25,abs(-18998)%25),(abs(-15745)%25,abs(14992)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(874)%25; insert ignore into t1(id,data) values (abs(24206)%25,abs(7024)%25); insert into t1(data) values (abs(-29093)%25),(abs(-4415)%25),(abs(-11165)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(17458)%25,abs(-11118)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(-4020)%25),(null,abs(-11798)%25),(abs(-9056)%25,abs(16053)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(13937)%25; insert ignore into t1(id,data) values (abs(-7446)%25,abs(8131)%25); update ignore t2 set id=abs(21324)%25,data=abs(18004)%25 where id=abs(-29746)%25; replace into t1(id,data) values (null,abs(-10071)%25),(null,abs(2082)%25),(abs(30682)%25,abs(-6083)%25); replace into t2(id,data) values (abs(25917)%25,abs(-1199)%25); rollback; delete from t1 where data=abs(4980)%25; update ignore t1 set id=abs(-24359)%25,data=abs(-3917)%25 where id=abs(12588)%25; rollback; rollback; insert ignore into t2(data) values (abs(-10479)%25); insert into t1(id,data) values (abs(-32153)%25,abs(6893)%25),(null,abs(-16370)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where id=abs(-15698)%25; insert ignore into t2(id,data) values (abs(-24585)%25,abs(-30683)%25); replace into t1 select * from t2 where data=abs(1468)%25; insert ignore into t2(id,data) values (abs(27889)%25,abs(-21776)%25),(null,abs(19632)%25); insert ignore into t2(data) values (abs(29650)%25),(abs(24652)%25); select @@autocommit; replace into t2(id,data) values (abs(17052)%25,abs(-8723)%25); insert into t2(id,data) values (abs(7879)%25,abs(-25301)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-16822)%25 where data=abs(15879)%25; update ignore t2 set data=abs(-26927)%25 where data=abs(-10736)%25; insert ignore into t1(id,data) values (abs(27677)%25,abs(17267)%25); set sql_mode=abs(-1953944541); start transaction; insert ignore into t2 select * from t1 where data=abs(32058)%25; replace into t2(id,data) values (abs(5763)%25,abs(-14044)%25); update ignore t2 set id=abs(20572)%25,data=abs(-12502)%25 where id=abs(20992)%25; insert ignore into t1(id,data) values (null,abs(-18686)%25),(null,abs(-689)%25),(abs(-17213)%25,abs(16504)%25); delete from t1 where data=abs(1140)%25; start transaction; insert into t1(data) values (abs(-14848)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(974)%25; insert ignore into t1(id,data) values (abs(-19878)%25,abs(16642)%25); insert ignore into t1(id,data) values (null,abs(32031)%25),(null,abs(564)%25),(abs(-338)%25,abs(-26481)%25); insert into t2(data) values (abs(-21833)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(29367)%25,abs(-16394)%25),(null,abs(-24786)%25); insert ignore into t2(data) values (abs(19055)%25); update ignore t2 set data=abs(-6646)%25 where data=abs(9153)%25; insert ignore into t1(data) values (abs(-10618)%25),(abs(3922)%25); replace into t2(id,data) values (abs(-22241)%25,abs(-21290)%25); insert ignore into t2(id,data) values (abs(-26548)%25,abs(3792)%25),(abs(-13718)%25,abs(20955)%25),(abs(3157)%25,abs(6866)%25); insert ignore into t1(id,data) values (abs(14737)%25,abs(25300)%25); insert ignore into t2(id,data) values (abs(-6078)%25,abs(-5976)%25); update ignore t2 set data=abs(-10143)%25 where data=abs(5202)%25; rollback; insert ignore into t1(data) values (abs(29071)%25); rollback; set sql_mode=abs(-1824773727); insert into t1(data) values (abs(-9459)%25),(abs(-27218)%25),(abs(-9753)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-12458)%25,abs(-13716)%25); update ignore t2 set data=abs(19913)%25 where data=abs(7779)%25; update ignore t2 set data=abs(-20987)%25 where id=abs(29809)%25; insert ignore into t1 select * from t2 where id=abs(3220)%25; update ignore t1 set data=abs(21984)%25 where data=abs(29706)%25; update ignore t1 set id=abs(29421)%25,data=abs(-23558)%25 where id=abs(22006)%25; insert ignore into t2(id,data) values (abs(-7882)%25,abs(-3309)%25),(abs(-31528)%25,abs(-32158)%25),(abs(-24625)%25,abs(-27763)%25); update ignore t1 set data=abs(11794)%25 where data=abs(-10818)%25; insert into t2(data) values (abs(-18918)%25),(abs(-17383)%25),(abs(-20298)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(id,data) values (abs(-15509)%25,abs(16156)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(26106)%25; insert ignore into t2(id,data) values (abs(-12425)%25,abs(37)%25); replace into t2(id,data) values (null,abs(32550)%25),(null,abs(-161)%25),(abs(-29304)%25,abs(20283)%25); insert into t2(data) values (abs(-5888)%25),(abs(27067)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(31969)%25,abs(2152)%25),(null,abs(-1889)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-21304)%25; insert ignore into t2(id,data) values (abs(25762)%25,abs(20242)%25),(null,abs(29965)%25); replace into t1 select * from t2 where id=abs(-3564)%25; insert into t1(data) values (abs(26292)%25),(abs(11228)%25),(abs(-22313)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-31664)%25,abs(-30963)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(2120)%25,abs(-15263)%25),(null,abs(6802)%25); insert ignore into t1(data) values (abs(-10976)%25),(abs(32471)%25),(abs(23860)%25); insert into t2(id,data) values (abs(-31399)%25,abs(24160)%25),(abs(-3668)%25,abs(-19578)%25),(abs(23880)%25,abs(28134)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(4297)%25; replace into t1 select * from t2 where data=abs(-11688)%25; replace into t2(id,data) values (abs(-17668)%25,abs(30603)%25); set sql_mode=abs(-1964113336); delete from t1 where id=abs(-12671)%25; insert ignore into t1(id,data) values (abs(-10059)%25,abs(24487)%25),(null,abs(18797)%25); update ignore t1 set id=abs(-26951)%25,data=abs(-15277)%25 where id=abs(-28044)%25; insert ignore into t2(data) values (abs(127)%25),(abs(-19158)%25); insert ignore into t2(id,data) values (null,abs(21882)%25),(null,abs(-24527)%25),(abs(31337)%25,abs(31612)%25); update ignore t2 set data=abs(-26773)%25 where data=abs(-12473)%25; delete from t2 where id=abs(18550)%25; insert into t2(id,data) values (abs(-2408)%25,abs(18207)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-6460)%25,data=abs(-13166)%25 where data=abs(-22292)%25; insert into t1(data) values (abs(-9838)%25),(abs(32001)%25),(abs(5335)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(6709)%25,data=abs(-12425)%25 where id=abs(8830)%25; delete from t2 where id=abs(9937)%25; insert ignore into t1(id,data) values (abs(-20168)%25,abs(6056)%25),(null,abs(22357)%25); replace into t2 select * from t1 where id=abs(-5798)%25; insert ignore into t2(id,data) values (abs(-6248)%25,abs(5782)%25),(null,abs(-5020)%25); update ignore t1 set id=abs(-25283)%25,data=abs(26132)%25 where id=abs(9383)%25; replace into t2(id,data) values (abs(26293)%25,abs(20495)%25),(null,abs(13351)%25); insert into t1(data) values (abs(32354)%25),(abs(-15891)%25),(abs(6487)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(2272)%25 where data=abs(-23588)%25; replace into t2(id,data) values (abs(-12287)%25,abs(22354)%25); insert into t1(id,data) values (abs(-30662)%25,abs(-3919)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(32602)%25 where data=abs(-2891)%25; update ignore t1 set id=abs(-9765)%25,data=abs(19867)%25 where id=abs(32651)%25; replace into t1 select * from t2 where data=abs(12880)%25; insert ignore into t2(id,data) values (abs(-32633)%25,abs(31775)%25),(null,abs(-17920)%25); insert into t1(id,data) values (abs(-13964)%25,abs(-26636)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-26388)%25; insert ignore into t1(id,data) values (null,abs(-25424)%25),(null,abs(-16083)%25),(abs(10599)%25,abs(22969)%25); commit; update ignore t1 set id=abs(-19982)%25,data=abs(-4367)%25 where id=abs(-32581)%25; rollback; insert ignore into t1(id,data) values (abs(-8426)%25,abs(-20732)%25),(abs(25362)%25,abs(26244)%25),(abs(-31415)%25,abs(24940)%25); insert into t1(id,data) values (abs(-6074)%25,abs(23312)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-15275)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(9676)%25),(abs(-22868)%25),(abs(32464)%25); insert into t1(data) values (abs(9405)%25),(abs(7087)%25),(abs(19948)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-8888)%25,abs(-6636)%25),(abs(-9710)%25,abs(27824)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-28934)%25,abs(-2281)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(28402)%25,abs(-4247)%25),(null,abs(30511)%25); insert ignore into t1(data) values (abs(-16256)%25),(abs(16610)%25),(abs(-22142)%25); insert ignore into t1(data) values (abs(21781)%25),(abs(-7228)%25),(abs(19496)%25); insert ignore into t2 select * from t1 where data=abs(4699)%25; update ignore t2 set data=abs(382)%25 where data=abs(5887)%25; replace into t1 select * from t2 where id=abs(7198)%25; insert ignore into t2 select * from t1 where data=abs(15002)%25; insert into t2(data) values (abs(-4892)%25),(abs(-19478)%25),(abs(-23333)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(27622)%25; update ignore t2 set id=abs(3700)%25,data=abs(-31400)%25 where id=abs(15727)%25; start transaction; start transaction; insert into t1(id,data) values (abs(15872)%25,abs(27946)%25),(null,abs(-31465)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-6863)%25,abs(32687)%25); start transaction; insert into t2(id,data) values (abs(-28790)%25,abs(4762)%25),(abs(-25844)%25,abs(20780)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t1(data) values (abs(31978)%25),(abs(-23660)%25),(abs(15925)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(315)%25),(abs(276)%25),(abs(-12989)%25); replace into t1 select * from t2 where data=abs(5014)%25; rollback; insert ignore into t2 select * from t1 where id=abs(-31383)%25; delete from t1 where data=abs(-2405)%25; insert into t1(id,data) values (abs(-14543)%25,abs(-28427)%25) on duplicate key update id=values(id),data=values(data); rollback; insert ignore into t2(data) values (abs(-944)%25),(abs(27484)%25); insert ignore into t2(id,data) values (abs(-5928)%25,abs(22202)%25); insert ignore into t2(id,data) values (null,abs(25801)%25),(null,abs(28675)%25),(abs(-10138)%25,abs(-2797)%25); insert into t2(data) values (abs(21079)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where data=abs(19452)%25; insert into t2(id,data) values (abs(14838)%25,abs(-29683)%25),(null,abs(-24113)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-23312)%25,abs(-7883)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(12357)%25 where id=abs(31951)%25; replace into t1(id,data) values (null,abs(-5078)%25),(null,abs(-31604)%25),(abs(-837)%25,abs(-9772)%25); insert into t2(id,data) values (abs(14035)%25,abs(-6123)%25),(null,abs(18558)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-27646)%25),(abs(19371)%25),(abs(-23826)%25) on duplicate key update id=values(id),data=values(data); commit; replace into t1(id,data) values (abs(-30008)%25,abs(-23912)%25),(null,abs(30979)%25); delete from t1 where data=abs(-27065)%25; replace into t1 select * from t2 where data=abs(5314)%25; update ignore t2 set data=abs(11827)%25 where data=abs(4589)%25; insert into t2(id,data) values (abs(-19621)%25,abs(4552)%25),(abs(12572)%25,abs(20595)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(-18191)%25); insert into t1(data) values (abs(-27693)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-15014)%25,abs(7192)%25),(abs(13249)%25,abs(14860)%25),(abs(-11813)%25,abs(15852)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(data) values (abs(27450)%25),(abs(27732)%25),(abs(606)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(13943)%25,abs(-25713)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(-16403)%25),(null,abs(15921)%25),(abs(29366)%25,abs(28423)%25); insert ignore into t2 select * from t1 where data=abs(-5771)%25; update ignore t2 set data=abs(-6308)%25 where data=abs(8647)%25; commit; insert ignore into t1 select * from t2 where data=abs(-13313)%25; insert into t1(data) values (abs(23000)%25),(abs(30049)%25),(abs(-30321)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(8432)%25; insert into t1(id,data) values (abs(13394)%25,abs(2251)%25),(abs(2973)%25,abs(-8378)%25) on duplicate key update id=values(id),data=values(data); rollback; start transaction; insert ignore into t2(data) values (abs(6772)%25),(abs(9118)%25); commit; rollback; replace into t2(id,data) values (abs(-8018)%25,abs(5059)%25); replace into t1 select * from t2 where data=abs(-1388)%25; start transaction; rollback; update ignore t1 set data=abs(-31029)%25 where id=abs(-17086)%25; insert into t2(id,data) values (abs(20207)%25,abs(-20765)%25) on duplicate key update id=values(id),data=values(data); start transaction; start transaction; insert into t1(id,data) values (abs(-8424)%25,abs(25820)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-20076)%25) on duplicate key update id=values(id),data=values(data); rollback; delete from t2 where data=abs(13011)%25; commit; commit; insert into t1(data) values (abs(-6968)%25),(abs(20592)%25),(abs(3237)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where id=abs(-8687)%25; insert into t2(id,data) values (abs(-2343)%25,abs(24700)%25),(abs(-4677)%25,abs(-10249)%25),(abs(1231)%25,abs(6757)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(1059)%25,abs(-6483)%25),(null,abs(25666)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set id=abs(2442)%25,data=abs(11233)%25 where id=abs(16787)%25; insert into t2(id,data) values (abs(13110)%25,abs(18005)%25),(abs(24358)%25,abs(11920)%25),(abs(6315)%25,abs(8020)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-16121)%25 where data=abs(29942)%25; insert into t2(data) values (abs(-9246)%25),(abs(-25023)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(12242)%25,data=abs(30502)%25 where id=abs(30773)%25; replace into t2(id,data) values (abs(-3035)%25,abs(-27474)%25); update ignore t2 set data=abs(-32474)%25 where data=abs(5742)%25; rollback; set sql_mode=abs(-1941702888); replace into t2 select * from t1 where id=abs(11452)%25; replace into t2 select * from t1 where data=abs(-30281)%25; insert ignore into t1(id,data) values (abs(-11126)%25,abs(17002)%25); update ignore t1 set id=abs(22276)%25,data=abs(29008)%25 where data=abs(7156)%25; insert ignore into t2 select * from t1 where id=abs(32503)%25; rollback; commit; insert ignore into t2(data) values (abs(-31568)%25),(abs(27576)%25),(abs(-4073)%25); rollback; set sql_mode=abs(-1969768255); rollback; update ignore t1 set id=abs(-16228)%25,data=abs(-9424)%25 where data=abs(32736)%25; update ignore t1 set id=abs(-20960)%25,data=abs(-27821)%25 where id=abs(-22208)%25; insert ignore into t2 select * from t1 where data=abs(23189)%25; replace into t1 select * from t2 where data=abs(-18288)%25; rollback; set sql_mode=abs(-1454637361); insert ignore into t1(data) values (abs(-1045)%25); insert into t2(id,data) values (abs(22)%25,abs(-1219)%25),(abs(18172)%25,abs(14263)%25),(abs(-15317)%25,abs(27706)%25) on duplicate key update id=values(id),data=values(data); rollback; insert into t2(id,data) values (abs(1807)%25,abs(15427)%25) on duplicate key update id=values(id),data=values(data); replace into t2 select * from t1 where id=abs(5550)%25; update ignore t1 set id=abs(-5195)%25,data=abs(23494)%25 where id=abs(-18182)%25; insert ignore into t2(id,data) values (abs(775)%25,abs(-2525)%25); replace into t2(id,data) values (null,abs(6385)%25),(null,abs(-19049)%25),(abs(4485)%25,abs(-28918)%25); replace into t2(id,data) values (abs(-11693)%25,abs(10084)%25); insert ignore into t1(id,data) values (abs(-23858)%25,abs(18016)%25),(abs(-6581)%25,abs(23212)%25); replace into t2(id,data) values (null,abs(21553)%25),(null,abs(6098)%25),(abs(-28505)%25,abs(-22556)%25); insert ignore into t2(id,data) values (abs(-11873)%25,abs(6880)%25),(null,abs(11263)%25); start transaction; insert ignore into t2 select * from t1 where id=abs(25863)%25; set sql_mode=abs(-1492845586); start transaction; insert ignore into t2 select * from t1 where id=abs(1408)%25; update ignore t1 set id=abs(25479)%25,data=abs(-16486)%25 where id=abs(-16991)%25; insert into t1(id,data) values (abs(10602)%25,abs(-21803)%25),(abs(15160)%25,abs(13387)%25) on duplicate key update id=values(id),data=values(data); rollback; insert ignore into t2(id,data) values (abs(32262)%25,abs(9193)%25),(abs(9548)%25,abs(14188)%25),(abs(-19704)%25,abs(-4562)%25); insert into t1(id,data) values (abs(-5903)%25,abs(-3113)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(16860)%25),(abs(30297)%25),(abs(-8058)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t1(id,data) values (abs(12671)%25,abs(-20114)%25); update ignore t2 set data=abs(15002)%25 where data=abs(-28659)%25; update ignore t1 set data=abs(-6548)%25 where id=abs(-502)%25; set sql_mode=abs(-1946062504); insert ignore into t2(id,data) values (abs(-1343)%25,abs(15456)%25),(null,abs(-26573)%25); commit; insert into t2(id,data) values (abs(12876)%25,abs(30022)%25),(abs(12427)%25,abs(18242)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(13123)%25),(abs(-28854)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(id,data) values (abs(-28145)%25,abs(-18623)%25),(abs(-2060)%25,abs(28718)%25),(abs(-18114)%25,abs(-22610)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(-4454)%25),(null,abs(-1075)%25),(abs(1869)%25,abs(4070)%25); insert ignore into t1(id,data) values (null,abs(-5012)%25),(null,abs(23757)%25),(abs(1759)%25,abs(-25485)%25); update ignore t1 set id=abs(-9334)%25,data=abs(-23102)%25 where id=abs(23542)%25; replace into t2(id,data) values (abs(-31419)%25,abs(7458)%25); replace into t1(id,data) values (abs(-3975)%25,abs(31452)%25),(null,abs(-7340)%25); insert ignore into t2(id,data) values (abs(28202)%25,abs(-7700)%25); start transaction; replace into t2(id,data) values (null,abs(21022)%25),(null,abs(-13327)%25),(abs(29299)%25,abs(15712)%25); replace into t2(id,data) values (abs(13085)%25,abs(7873)%25); insert ignore into t1(id,data) values (abs(-22793)%25,abs(-12003)%25),(null,abs(-29265)%25); replace into t1 select * from t2 where data=abs(-27917)%25; insert ignore into t1(id,data) values (abs(10391)%25,abs(25880)%25); insert into t1(data) values (abs(16018)%25),(abs(11412)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(27631)%25),(null,abs(-13099)%25),(abs(1957)%25,abs(29314)%25); rollback; delete from t1 where data=abs(-29198)%25; replace into t2(id,data) values (abs(20692)%25,abs(6765)%25); rollback; insert into t1(data) values (abs(-19032)%25) on duplicate key update id=values(id),data=values(data); start transaction; replace into t1 select * from t2 where data=abs(-29298)%25; update ignore t2 set data=abs(18777)%25 where data=abs(3961)%25; commit; insert ignore into t1(id,data) values (abs(-3185)%25,abs(-8598)%25); set session transaction isolation level serializable; insert ignore into t1(id,data) values (abs(-24099)%25,abs(14375)%25); update ignore t2 set data=abs(23587)%25 where data=abs(-26851)%25; insert ignore into t1 select * from t2 where id=abs(-7636)%25; insert ignore into t2(id,data) values (abs(-8870)%25,abs(-10805)%25),(null,abs(-31455)%25); start transaction; update ignore t2 set data=abs(4807)%25 where id=abs(15553)%25; replace into t1(id,data) values (abs(25858)%25,abs(-19376)%25),(null,abs(20392)%25); insert into t1(data) values (abs(4216)%25),(abs(-27952)%25),(abs(-5211)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-29095)%25,abs(1665)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(27604)%25,abs(26195)%25),(null,abs(-31610)%25); insert into t2(id,data) values (abs(-25637)%25,abs(28696)%25) on duplicate key update id=values(id),data=values(data); start transaction; replace into t1 select * from t2 where data=abs(31171)%25; insert ignore into t1(id,data) values (abs(14689)%25,abs(-11471)%25),(null,abs(-19204)%25); insert ignore into t2(id,data) values (abs(20718)%25,abs(19732)%25); replace into t2(id,data) values (abs(-31833)%25,abs(262)%25); insert into t1(id,data) values (null,abs(25454)%25),(null,abs(-4789)%25),(abs(17185)%25,abs(-8313)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-9518)%25,abs(11239)%25),(abs(-29066)%25,abs(-10211)%25); replace into t1 select * from t2 where data=abs(15182)%25; update ignore t2 set data=abs(-25543)%25 where id=abs(31887)%25; replace into t1(id,data) values (abs(21877)%25,abs(32047)%25),(null,abs(20866)%25); insert into t2(id,data) values (null,abs(23995)%25),(null,abs(19351)%25),(abs(4444)%25,abs(-31873)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(8509)%25,data=abs(-27843)%25 where id=abs(4442)%25; start transaction; update ignore t2 set id=abs(22333)%25,data=abs(-21263)%25 where data=abs(21289)%25; replace into t1(id,data) values (abs(24127)%25,abs(-9554)%25),(null,abs(15189)%25); insert into t2(data) values (abs(-20299)%25),(abs(18385)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-13838)%25),(abs(4987)%25),(abs(-19059)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(4378)%25,abs(-19974)%25); replace into t1(id,data) values (abs(30712)%25,abs(25427)%25); insert into t1(id,data) values (abs(29419)%25,abs(15507)%25),(abs(-22758)%25,abs(-9851)%25),(abs(16437)%25,abs(-10871)%25) on duplicate key update id=values(id),data=values(data); rollback; set sql_mode=abs(-1791800666); insert ignore into t2(id,data) values (abs(8247)%25,abs(-14169)%25),(null,abs(26690)%25); rollback; insert into t1(id,data) values (abs(30818)%25,abs(17552)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(-16615)%25),(null,abs(13111)%25),(abs(14397)%25,abs(-15385)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-12210)%25,abs(7360)%25),(null,abs(4396)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (null,abs(-21607)%25),(null,abs(-26461)%25),(abs(-13050)%25,abs(24808)%25); insert into t1(id,data) values (abs(-23303)%25,abs(-5149)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(23297)%25; replace into t1 select * from t2 where data=abs(-9581)%25; insert ignore into t1(id,data) values (abs(-18613)%25,abs(-7623)%25); update ignore t1 set id=abs(-24144)%25,data=abs(18775)%25 where id=abs(-25006)%25; replace into t2(id,data) values (abs(-1624)%25,abs(32087)%25),(null,abs(-32514)%25); insert ignore into t1 select * from t2 where data=abs(244)%25; replace into t1 select * from t2 where data=abs(27412)%25; commit; insert ignore into t1(id,data) values (null,abs(-32513)%25),(null,abs(24355)%25),(abs(25462)%25,abs(-19083)%25); rollback work no release; start transaction; insert into t2(id,data) values (abs(27726)%25,abs(16344)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(29257)%25; delete from t2 where data=abs(4498)%25; delete from t1 where id=abs(23686)%25; insert into t1(data) values (abs(-32748)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(17691)%25,abs(193)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(26452)%25,abs(-5446)%25),(abs(5575)%25,abs(21937)%25),(abs(24094)%25,abs(-5473)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(18237)%25,abs(-24576)%25),(null,abs(6223)%25); delete from t1 where data=abs(-5708)%25; insert ignore into t1(id,data) values (abs(3094)%25,abs(502)%25); commit; update ignore t2 set data=abs(-26784)%25 where data=abs(-19349)%25; commit; update ignore t2 set data=abs(-1287)%25 where data=abs(-2678)%25; insert into t1(id,data) values (abs(-149)%25,abs(26103)%25),(null,abs(-1855)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(4558)%25); replace into t2(id,data) values (null,abs(25117)%25),(null,abs(9514)%25),(abs(18697)%25,abs(-14050)%25); replace into t1 select * from t2 where id=abs(20878)%25; insert ignore into t1(id,data) values (abs(-14833)%25,abs(-20353)%25); update ignore t2 set id=abs(-28670)%25,data=abs(25768)%25 where id=abs(-18608)%25; insert ignore into t2(id,data) values (abs(-535)%25,abs(32449)%25); insert into t1(id,data) values (abs(10312)%25,abs(-5382)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(28921)%25); rollback; replace into t2(id,data) values (abs(-9430)%25,abs(18376)%25),(null,abs(2578)%25); replace into t2(id,data) values (abs(-14567)%25,abs(-21269)%25),(null,abs(-1678)%25); insert ignore into t1(id,data) values (abs(-10673)%25,abs(-5201)%25); start transaction; insert into t2(id,data) values (abs(32662)%25,abs(9270)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(12163)%25; replace into t2(id,data) values (abs(15255)%25,abs(-25679)%25); insert into t1(data) values (abs(4122)%25),(abs(11974)%25),(abs(-29086)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(22863)%25,abs(3282)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(6847)%25,abs(1843)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-9819)%25,abs(21942)%25),(null,abs(28078)%25); insert ignore into t2(id,data) values (abs(-12228)%25,abs(-5294)%25); insert into t1(id,data) values (null,abs(-25784)%25),(null,abs(-14748)%25),(abs(-20936)%25,abs(29994)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(11755)%25; insert into t2(id,data) values (abs(14777)%25,abs(8712)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-4235)%25 where data=abs(20967)%25; insert into t1(id,data) values (abs(-17852)%25,abs(-15806)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-4118)%25,abs(-15072)%25); insert ignore into t2(data) values (abs(31985)%25),(abs(18747)%25); insert ignore into t1(id,data) values (abs(-20901)%25,abs(-24290)%25),(abs(8236)%25,abs(-5957)%25); insert into t1(id,data) values (abs(6577)%25,abs(6994)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(-32156)%25),(null,abs(-17423)%25),(abs(-6710)%25,abs(-21958)%25) on duplicate key update id=values(id),data=values(data); rollback; update ignore t1 set id=abs(11792)%25,data=abs(-31781)%25 where id=abs(29902)%25; insert into t1(data) values (abs(-29963)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-7964)%25,abs(25092)%25),(abs(20147)%25,abs(802)%25); update ignore t1 set id=abs(3052)%25,data=abs(-12461)%25 where id=abs(32602)%25; replace into t2(id,data) values (abs(-29885)%25,abs(-2111)%25); insert ignore into t2(id,data) values (abs(-17594)%25,abs(11182)%25); insert ignore into t1(id,data) values (null,abs(29605)%25),(null,abs(19519)%25),(abs(-27629)%25,abs(-10559)%25); set sql_mode=abs(-1211893813); insert into t2(id,data) values (abs(9733)%25,abs(-14328)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-13466)%25),(abs(29992)%25),(abs(-24619)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-15515)%25,abs(5941)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-10286)%25,abs(-1694)%25),(null,abs(-29658)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(16349)%25,abs(10807)%25),(null,abs(-16052)%25); start transaction; update ignore t2 set data=abs(1585)%25 where data=abs(-13557)%25; update ignore t1 set id=abs(4066)%25,data=abs(-2856)%25 where data=abs(19693)%25; insert into t1(id,data) values (abs(27422)%25,abs(-11858)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-19882)%25); insert ignore into t2(id,data) values (abs(-20984)%25,abs(13629)%25); insert into t2(id,data) values (abs(7312)%25,abs(-13650)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(1937)%25),(null,abs(7996)%25),(abs(31135)%25,abs(5017)%25); insert ignore into t2(id,data) values (abs(24400)%25,abs(15376)%25); insert into t1(data) values (abs(27982)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-13436)%25,abs(-26873)%25),(null,abs(6229)%25) on duplicate key update id=values(id),data=values(data); commit; insert ignore into t2(data) values (abs(21931)%25),(abs(21423)%25); insert ignore into t2 select * from t1 where data=abs(-24742)%25; update ignore t1 set data=abs(29365)%25 where id=abs(-21120)%25; commit; delete from t1 where data=abs(10798)%25; commit; replace into t1 select * from t2 where id=abs(-2618)%25; insert into t2(id,data) values (abs(19375)%25,abs(-18707)%25),(abs(4302)%25,abs(21992)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(data) values (abs(-20178)%25),(abs(27966)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(13137)%25; insert ignore into t2(id,data) values (abs(-26530)%25,abs(-13763)%25),(null,abs(15636)%25); update ignore t1 set id=abs(-30022)%25,data=abs(-7602)%25 where id=abs(17667)%25; insert into t1(id,data) values (abs(-2926)%25,abs(32158)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-24788)%25,abs(-14981)%25); replace into t2 select * from t1 where data=abs(-4823)%25; update ignore t2 set data=abs(-28490)%25 where id=abs(-10418)%25; update ignore t2 set data=abs(-5443)%25 where data=abs(-26896)%25; start transaction; replace into t1 select * from t2 where id=abs(12482)%25; insert ignore into t1(id,data) values (abs(27627)%25,abs(27939)%25); replace into t1 select * from t2 where data=abs(-23303)%25; start transaction; replace into t2(id,data) values (null,abs(14542)%25),(null,abs(-1726)%25),(abs(25561)%25,abs(-2518)%25); insert ignore into t1(id,data) values (abs(4019)%25,abs(-11138)%25); insert into t1(id,data) values (abs(17977)%25,abs(15002)%25),(abs(-12383)%25,abs(-24719)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(8365)%25,abs(-11326)%25); insert into t2(id,data) values (abs(-2561)%25,abs(-17825)%25),(abs(-10893)%25,abs(-6430)%25),(abs(-28053)%25,abs(-32398)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-5966)%25; insert into t1(data) values (abs(16486)%25),(abs(21034)%25),(abs(-16526)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-14282)%25 where data=abs(-6015)%25; rollback; insert into t1(id,data) values (abs(-12818)%25,abs(17007)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-16958)%25,abs(24009)%25) on duplicate key update id=values(id),data=values(data); start transaction; update ignore t1 set data=abs(-31057)%25 where id=abs(-23169)%25; set sql_mode=abs(-1948548232); insert into t1(id,data) values (null,abs(-5558)%25),(null,abs(-13201)%25),(abs(-6758)%25,abs(20257)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-3575)%25,abs(18025)%25),(null,abs(14903)%25); insert into t1(id,data) values (abs(-4613)%25,abs(28074)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-25313)%25); replace into t2(id,data) values (abs(-15428)%25,abs(205)%25); replace into t2(id,data) values (abs(32539)%25,abs(-32582)%25),(null,abs(-12899)%25); insert into t1(id,data) values (abs(16521)%25,abs(-7862)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(20022)%25,abs(-11993)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-21183)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t1(data) values (abs(24182)%25),(abs(25949)%25),(abs(4030)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (null,abs(-5798)%25),(null,abs(-5531)%25),(abs(5425)%25,abs(-628)%25); insert ignore into t2(id,data) values (abs(9922)%25,abs(26992)%25); replace into t1 select * from t2 where id=abs(18565)%25; insert into t2(data) values (abs(-13317)%25),(abs(17770)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(4102)%25; replace into t1 select * from t2 where id=abs(14522)%25; insert into t2(id,data) values (abs(19286)%25,abs(-31727)%25),(null,abs(-2695)%25) on duplicate key update id=values(id),data=values(data); rollback; commit; replace into t2(id,data) values (null,abs(-2458)%25),(null,abs(-25817)%25),(abs(2609)%25,abs(3938)%25); update ignore t1 set id=abs(-20632)%25,data=abs(1372)%25 where id=abs(-1548)%25; update ignore t2 set id=abs(28824)%25,data=abs(30939)%25 where data=abs(31326)%25; delete from t2 where data=abs(20602)%25; replace into t1(id,data) values (abs(15510)%25,abs(-10828)%25),(null,abs(-4490)%25); delete from t2 where id=abs(-1948)%25; insert ignore into t1(id,data) values (abs(13804)%25,abs(-21219)%25),(abs(-18081)%25,abs(-28561)%25),(abs(15172)%25,abs(-13697)%25); rollback; start transaction; replace into t2 select * from t1 where id=abs(-3875)%25; replace into t2 select * from t1 where data=abs(-11652)%25; replace into t2(id,data) values (abs(-12107)%25,abs(18907)%25); insert ignore into t1(id,data) values (abs(152)%25,abs(-16305)%25),(null,abs(-5834)%25); rollback; replace into t1(id,data) values (abs(8707)%25,abs(2945)%25); delete from t2 where id=abs(32547)%25; insert ignore into t2(id,data) values (abs(-32148)%25,abs(-10103)%25); insert ignore into t2(id,data) values (abs(4668)%25,abs(-476)%25),(null,abs(-21103)%25); insert ignore into t2(id,data) values (abs(-24893)%25,abs(-2603)%25),(null,abs(-9752)%25); insert into t1(id,data) values (abs(30817)%25,abs(9337)%25),(null,abs(11378)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(17097)%25,abs(6967)%25),(null,abs(-19158)%25); insert ignore into t1(id,data) values (abs(14923)%25,abs(955)%25); insert ignore into t2 select * from t1 where id=abs(20146)%25; replace into t2(id,data) values (abs(-12535)%25,abs(-22307)%25); replace into t2(id,data) values (abs(20204)%25,abs(25423)%25); insert ignore into t2(id,data) values (abs(-31909)%25,abs(-23351)%25),(abs(31555)%25,abs(25171)%25); update ignore t1 set id=abs(21715)%25,data=abs(28777)%25 where id=abs(-21157)%25; update ignore t2 set data=abs(26572)%25 where data=abs(-547)%25; rollback; start transaction; insert into t2(id,data) values (abs(-32078)%25,abs(-25733)%25) on duplicate key update id=values(id),data=values(data); start transaction; start transaction; insert into t1(data) values (abs(-6238)%25),(abs(-9192)%25),(abs(2935)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(27790)%25 where data=abs(-11858)%25; commit; insert into t1(data) values (abs(-24161)%25),(abs(-332)%25),(abs(-6351)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(30033)%25; update ignore t1 set id=abs(224)%25,data=abs(-15452)%25 where id=abs(13105)%25; insert into t1(data) values (abs(28518)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-15074)%25,abs(-31354)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(7053)%25,abs(4573)%25); start transaction; insert ignore into t2(data) values (abs(7012)%25); rollback; replace into t2(id,data) values (abs(18652)%25,abs(-11295)%25); insert into t1(id,data) values (abs(-28401)%25,abs(19556)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(21199)%25,abs(12883)%25); replace into t1(id,data) values (abs(-25088)%25,abs(9706)%25),(null,abs(-14417)%25); update ignore t2 set data=abs(-23732)%25 where data=abs(14458)%25; replace into t2(id,data) values (null,abs(11354)%25),(null,abs(780)%25),(abs(6357)%25,abs(27025)%25); insert ignore into t1(data) values (abs(-16163)%25),(abs(21652)%25); insert ignore into t1(id,data) values (abs(-14813)%25,abs(3389)%25); replace into t2(id,data) values (abs(-4538)%25,abs(-13203)%25); insert into t1(id,data) values (abs(-18743)%25,abs(348)%25),(abs(-23793)%25,abs(-5138)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-1417)%25,abs(23895)%25); delete from t2 where id=abs(-13954)%25; insert ignore into t2(id,data) values (abs(18787)%25,abs(-1371)%25); update ignore t2 set id=abs(6325)%25,data=abs(-4868)%25 where id=abs(11587)%25; insert into t2(id,data) values (abs(12412)%25,abs(10340)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-6476)%25),(abs(-31407)%25); replace into t2 select * from t1 where data=abs(118)%25; rollback; replace into t1(id,data) values (abs(9622)%25,abs(-26208)%25),(null,abs(2306)%25); rollback; insert into t1(data) values (abs(-22373)%25),(abs(-4436)%25),(abs(-11117)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-5999)%25),(abs(-6757)%25),(abs(-3278)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-23408)%25,abs(-31539)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(16702)%25; insert ignore into t1 select * from t2 where id=abs(14947)%25; insert ignore into t2(id,data) values (abs(-3978)%25,abs(-12113)%25); insert ignore into t1(id,data) values (abs(11896)%25,abs(3606)%25),(null,abs(-11960)%25); update ignore t2 set data=abs(9385)%25 where id=abs(-17938)%25; insert ignore into t1(id,data) values (abs(4849)%25,abs(9114)%25); replace into t2(id,data) values (abs(8369)%25,abs(-27311)%25); insert into t2(id,data) values (abs(-22790)%25,abs(-19526)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(25508)%25,abs(14521)%25),(abs(1531)%25,abs(-7948)%25),(abs(18394)%25,abs(10405)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(28160)%25),(null,abs(6154)%25),(abs(-32438)%25,abs(-26543)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(9085)%25),(abs(-30475)%25); insert into t1(id,data) values (abs(23824)%25,abs(-3333)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(21484)%25),(abs(21686)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-25810)%25,abs(8612)%25); insert into t1(id,data) values (abs(-12611)%25,abs(-29334)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-4288)%25,abs(-19802)%25),(null,abs(-17873)%25); rollback; insert into t1(data) values (abs(-22392)%25),(abs(-13203)%25),(abs(-23168)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-2037482429); insert ignore into t2(id,data) values (abs(-8413)%25,abs(30394)%25),(null,abs(-18713)%25); update ignore t2 set id=abs(-19013)%25,data=abs(31492)%25 where id=abs(1816)%25; insert ignore into t1(id,data) values (null,abs(-20649)%25),(null,abs(-24983)%25),(abs(28857)%25,abs(-14088)%25); insert ignore into t1(id,data) values (abs(-2048)%25,abs(23179)%25); insert into t1(data) values (abs(18058)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2(id,data) values (abs(-3026)%25,abs(-20318)%25),(abs(11674)%25,abs(-6743)%25); insert ignore into t2(id,data) values (abs(-22677)%25,abs(-4191)%25),(null,abs(32495)%25); replace into t2 select * from t1 where data=abs(-25979)%25; insert ignore into t2(id,data) values (abs(-9690)%25,abs(30920)%25); insert ignore into t2(data) values (abs(11607)%25),(abs(21586)%25); insert into t2(id,data) values (abs(27999)%25,abs(-7276)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(9836)%25,data=abs(-15817)%25 where id=abs(7188)%25; start transaction; insert ignore into t1(id,data) values (abs(-27324)%25,abs(16392)%25); replace into t2(id,data) values (null,abs(-8070)%25),(null,abs(-25199)%25),(abs(30382)%25,abs(-18506)%25); insert into t1(id,data) values (abs(29550)%25,abs(21952)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(22057)%25,abs(4798)%25),(abs(-16324)%25,abs(-12648)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(27112)%25,abs(12942)%25),(null,abs(-31448)%25); insert ignore into t2(data) values (abs(32261)%25),(abs(-27039)%25); insert ignore into t2(id,data) values (abs(-24390)%25,abs(-25737)%25); insert ignore into t2(id,data) values (abs(-23214)%25,abs(-1982)%25),(null,abs(29062)%25); replace into t1 select * from t2 where data=abs(24268)%25; insert ignore into t2(id,data) values (abs(19661)%25,abs(-7127)%25); insert ignore into t1 select * from t2 where data=abs(14882)%25; insert ignore into t1(id,data) values (abs(-8178)%25,abs(2202)%25),(abs(1929)%25,abs(25105)%25),(abs(-7677)%25,abs(15726)%25); update ignore t2 set id=abs(-848)%25,data=abs(12655)%25 where id=abs(-28130)%25; update ignore t1 set id=abs(6283)%25,data=abs(27946)%25 where data=abs(-7143)%25; rollback; rollback; insert ignore into t2(data) values (abs(14518)%25); update ignore t2 set data=abs(-13235)%25 where data=abs(-1292)%25; insert ignore into t1(id,data) values (abs(17154)%25,abs(3370)%25),(abs(22108)%25,abs(15502)%25); replace into t1(id,data) values (abs(21319)%25,abs(-5773)%25); update ignore t2 set id=abs(15270)%25,data=abs(20615)%25 where id=abs(-6325)%25; insert ignore into t2(id,data) values (abs(21961)%25,abs(2389)%25); insert into t1(data) values (abs(-19367)%25),(abs(17317)%25),(abs(892)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(-19818)%25),(abs(-7408)%25),(abs(-26810)%25); insert into t2(id,data) values (abs(-24179)%25,abs(27412)%25),(abs(16474)%25,abs(25054)%25),(abs(7012)%25,abs(-21102)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(23713)%25,abs(13885)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(31992)%25),(null,abs(10852)%25),(abs(-6219)%25,abs(-7778)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-19307)%25,abs(23230)%25),(abs(-29434)%25,abs(9442)%25) on duplicate key update id=values(id),data=values(data); start transaction; replace into t1 select * from t2 where data=abs(27877)%25; commit; replace into t2 select * from t1 where data=abs(-3008)%25; update ignore t1 set id=abs(-17011)%25,data=abs(30760)%25 where id=abs(-21403)%25; insert ignore into t1(id,data) values (abs(9375)%25,abs(14572)%25); start transaction; insert into t2(id,data) values (abs(-5177)%25,abs(-17394)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-2110544767); insert ignore into t2(data) values (abs(17953)%25),(abs(9239)%25); replace into t1 select * from t2 where data=abs(20700)%25; insert ignore into t1(data) values (abs(-9698)%25); insert ignore into t1(data) values (abs(-4206)%25),(abs(18949)%25),(abs(27600)%25); insert ignore into t2(id,data) values (abs(-9206)%25,abs(-24180)%25),(null,abs(-23486)%25); replace into t1(id,data) values (abs(-3578)%25,abs(792)%25),(null,abs(-25952)%25); update ignore t2 set data=abs(25249)%25 where data=abs(-26823)%25; insert ignore into t1(id,data) values (abs(-25478)%25,abs(-27159)%25),(null,abs(11139)%25); update ignore t2 set data=abs(-5987)%25 where data=abs(-27184)%25; insert ignore into t2(id,data) values (abs(-363)%25,abs(26071)%25),(null,abs(24829)%25); insert ignore into t1(id,data) values (null,abs(-12068)%25),(null,abs(4632)%25),(abs(-3928)%25,abs(29506)%25); rollback; update ignore t1 set id=abs(-1325)%25,data=abs(-548)%25 where id=abs(-23981)%25; update ignore t1 set id=abs(-8465)%25,data=abs(9455)%25 where id=abs(24914)%25; insert into t2(id,data) values (abs(-12884)%25,abs(-18230)%25),(abs(16297)%25,abs(-6316)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-28775)%25,abs(-24758)%25); replace into t2(id,data) values (null,abs(-28910)%25),(null,abs(859)%25),(abs(13816)%25,abs(-8903)%25); update ignore t2 set data=abs(-25621)%25 where id=abs(-26648)%25; insert into t2(data) values (abs(-28178)%25),(abs(21125)%25),(abs(25057)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-21293)%25),(abs(30761)%25),(abs(7873)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-1148)%25,abs(17828)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(5219)%25,abs(-23858)%25),(abs(-15509)%25,abs(-19312)%25),(abs(-32722)%25,abs(29295)%25); insert into t1(data) values (abs(-8048)%25),(abs(15832)%25),(abs(19249)%25) on duplicate key update id=values(id),data=values(data); start transaction; select @@autocommit; update ignore t2 set id=abs(-1845)%25,data=abs(29874)%25 where id=abs(-30285)%25; insert ignore into t2 select * from t1 where id=abs(20970)%25; insert into t2(id,data) values (abs(-27104)%25,abs(-29708)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-11395)%25,data=abs(20409)%25 where id=abs(-30932)%25; update ignore t2 set data=abs(28729)%25 where data=abs(15818)%25; insert into t2(id,data) values (abs(-4508)%25,abs(9319)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(30685)%25,data=abs(8510)%25 where id=abs(24181)%25; replace into t2 select * from t1 where data=abs(-5078)%25; insert into t2(data) values (abs(32648)%25),(abs(5881)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(5779)%25,abs(8178)%25),(null,abs(18400)%25); insert ignore into t1(data) values (abs(-18488)%25); commit; replace into t1 select * from t2 where id=abs(29232)%25; rollback; start transaction; update ignore t1 set id=abs(3817)%25,data=abs(-19943)%25 where id=abs(-10483)%25; update ignore t1 set id=abs(-5930)%25,data=abs(-12617)%25 where data=abs(-16231)%25; insert into t2(id,data) values (abs(11401)%25,abs(26983)%25),(null,abs(-26903)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-6503)%25,abs(-3266)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-2067562429); delete from t1 where data=abs(-9500)%25; insert into t1(data) values (abs(-23178)%25),(abs(-15767)%25),(abs(-143)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(-29454)%25),(null,abs(25084)%25),(abs(-10423)%25,abs(-6242)%25); insert into t1(id,data) values (null,abs(-24566)%25),(null,abs(-3932)%25),(abs(-14296)%25,abs(-4033)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(16125)%25),(abs(8276)%25),(abs(13807)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(32337)%25,abs(28077)%25); insert into t2(data) values (abs(-23893)%25),(abs(12562)%25) on duplicate key update id=values(id),data=values(data); rollback; update ignore t2 set id=abs(4113)%25,data=abs(-9798)%25 where id=abs(905)%25; set sql_mode=abs(-2096601151); insert into t1(id,data) values (abs(9264)%25,abs(-28895)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(16891)%25,abs(5257)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(1002)%25,abs(10993)%25),(null,abs(17971)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2(data) values (abs(7787)%25),(abs(-19123)%25),(abs(-11399)%25); insert ignore into t1(data) values (abs(-32030)%25); insert into t2(id,data) values (abs(1721)%25,abs(-18828)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t2(data) values (abs(-19304)%25),(abs(-23185)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(5630)%25),(null,abs(-26690)%25),(abs(7021)%25,abs(1366)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(-3201)%25; insert into t2(id,data) values (abs(-12572)%25,abs(29843)%25),(abs(15442)%25,abs(-19763)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(17247)%25,abs(-8999)%25),(null,abs(27136)%25); delete from t1 where data=abs(-30269)%25; set sql_mode=abs(-2121826099); replace into t1 select * from t2 where data=abs(-10544)%25; start transaction; insert into t1(id,data) values (abs(25872)%25,abs(15175)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-14708)%25,abs(-13325)%25),(abs(1108)%25,abs(-8023)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (null,abs(-1332)%25),(null,abs(-9578)%25),(abs(9322)%25,abs(-28865)%25); set session completion_type=1; start transaction; insert ignore into t2(id,data) values (abs(-17880)%25,abs(-65)%25),(abs(-11010)%25,abs(-8123)%25),(abs(-20144)%25,abs(14574)%25); replace into t2 select * from t1 where data=abs(7060)%25; insert ignore into t1(id,data) values (abs(-3588)%25,abs(-25934)%25); insert ignore into t1 select * from t2 where id=abs(-23976)%25; update ignore t1 set data=abs(-5645)%25 where id=abs(10702)%25; update ignore t2 set data=abs(8106)%25 where data=abs(-29222)%25; commit; start transaction; replace into t2(id,data) values (abs(331)%25,abs(-427)%25); insert into t2(data) values (abs(12560)%25),(abs(22186)%25),(abs(30962)%25) on duplicate key update id=values(id),data=values(data); rollback; insert into t1(data) values (abs(17952)%25),(abs(-28567)%25),(abs(6366)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2 select * from t1 where id=abs(19768)%25; insert ignore into t2(id,data) values (abs(1227)%25,abs(-26129)%25),(null,abs(-23465)%25); commit; insert ignore into t2(id,data) values (abs(-26183)%25,abs(31297)%25); insert ignore into t2(data) values (abs(-10781)%25),(abs(12172)%25); set sql_mode=abs(-1993239513); delete from t2 where data=abs(-3324)%25; update ignore t2 set data=abs(-4965)%25 where data=abs(-23843)%25; insert into t2(id,data) values (abs(14777)%25,abs(23722)%25),(abs(7868)%25,abs(21925)%25),(abs(23492)%25,abs(-138)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-16258)%25,abs(7213)%25); insert ignore into t1(id,data) values (abs(1816)%25,abs(32181)%25); rollback; start transaction; update ignore t2 set data=abs(-6259)%25 where data=abs(-5443)%25; insert ignore into t2 select * from t1 where id=abs(10027)%25; insert ignore into t1(data) values (abs(7990)%25),(abs(355)%25),(abs(-31725)%25); start transaction; insert ignore into t1 select * from t2 where data=abs(-18785)%25; insert ignore into t1(id,data) values (abs(-29103)%25,abs(-2771)%25); insert into t2(data) values (abs(17701)%25),(abs(23383)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(22219)%25,abs(-30027)%25),(abs(5437)%25,abs(-8195)%25),(abs(-23333)%25,abs(9277)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-12365)%25,abs(-15483)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-11239)%25 where id=abs(15199)%25; insert ignore into t1(data) values (abs(-12213)%25),(abs(2665)%25),(abs(-4543)%25); insert ignore into t1(id,data) values (abs(18282)%25,abs(-4209)%25); rollback; insert into t2(id,data) values (abs(-22472)%25,abs(32580)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(2254)%25,data=abs(-4718)%25 where id=abs(-16295)%25; start transaction; update ignore t1 set data=abs(25180)%25 where id=abs(31375)%25; replace into t1(id,data) values (abs(16007)%25,abs(29940)%25); update ignore t1 set id=abs(-12332)%25,data=abs(-17518)%25 where id=abs(-5510)%25; insert ignore into t2(data) values (abs(-9038)%25),(abs(-18823)%25); insert into t2(id,data) values (abs(-16142)%25,abs(-14507)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(24957)%25),(abs(-21062)%25),(abs(-5062)%25); replace into t2(id,data) values (abs(28777)%25,abs(9302)%25),(null,abs(19504)%25); insert ignore into t2(id,data) values (abs(-14443)%25,abs(-16430)%25); insert ignore into t1(data) values (abs(32527)%25),(abs(-15060)%25),(abs(31113)%25); insert into t1(id,data) values (abs(-5078)%25,abs(6397)%25),(abs(-19372)%25,abs(-5702)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1400644414); commit; update ignore t2 set data=abs(-31859)%25 where data=abs(15268)%25; rollback; replace into t1 select * from t2 where id=abs(16024)%25; insert into t1(data) values (abs(16414)%25),(abs(-3811)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(5643)%25,abs(-20203)%25); update ignore t1 set id=abs(463)%25,data=abs(18707)%25 where data=abs(8989)%25; insert into t1(data) values (abs(26629)%25),(abs(-29292)%25),(abs(-17283)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(id,data) values (abs(26405)%25,abs(2827)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(12514)%25; replace into t2(id,data) values (null,abs(30337)%25),(null,abs(-27845)%25),(abs(-18860)%25,abs(-12529)%25); insert ignore into t2(id,data) values (abs(29690)%25,abs(-15623)%25),(abs(-8279)%25,abs(5989)%25),(abs(-18242)%25,abs(-9645)%25); insert into t1(data) values (abs(3938)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t1(data) values (abs(10682)%25); insert ignore into t2(id,data) values (abs(-30002)%25,abs(-21353)%25),(null,abs(-22993)%25); replace into t2 select * from t1 where id=abs(-12798)%25; insert into t2(id,data) values (abs(-10401)%25,abs(13140)%25) on duplicate key update id=values(id),data=values(data); rollback; insert ignore into t1(data) values (abs(2208)%25); insert into t2(id,data) values (abs(12326)%25,abs(2677)%25),(null,abs(6807)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(3532)%25,abs(-25588)%25); update ignore t1 set id=abs(-10078)%25,data=abs(8632)%25 where id=abs(7182)%25; update ignore t2 set data=abs(-5188)%25 where id=abs(24829)%25; replace into t1 select * from t2 where data=abs(-13823)%25; insert into t1(id,data) values (abs(5326)%25,abs(-17714)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(9486)%25; replace into t1(id,data) values (null,abs(-32543)%25),(null,abs(-5967)%25),(abs(26486)%25,abs(-23081)%25); insert into t1(id,data) values (abs(17820)%25,abs(28211)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-9618)%25),(abs(25747)%25),(abs(-29729)%25); insert ignore into t2(data) values (abs(15934)%25); insert ignore into t1(data) values (abs(-31172)%25); delete from t1 where data=abs(29160)%25; insert into t1(data) values (abs(-24014)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(-7128)%25),(null,abs(-6680)%25),(abs(-27003)%25,abs(17497)%25); insert into t2(data) values (abs(-1574)%25),(abs(832)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-5196)%25,abs(-2793)%25); start transaction; commit; insert ignore into t2(id,data) values (abs(-25832)%25,abs(-17374)%25),(null,abs(27900)%25); insert into t1(id,data) values (abs(2337)%25,abs(30908)%25),(abs(-12817)%25,abs(30058)%25) on duplicate key update id=values(id),data=values(data); replace into t2 select * from t1 where id=abs(-605)%25; insert into t1(id,data) values (abs(-9878)%25,abs(29265)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-14327)%25,abs(-29263)%25),(null,abs(-24283)%25); insert into t1(data) values (abs(-12641)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(-22637)%25; insert ignore into t2(id,data) values (abs(-26888)%25,abs(-25205)%25),(null,abs(-479)%25); insert into t2(id,data) values (abs(-31664)%25,abs(-10753)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where data=abs(887)%25; insert ignore into t2(data) values (abs(-1529)%25),(abs(16905)%25); update ignore t2 set data=abs(-27945)%25 where id=abs(-604)%25; rollback; insert into t2(id,data) values (abs(-2576)%25,abs(-19373)%25),(abs(3520)%25,abs(-9995)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-2850)%25; insert ignore into t2(data) values (abs(-27854)%25),(abs(9460)%25),(abs(2950)%25); rollback; replace into t2(id,data) values (abs(-14277)%25,abs(-7163)%25); start transaction; replace into t2 select * from t1 where id=abs(11197)%25; insert into t1(id,data) values (abs(3777)%25,abs(-486)%25) on duplicate key update id=values(id),data=values(data); rollback; update ignore t1 set id=abs(-25755)%25,data=abs(-26958)%25 where id=abs(30403)%25; start transaction; insert ignore into t1(id,data) values (abs(6352)%25,abs(24790)%25); update ignore t2 set data=abs(-11777)%25 where data=abs(-9903)%25; insert ignore into t2 select * from t1 where id=abs(5658)%25; insert ignore into t2(data) values (abs(-13934)%25),(abs(26165)%25); insert ignore into t1(data) values (abs(-12965)%25),(abs(24762)%25),(abs(-25670)%25); rollback; update ignore t2 set data=abs(16024)%25 where data=abs(6547)%25; update ignore t2 set data=abs(22831)%25 where data=abs(-26690)%25; rollback; rollback; insert into t2(id,data) values (abs(6799)%25,abs(-25052)%25),(null,abs(-24521)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (null,abs(-9780)%25),(null,abs(21649)%25),(abs(13474)%25,abs(-29882)%25); replace into t2(id,data) values (abs(-22840)%25,abs(-9578)%25),(null,abs(9213)%25); insert into t2(id,data) values (abs(6174)%25,abs(-32389)%25),(abs(16374)%25,abs(-28447)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-19748)%25,abs(-6263)%25),(abs(-28265)%25,abs(10065)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-19874)%25,abs(-23075)%25) on duplicate key update id=values(id),data=values(data); start transaction; delete from t2 where id=abs(-9059)%25; insert ignore into t2(id,data) values (abs(-27338)%25,abs(-13778)%25); insert into t1(id,data) values (abs(11279)%25,abs(-5282)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-19049)%25,abs(14299)%25),(null,abs(-19178)%25); replace into t1 select * from t2 where data=abs(4687)%25; insert into t1(id,data) values (abs(-31688)%25,abs(20481)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(6467)%25,abs(-21866)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-1693)%25,abs(-12386)%25),(abs(-14948)%25,abs(-1391)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-15125)%25,abs(-28178)%25); insert ignore into t2 select * from t1 where id=abs(-27488)%25; insert ignore into t2 select * from t1 where id=abs(622)%25; update ignore t1 set id=abs(29707)%25,data=abs(1063)%25 where id=abs(15682)%25; start transaction; start transaction; replace into t1(id,data) values (null,abs(-11008)%25),(null,abs(-2534)%25),(abs(4182)%25,abs(-28326)%25); update ignore t2 set data=abs(7672)%25 where id=abs(-3584)%25; rollback; replace into t2(id,data) values (abs(27523)%25,abs(21643)%25),(null,abs(22813)%25); insert into t2(id,data) values (abs(-12338)%25,abs(-14588)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(4939)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-31638)%25,abs(28857)%25) on duplicate key update id=values(id),data=values(data); start transaction; update ignore t1 set data=abs(-3256)%25 where id=abs(28211)%25; insert into t1(id,data) values (abs(1983)%25,abs(-24070)%25),(abs(-17096)%25,abs(6994)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-6374)%25,abs(-13277)%25),(abs(-11523)%25,abs(-30931)%25),(abs(5812)%25,abs(-29276)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-28993)%25,abs(22582)%25) on duplicate key update id=values(id),data=values(data); start transaction; delete from t1 where data=abs(-11774)%25; insert into t1(data) values (abs(14052)%25),(abs(15367)%25),(abs(14231)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where data=abs(6901)%25; insert ignore into t2(id,data) values (abs(32525)%25,abs(-11676)%25),(abs(-5443)%25,abs(-29619)%25); delete from t2 where data=abs(-14003)%25; insert ignore into t1(id,data) values (abs(-23173)%25,abs(717)%25),(abs(-19239)%25,abs(-19448)%25); commit; insert ignore into t1(id,data) values (null,abs(22771)%25),(null,abs(24267)%25),(abs(-28640)%25,abs(1082)%25); insert ignore into t1(id,data) values (abs(5629)%25,abs(-8285)%25); rollback; insert ignore into t2(id,data) values (abs(20748)%25,abs(11267)%25),(abs(10810)%25,abs(-9096)%25); insert ignore into t2(data) values (abs(26362)%25); insert ignore into t2(id,data) values (abs(-20968)%25,abs(21180)%25),(null,abs(-8304)%25); insert ignore into t2(id,data) values (abs(27000)%25,abs(28863)%25),(null,abs(-302)%25); insert into t2(data) values (abs(-6333)%25),(abs(19255)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(15139)%25,data=abs(24917)%25 where id=abs(-8174)%25; start transaction; update ignore t1 set id=abs(31074)%25,data=abs(5296)%25 where id=abs(-15212)%25; insert into t2(id,data) values (abs(-12943)%25,abs(-11288)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(8132)%25,data=abs(18567)%25 where id=abs(10125)%25; replace into t1(id,data) values (abs(-31353)%25,abs(100)%25); start transaction; insert ignore into t2(id,data) values (abs(-18638)%25,abs(-4144)%25); insert into t1(id,data) values (abs(-17564)%25,abs(-3069)%25),(null,abs(-9731)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(16070)%25,abs(-7100)%25),(abs(-26145)%25,abs(24007)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(8756)%25; insert into t2(data) values (abs(-21713)%25),(abs(27400)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-29138)%25),(abs(19289)%25),(abs(32152)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where id=abs(-15632)%25; insert ignore into t2(id,data) values (abs(-6653)%25,abs(25056)%25); update ignore t1 set id=abs(943)%25,data=abs(-32768)%25 where id=abs(-11870)%25; commit; rollback; insert into t2(id,data) values (abs(6073)%25,abs(25210)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where data=abs(13239)%25; replace into t1 select * from t2 where data=abs(-1048)%25; insert ignore into t2(data) values (abs(-2952)%25); insert ignore into t1 select * from t2 where data=abs(15464)%25; rollback; insert into t2(id,data) values (abs(-6083)%25,abs(-18477)%25),(null,abs(-30153)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(29400)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-1228)%25,abs(-28341)%25),(null,abs(20782)%25); replace into t1(id,data) values (null,abs(-13503)%25),(null,abs(-2683)%25),(abs(32597)%25,abs(-17038)%25); rollback; insert into t1(data) values (abs(-29644)%25),(abs(-2444)%25),(abs(-19209)%25) on duplicate key update id=values(id),data=values(data); start transaction; delete from t2 where data=abs(-25468)%25; update ignore t1 set id=abs(13744)%25,data=abs(14266)%25 where id=abs(9970)%25; insert ignore into t2(id,data) values (abs(13336)%25,abs(12979)%25); rollback; insert into t2(data) values (abs(-27158)%25),(abs(-11564)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-30081)%25),(abs(27346)%25),(abs(32228)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(29430)%25; commit; update ignore t2 set id=abs(-14143)%25,data=abs(-13866)%25 where id=abs(-32324)%25; insert ignore into t1 select * from t2 where data=abs(-2072)%25; start transaction; replace into t2(id,data) values (abs(-603)%25,abs(20609)%25),(null,abs(-16394)%25); insert ignore into t2(id,data) values (abs(30922)%25,abs(-18308)%25),(abs(14672)%25,abs(21661)%25); commit; insert into t1(id,data) values (abs(-25601)%25,abs(15177)%25),(abs(-1046)%25,abs(28907)%25),(abs(26887)%25,abs(15751)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-22268)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(14419)%25; update ignore t1 set id=abs(-11371)%25,data=abs(-12588)%25 where id=abs(23574)%25; insert ignore into t1(id,data) values (abs(31465)%25,abs(-17702)%25),(abs(-2491)%25,abs(-25234)%25); update ignore t2 set data=abs(28377)%25 where id=abs(-16160)%25; insert ignore into t1 select * from t2 where data=abs(6073)%25; insert into t1(id,data) values (null,abs(-10016)%25),(null,abs(-6113)%25),(abs(-1847)%25,abs(-25229)%25) on duplicate key update id=values(id),data=values(data); start transaction; update ignore t1 set id=abs(-20233)%25,data=abs(-19022)%25 where id=abs(-2133)%25; insert into t2(data) values (abs(-4448)%25),(abs(26302)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-13892)%25 where data=abs(-18097)%25; insert ignore into t2(id,data) values (abs(-2893)%25,abs(-10520)%25),(null,abs(11470)%25); delete from t1 where data=abs(12991)%25; insert ignore into t1 select * from t2 where data=abs(1169)%25; insert ignore into t2(id,data) values (abs(-30674)%25,abs(-16829)%25),(null,abs(28942)%25); delete from t1 where data=abs(15439)%25; insert ignore into t1(id,data) values (abs(-11393)%25,abs(-20783)%25); rollback; insert ignore into t1(id,data) values (abs(6297)%25,abs(13213)%25); insert into t2(id,data) values (abs(-10970)%25,abs(-326)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where id=abs(11377)%25; set sql_mode=abs(-2088841321); insert into t2(id,data) values (abs(3293)%25,abs(22204)%25),(abs(-8020)%25,abs(-27107)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-27053)%25,abs(22062)%25); insert ignore into t1 select * from t2 where data=abs(-21465)%25; start transaction; delete from t1 where data=abs(14416)%25; insert into t2(data) values (abs(999)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(2704)%25,abs(6227)%25) on duplicate key update id=values(id),data=values(data); commit; start transaction; insert into t1(data) values (abs(16941)%25),(abs(8327)%25),(abs(-10265)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(15718)%25; insert into t1(data) values (abs(-6738)%25),(abs(29569)%25),(abs(16597)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(7359)%25,abs(881)%25); update ignore t1 set id=abs(-29358)%25,data=abs(-29598)%25 where id=abs(-21328)%25; commit; insert into t1(id,data) values (abs(2609)%25,abs(32577)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-18422)%25,abs(19939)%25),(abs(-333)%25,abs(20380)%25); insert into t1(id,data) values (abs(-20769)%25,abs(-18541)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(18387)%25,abs(-9288)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(-30283)%25),(null,abs(-15873)%25),(abs(-4805)%25,abs(-29022)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(11872)%25,abs(30507)%25); insert into t1(data) values (abs(13176)%25),(abs(32612)%25),(abs(8865)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(-30538)%25; insert into t2(id,data) values (abs(-10620)%25,abs(-14516)%25),(null,abs(14259)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(25864)%25 where data=abs(19162)%25; insert ignore into t1(id,data) values (abs(23157)%25,abs(14169)%25); update ignore t1 set id=abs(27839)%25,data=abs(20065)%25 where data=abs(-17714)%25; rollback; commit; insert into t2(data) values (abs(-31079)%25),(abs(14064)%25),(abs(-5012)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-30958)%25; commit; commit; replace into t1(id,data) values (abs(19747)%25,abs(-25628)%25); insert ignore into t2(id,data) values (abs(8512)%25,abs(-11363)%25),(abs(-15751)%25,abs(30297)%25),(abs(24327)%25,abs(10254)%25); insert ignore into t2(id,data) values (abs(8347)%25,abs(-29153)%25),(null,abs(-128)%25); update ignore t1 set id=abs(-5741)%25,data=abs(-4393)%25 where id=abs(-599)%25; insert into t2(id,data) values (null,abs(-22469)%25),(null,abs(-27645)%25),(abs(-8138)%25,abs(-7293)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(17048)%25,abs(3862)%25),(null,abs(-1891)%25); set sql_mode=abs(-1894950109); replace into t2(id,data) values (null,abs(24550)%25),(null,abs(21116)%25),(abs(24764)%25,abs(31840)%25); insert into t1(id,data) values (abs(24015)%25,abs(4422)%25),(abs(-15968)%25,abs(6107)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(2296)%25; replace into t2 select * from t1 where data=abs(-23285)%25; insert into t1(id,data) values (abs(-6667)%25,abs(2498)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-29117)%25),(abs(14926)%25),(abs(22803)%25); insert into t1(id,data) values (null,abs(3390)%25),(null,abs(-8080)%25),(abs(26052)%25,abs(18577)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-18244)%25,abs(-28175)%25),(abs(5338)%25,abs(29542)%25),(abs(-20783)%25,abs(-24671)%25); update ignore t2 set data=abs(18760)%25 where data=abs(14374)%25; replace into t2(id,data) values (abs(17862)%25,abs(2453)%25); update ignore t1 set id=abs(29224)%25,data=abs(27453)%25 where id=abs(29842)%25; set sql_mode=abs(-2026053847); insert into t1(id,data) values (null,abs(-16189)%25),(null,abs(3417)%25),(abs(26896)%25,abs(6988)%25) on duplicate key update id=values(id),data=values(data); rollback; replace into t2(id,data) values (abs(-16133)%25,abs(-27701)%25); insert into t1(id,data) values (abs(17494)%25,abs(7167)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1985209667); insert into t1(data) values (abs(-19887)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-569)%25,abs(26912)%25); insert ignore into t1(data) values (abs(-12557)%25),(abs(-17999)%25),(abs(15548)%25); insert ignore into t2 select * from t1 where data=abs(-22478)%25; insert ignore into t2(id,data) values (abs(17244)%25,abs(7487)%25); update ignore t1 set id=abs(15501)%25,data=abs(-20168)%25 where id=abs(15286)%25; insert into t1(data) values (abs(19266)%25),(abs(22114)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(-7556)%25; insert ignore into t1(data) values (abs(18353)%25),(abs(24197)%25),(abs(20225)%25); insert ignore into t1(id,data) values (abs(-9050)%25,abs(-7463)%25),(null,abs(-12126)%25); rollback; insert ignore into t2(id,data) values (abs(-12110)%25,abs(-4132)%25),(abs(-9749)%25,abs(11227)%25),(abs(-17982)%25,abs(27219)%25); insert ignore into t1 select * from t2 where data=abs(4887)%25; delete from t1 where data=abs(-29367)%25; insert into t1(data) values (abs(24352)%25),(abs(29824)%25),(abs(17059)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(19315)%25,abs(-30540)%25),(null,abs(18712)%25); replace into t1 select * from t2 where data=abs(23470)%25; start transaction; replace into t2(id,data) values (null,abs(-9908)%25),(null,abs(-14936)%25),(abs(746)%25,abs(-3998)%25); insert ignore into t2(id,data) values (abs(-21827)%25,abs(28864)%25),(null,abs(21922)%25); insert into t1(id,data) values (abs(-11961)%25,abs(32698)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-3548)%25 where data=abs(-13185)%25; start transaction; replace into t2(id,data) values (abs(-8483)%25,abs(14603)%25),(null,abs(-16193)%25); replace into t1 select * from t2 where data=abs(8023)%25; start transaction; delete from t2 where id=abs(-22452)%25; start transaction; insert into t1(data) values (abs(-15335)%25),(abs(30040)%25),(abs(-12020)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-19958)%25,abs(-18653)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(-9110)%25; delete from t1 where data=abs(15517)%25; insert into t1(data) values (abs(-23027)%25),(abs(-10608)%25),(abs(8077)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1855052907); update ignore t1 set data=abs(-2105)%25 where data=abs(25348)%25; insert ignore into t1 select * from t2 where data=abs(-13048)%25; insert ignore into t1(id,data) values (null,abs(-2294)%25),(null,abs(-13448)%25),(abs(13087)%25,abs(20506)%25); insert into t2(id,data) values (abs(-24918)%25,abs(-9427)%25),(abs(12598)%25,abs(-32060)%25),(abs(-25710)%25,abs(-515)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-25346)%25,abs(-30777)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-9676)%25),(abs(-8408)%25) on duplicate key update id=values(id),data=values(data); rollback; set sql_mode=abs(-1694851183); update ignore t1 set id=abs(-7608)%25,data=abs(-9490)%25 where id=abs(103)%25; rollback; insert ignore into t2(id,data) values (abs(7639)%25,abs(12514)%25); insert ignore into t1(id,data) values (abs(-25372)%25,abs(-13448)%25); commit; update ignore t2 set data=abs(-1257)%25 where data=abs(-18478)%25; insert into t1(data) values (abs(17212)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(id,data) values (abs(26705)%25,abs(29784)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(16454)%25); insert ignore into t1(data) values (abs(2110)%25),(abs(-17694)%25),(abs(4780)%25); set sql_mode=abs(-1277832293); replace into t2 select * from t1 where data=abs(23744)%25; commit; insert into t1(data) values (abs(24682)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-6201)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-31709)%25; rollback; replace into t2(id,data) values (null,abs(16035)%25),(null,abs(-29734)%25),(abs(1763)%25,abs(11596)%25); start transaction; update ignore t2 set id=abs(24568)%25,data=abs(9517)%25 where id=abs(5956)%25; insert ignore into t1(data) values (abs(-31146)%25),(abs(13799)%25),(abs(12216)%25); insert ignore into t2 select * from t1 where id=abs(21052)%25; insert ignore into t1(data) values (abs(32513)%25); update ignore t2 set id=abs(13267)%25,data=abs(-7688)%25 where data=abs(20264)%25; replace into t2(id,data) values (null,abs(19267)%25),(null,abs(20769)%25),(abs(-25718)%25,abs(7414)%25); insert into t2(id,data) values (abs(-7628)%25,abs(32036)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(6947)%25,data=abs(4462)%25 where data=abs(-29537)%25; delete from t2 where id=abs(10093)%25; insert into t2(id,data) values (null,abs(-28158)%25),(null,abs(8442)%25),(abs(19357)%25,abs(-10805)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(13165)%25; replace into t2 select * from t1 where data=abs(-1022)%25; insert ignore into t2(id,data) values (abs(30523)%25,abs(23944)%25); insert into t2(id,data) values (null,abs(20881)%25),(null,abs(-14813)%25),(abs(-27170)%25,abs(-20045)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2 select * from t1 where data=abs(20876)%25; rollback; insert ignore into t2(data) values (abs(-14840)%25),(abs(20089)%25); insert into t1(id,data) values (abs(-29752)%25,abs(-20025)%25),(abs(-20050)%25,abs(-21434)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(8959)%25,abs(-19553)%25),(abs(574)%25,abs(79)%25),(abs(30358)%25,abs(-31667)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(5942)%25),(abs(30672)%25),(abs(-31690)%25); start transaction; insert into t2(id,data) values (abs(-20846)%25,abs(22275)%25),(abs(32002)%25,abs(14482)%25),(abs(4657)%25,abs(-20562)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(11400)%25,abs(-6839)%25),(abs(-30728)%25,abs(4882)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-3248)%25,abs(969)%25),(abs(16144)%25,abs(17005)%25); insert into t1(id,data) values (abs(21307)%25,abs(-29943)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(22150)%25,abs(5498)%25),(null,abs(4500)%25); insert into t2(id,data) values (abs(-573)%25,abs(16600)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(6622)%25); insert ignore into t1(data) values (abs(-13433)%25),(abs(-2939)%25),(abs(19672)%25); insert ignore into t1(data) values (abs(28834)%25),(abs(7417)%25),(abs(1709)%25); insert ignore into t1 select * from t2 where data=abs(-8125)%25; start transaction; replace into t2(id,data) values (null,abs(-26468)%25),(null,abs(26734)%25),(abs(23616)%25,abs(29453)%25); delete from t1 where data=abs(19906)%25; insert into t1(id,data) values (abs(-14639)%25,abs(18285)%25),(abs(-7097)%25,abs(2292)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(-6362)%25),(null,abs(-30677)%25),(abs(27657)%25,abs(-30254)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(18779)%25,abs(29877)%25),(null,abs(-15830)%25); start transaction; update ignore t2 set data=abs(-1902)%25 where data=abs(-32188)%25; insert into t1(data) values (abs(-12709)%25),(abs(-25727)%25),(abs(22852)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(-24929)%25),(abs(-15336)%25),(abs(21742)%25); insert into t1(data) values (abs(11196)%25),(abs(5064)%25),(abs(29743)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (null,abs(-31815)%25),(null,abs(20362)%25),(abs(-15599)%25,abs(-7642)%25); start transaction; start transaction; insert into t2(data) values (abs(-8753)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-7748)%25; start transaction; insert into t2(id,data) values (abs(19873)%25,abs(4857)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(9307)%25,abs(13506)%25),(abs(31332)%25,abs(-7919)%25),(abs(-15319)%25,abs(10343)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(10975)%25),(null,abs(31957)%25),(abs(7492)%25,abs(-22782)%25); start transaction; start transaction; update ignore t2 set data=abs(16581)%25 where data=abs(28606)%25; update ignore t1 set data=abs(13717)%25 where id=abs(30371)%25; insert into t1(id,data) values (null,abs(-21821)%25),(null,abs(-17559)%25),(abs(12571)%25,abs(-20117)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-2037874033); insert into t2(data) values (abs(-13813)%25),(abs(-25604)%25),(abs(-27192)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(19918)%25,abs(-21582)%25),(null,abs(-9665)%25); rollback; insert ignore into t1(id,data) values (abs(-258)%25,abs(29440)%25); insert into t1(data) values (abs(20382)%25),(abs(-14748)%25),(abs(8245)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-9488)%25,abs(-12905)%25); start transaction; insert ignore into t2 select * from t1 where data=abs(18067)%25; rollback; rollback; set session autocommit=1; rollback; update ignore t1 set id=abs(32550)%25,data=abs(-32598)%25 where data=abs(-4496)%25; replace into t1 select * from t2 where data=abs(21688)%25; insert ignore into t1(id,data) values (abs(-2298)%25,abs(-27653)%25); insert ignore into t1(id,data) values (abs(19147)%25,abs(-27065)%25); start transaction; start transaction; set sql_mode=abs(-1684267257); insert ignore into t1(id,data) values (abs(6242)%25,abs(21349)%25); insert ignore into t2(id,data) values (abs(12778)%25,abs(-29213)%25); insert into t2(id,data) values (abs(-12878)%25,abs(-28603)%25),(null,abs(18692)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(14497)%25); insert ignore into t1(id,data) values (abs(11274)%25,abs(11779)%25); commit work no release; insert ignore into t2 select * from t1 where id=abs(-6573)%25; insert into t2(id,data) values (abs(32374)%25,abs(-13454)%25),(null,abs(19324)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(9568)%25; insert ignore into t1 select * from t2 where id=abs(15267)%25; update ignore t1 set id=abs(29425)%25,data=abs(32559)%25 where id=abs(-23144)%25; replace into t2(id,data) values (null,abs(23709)%25),(null,abs(7522)%25),(abs(4204)%25,abs(-20705)%25); commit; replace into t2(id,data) values (abs(1499)%25,abs(-4028)%25),(null,abs(17412)%25); insert into t2(id,data) values (abs(-29126)%25,abs(-26998)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(data) values (abs(27079)%25),(abs(-1145)%25),(abs(21636)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(26556)%25,abs(14302)%25),(null,abs(-28450)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-31286)%25 where data=abs(3142)%25; insert ignore into t2(id,data) values (abs(13318)%25,abs(25620)%25),(null,abs(20341)%25); start transaction; insert into t2(id,data) values (abs(-8663)%25,abs(11851)%25),(null,abs(11602)%25) on duplicate key update id=values(id),data=values(data); commit; rollback; start transaction; start transaction; insert ignore into t1(data) values (abs(-24738)%25),(abs(-3317)%25),(abs(25499)%25); start transaction; update ignore t1 set id=abs(-9036)%25,data=abs(-2978)%25 where id=abs(24970)%25; update ignore t1 set id=abs(30407)%25,data=abs(22278)%25 where id=abs(-3170)%25; insert into t2(id,data) values (abs(-11608)%25,abs(-14459)%25),(abs(-15920)%25,abs(17748)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(-11366)%25; update ignore t1 set data=abs(-29189)%25 where data=abs(-3159)%25; insert into t1(id,data) values (abs(28162)%25,abs(-9334)%25),(null,abs(-24404)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(19666)%25),(null,abs(1497)%25),(abs(-29147)%25,abs(10297)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set id=abs(27253)%25,data=abs(-23693)%25 where id=abs(3370)%25; insert into t1(id,data) values (abs(27904)%25,abs(-30363)%25),(null,abs(13609)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(11793)%25,abs(14341)%25); replace into t2(id,data) values (null,abs(24109)%25),(null,abs(-9041)%25),(abs(-12898)%25,abs(32180)%25); insert ignore into t2(id,data) values (abs(-27473)%25,abs(-2413)%25),(null,abs(20524)%25); commit; update ignore t1 set id=abs(-10171)%25,data=abs(-23775)%25 where data=abs(-29998)%25; insert into t2(data) values (abs(-9202)%25),(abs(21390)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-8808)%25,abs(-12881)%25),(abs(-2438)%25,abs(9440)%25),(abs(-3518)%25,abs(28009)%25); rollback; start transaction; insert into t1(id,data) values (abs(7723)%25,abs(-32768)%25),(abs(-7480)%25,abs(-1088)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(-19053)%25; rollback; insert into t1(data) values (abs(19715)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(id,data) values (abs(-24387)%25,abs(-4718)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-5111)%25,abs(-2111)%25),(null,abs(-2891)%25); rollback; rollback; update ignore t1 set id=abs(-22058)%25,data=abs(-18733)%25 where data=abs(29176)%25; insert into t1(id,data) values (abs(13702)%25,abs(16582)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(-25571)%25; set sql_mode=abs(-2134590767); start transaction; replace into t1 select * from t2 where data=abs(-6802)%25; insert into t2(id,data) values (null,abs(-9932)%25),(null,abs(17614)%25),(abs(-2963)%25,abs(-7203)%25) on duplicate key update id=values(id),data=values(data); start transaction; replace into t1 select * from t2 where data=abs(1997)%25; insert into t1(data) values (abs(-19110)%25),(abs(-15423)%25),(abs(23457)%25) on duplicate key update id=values(id),data=values(data); rollback; replace into t2(id,data) values (abs(23377)%25,abs(-20453)%25); insert into t1(id,data) values (abs(-29913)%25,abs(13882)%25),(abs(16557)%25,abs(19889)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(15575)%25,abs(29482)%25),(null,abs(-24438)%25); xa end 'xid1'; insert into t2(id,data) values (abs(-32495)%25,abs(13267)%25),(null,abs(-1583)%25) on duplicate key update id=values(id),data=values(data); commit; insert ignore into t1(id,data) values (abs(28310)%25,abs(21986)%25),(null,abs(-11792)%25); xa commit 'xid1'; replace into t2(id,data) values (abs(-19514)%25,abs(-31025)%25),(null,abs(20067)%25); insert into t2(id,data) values (null,abs(-26970)%25),(null,abs(-7309)%25),(abs(8761)%25,abs(-11722)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (null,abs(5221)%25),(null,abs(19432)%25),(abs(5289)%25,abs(32040)%25); start transaction; rollback; insert ignore into t1(id,data) values (abs(13393)%25,abs(24737)%25),(abs(-14684)%25,abs(31496)%25),(abs(-31292)%25,abs(23496)%25); insert into t2(id,data) values (abs(-19168)%25,abs(-13889)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-14087)%25),(abs(-19658)%25),(abs(-5488)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(24722)%25 where data=abs(29692)%25; rollback; insert ignore into t2(id,data) values (abs(29088)%25,abs(559)%25),(abs(-3848)%25,abs(-12116)%25); start transaction; insert into t2(id,data) values (abs(32752)%25,abs(9754)%25),(abs(8632)%25,abs(4006)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(11332)%25; update ignore t2 set data=abs(-23063)%25 where data=abs(-22905)%25; insert ignore into t2(id,data) values (abs(-8354)%25,abs(20617)%25); insert into t1(data) values (abs(12904)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(17629)%25,abs(10077)%25),(null,abs(840)%25); start transaction; insert ignore into t2(data) values (abs(16334)%25),(abs(-25238)%25); update ignore t1 set id=abs(-29548)%25,data=abs(-3998)%25 where id=abs(27137)%25; insert into t2(id,data) values (abs(-10829)%25,abs(-22916)%25),(null,abs(1501)%25) on duplicate key update id=values(id),data=values(data); start transaction; delete from t1 where data=abs(-26102)%25; start transaction; insert ignore into t1(id,data) values (abs(18381)%25,abs(19474)%25),(abs(-21578)%25,abs(6042)%25),(abs(29859)%25,abs(4258)%25); update ignore t2 set id=abs(-14588)%25,data=abs(-16585)%25 where data=abs(16868)%25; insert into t2(id,data) values (null,abs(-3081)%25),(null,abs(29008)%25),(abs(-19953)%25,abs(11047)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(13279)%25,abs(10474)%25),(abs(5512)%25,abs(8708)%25),(abs(-11093)%25,abs(-9308)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-21839)%25),(abs(24972)%25),(abs(9736)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(24414)%25,abs(-32618)%25),(abs(18983)%25,abs(8772)%25),(abs(7324)%25,abs(10191)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(15823)%25; rollback; savepoint batch1; insert into t1(id,data) values (abs(-12060)%25,abs(5203)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (null,abs(-6143)%25),(null,abs(-28046)%25),(abs(8248)%25,abs(26094)%25); insert into t2(id,data) values (null,abs(22939)%25),(null,abs(880)%25),(abs(17678)%25,abs(9130)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(9991)%25,abs(-16943)%25); insert into t1(id,data) values (abs(-10387)%25,abs(-5008)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-12330)%25,abs(26346)%25),(null,abs(19716)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-13697)%25),(abs(15167)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set id=abs(-26228)%25,data=abs(-23055)%25 where id=abs(-30904)%25; replace into t2 select * from t1 where data=abs(451)%25; insert ignore into t1 select * from t2 where data=abs(15487)%25; set sql_mode=abs(-1483676107); insert ignore into t1 select * from t2 where data=abs(3421)%25; replace into t1(id,data) values (null,abs(24087)%25),(null,abs(-11767)%25),(abs(3172)%25,abs(-19673)%25); insert into t1(data) values (abs(-20852)%25),(abs(10060)%25),(abs(-17031)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(4775)%25),(null,abs(19702)%25),(abs(20920)%25,abs(30487)%25); update ignore t2 set data=abs(-12069)%25 where data=abs(-31888)%25; insert ignore into t1(data) values (abs(-3878)%25),(abs(31277)%25),(abs(25517)%25); start transaction; insert ignore into t1(id,data) values (abs(21986)%25,abs(-8509)%25); insert into t1(data) values (abs(16000)%25),(abs(24811)%25),(abs(-10667)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-565)%25,abs(10618)%25) on duplicate key update id=values(id),data=values(data); rollback; insert into t1(data) values (abs(-18944)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(23770)%25),(abs(17748)%25),(abs(-29168)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(10872)%25),(null,abs(25247)%25),(abs(-18170)%25,abs(12222)%25); start transaction; update ignore t2 set data=abs(-1769)%25 where data=abs(10153)%25; replace into t1(id,data) values (abs(30829)%25,abs(-30859)%25),(null,abs(-9891)%25); replace into t2(id,data) values (null,abs(18670)%25),(null,abs(19952)%25),(abs(25684)%25,abs(22006)%25); set sql_mode=abs(-1427732173); replace into t2(id,data) values (null,abs(16248)%25),(null,abs(-13064)%25),(abs(29386)%25,abs(16566)%25); update ignore t2 set data=abs(1443)%25 where data=abs(20623)%25; xa prepare 'xid1'; insert ignore into t2(id,data) values (abs(9762)%25,abs(-15488)%25),(null,abs(19927)%25); update ignore t1 set id=abs(-26041)%25,data=abs(-25678)%25 where id=abs(-5018)%25; start transaction; insert ignore into t1(id,data) values (abs(-7559)%25,abs(-23855)%25),(abs(23566)%25,abs(11143)%25),(abs(12422)%25,abs(24892)%25); update ignore t1 set id=abs(-1985)%25,data=abs(-16977)%25 where id=abs(20557)%25; insert ignore into t2(id,data) values (abs(-26808)%25,abs(-12374)%25); start transaction; insert into t1(id,data) values (abs(-252)%25,abs(-29759)%25),(abs(1252)%25,abs(-25588)%25) on duplicate key update id=values(id),data=values(data); start transaction; rollback; replace into t2(id,data) values (abs(-6728)%25,abs(26967)%25); insert ignore into t2(id,data) values (null,abs(-26606)%25),(null,abs(-13017)%25),(abs(25984)%25,abs(25512)%25); replace into t1 select * from t2 where id=abs(-14189)%25; insert into t2(data) values (abs(-17898)%25),(abs(-31655)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(-15302)%25); rollback; insert into t1(data) values (abs(11536)%25),(abs(-5695)%25),(abs(-9803)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-2069)%25,abs(-22808)%25),(null,abs(23632)%25); insert ignore into t2(id,data) values (abs(31792)%25,abs(-656)%25); insert ignore into t1(id,data) values (abs(7737)%25,abs(8993)%25); replace into t2(id,data) values (abs(-5635)%25,abs(1280)%25); insert ignore into t1(id,data) values (abs(-32495)%25,abs(-4750)%25),(null,abs(-20691)%25); replace into t1 select * from t2 where id=abs(28132)%25; insert ignore into t1 select * from t2 where data=abs(18128)%25; start transaction; update ignore t1 set id=abs(26520)%25,data=abs(18052)%25 where id=abs(-32668)%25; start transaction; insert into t1(id,data) values (abs(403)%25,abs(-6843)%25),(abs(7203)%25,abs(-24993)%25),(abs(29914)%25,abs(29638)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(-26600)%25; replace into t1 select * from t2 where data=abs(23915)%25; rollback; insert ignore into t1(id,data) values (abs(20905)%25,abs(13891)%25),(abs(27595)%25,abs(-27199)%25),(abs(10372)%25,abs(-14036)%25); update ignore t2 set data=abs(-8178)%25 where data=abs(24916)%25; insert into t2(id,data) values (abs(-15875)%25,abs(14767)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-19523)%25),(abs(-2554)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-29929)%25,abs(18555)%25),(null,abs(-2540)%25); insert ignore into t1 select * from t2 where id=abs(-16313)%25; insert into t1(id,data) values (abs(24215)%25,abs(-7450)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(28407)%25,abs(21445)%25); insert ignore into t1 select * from t2 where data=abs(-8845)%25; insert ignore into t1(id,data) values (abs(-18038)%25,abs(20366)%25); insert into t1(id,data) values (abs(-23777)%25,abs(-19502)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-28776)%25 where data=abs(-13898)%25; start transaction; delete from t2 where id=abs(-26378)%25; replace into t1 select * from t2 where data=abs(12287)%25; rollback; commit; insert ignore into t2(id,data) values (abs(-29012)%25,abs(31055)%25),(abs(-15821)%25,abs(-10543)%25),(abs(-6089)%25,abs(19503)%25); commit; insert ignore into t2(data) values (abs(-6485)%25),(abs(-12953)%25); replace into t2(id,data) values (null,abs(-6828)%25),(null,abs(9357)%25),(abs(-22402)%25,abs(1246)%25); insert into t1(data) values (abs(-8223)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1557712229); update ignore t2 set data=abs(21010)%25 where data=abs(28268)%25; replace into t2(id,data) values (abs(26704)%25,abs(-5858)%25); insert ignore into t1(data) values (abs(-15441)%25); insert into t1(data) values (abs(3306)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1871650111); delete from t2 where id=abs(27277)%25; set sql_mode=abs(-1973794642); insert ignore into t1(id,data) values (abs(-20554)%25,abs(-21296)%25); replace into t2 select * from t1 where data=abs(17411)%25; replace into t1 select * from t2 where data=abs(-28786)%25; replace into t2 select * from t1 where id=abs(-12173)%25; insert into t2(id,data) values (abs(13128)%25,abs(-6683)%25),(abs(31606)%25,abs(7)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-29926)%25,abs(11517)%25); insert ignore into t1(id,data) values (abs(31742)%25,abs(-18734)%25),(abs(-4178)%25,abs(-3575)%25); update ignore t1 set id=abs(11235)%25,data=abs(-20135)%25 where id=abs(626)%25; update ignore t2 set data=abs(3030)%25 where data=abs(510)%25; commit; insert into t2(data) values (abs(-28241)%25),(abs(-29470)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2(id,data) values (abs(28837)%25,abs(-4068)%25),(null,abs(-2408)%25); update ignore t2 set data=abs(-10348)%25 where data=abs(-27557)%25; set sql_mode=abs(-1930347952); update ignore t2 set data=abs(25528)%25 where data=abs(-1630)%25; insert ignore into t1(id,data) values (abs(23560)%25,abs(-6452)%25); update ignore t1 set id=abs(-4751)%25,data=abs(-2813)%25 where data=abs(20934)%25; insert ignore into t1 select * from t2 where id=abs(-21803)%25; start transaction; insert ignore into t1(id,data) values (abs(-27991)%25,abs(23533)%25); start transaction; insert ignore into t2(id,data) values (abs(-32095)%25,abs(8309)%25),(null,abs(-24353)%25); delete from t2 where id=abs(7369)%25; insert into t1(data) values (abs(-5393)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(23857)%25,abs(24215)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(25743)%25),(abs(-13531)%25),(abs(-26033)%25); insert ignore into t2(id,data) values (abs(-3064)%25,abs(14343)%25); insert into t2(id,data) values (abs(-27216)%25,abs(-3530)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(3766)%25,abs(8709)%25); replace into t2(id,data) values (null,abs(-12392)%25),(null,abs(-17810)%25),(abs(-23012)%25,abs(31086)%25); insert ignore into t2(id,data) values (abs(17568)%25,abs(-11192)%25),(abs(6067)%25,abs(-4313)%25),(abs(-32024)%25,abs(10807)%25); insert ignore into t2(id,data) values (abs(29272)%25,abs(-5756)%25),(null,abs(-179)%25); update ignore t2 set data=abs(18976)%25 where data=abs(23397)%25; rollback; insert ignore into t2 select * from t1 where data=abs(5086)%25; replace into t1 select * from t2 where data=abs(16541)%25; rollback; insert into t2(id,data) values (abs(-1328)%25,abs(-20528)%25),(abs(27073)%25,abs(-6395)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-21902)%25); start transaction; set sql_mode=abs(-1941428965); delete from t1 where id=abs(-1712)%25; insert ignore into t1(id,data) values (abs(-22642)%25,abs(-16803)%25),(null,abs(-553)%25); replace into t1(id,data) values (abs(26492)%25,abs(-12038)%25),(null,abs(31285)%25); insert into t1(id,data) values (abs(31144)%25,abs(-11246)%25) on duplicate key update id=values(id),data=values(data); commit; update ignore t2 set data=abs(25012)%25 where id=abs(-2936)%25; insert ignore into t2(id,data) values (abs(-12219)%25,abs(127)%25),(null,abs(14901)%25); replace into t1 select * from t2 where data=abs(-7111)%25; insert ignore into t1(data) values (abs(-24389)%25),(abs(-23567)%25),(abs(12493)%25); insert into t1(id,data) values (abs(-3284)%25,abs(-2873)%25) on duplicate key update id=values(id),data=values(data); rollback; replace into t1 select * from t2 where data=abs(18994)%25; insert ignore into t2(id,data) values (abs(-9104)%25,abs(-27954)%25),(abs(5290)%25,abs(-13658)%25); insert ignore into t1 select * from t2 where id=abs(-18182)%25; replace into t2(id,data) values (abs(4931)%25,abs(-2261)%25); insert ignore into t1(data) values (abs(-9733)%25); insert into t2(id,data) values (abs(-7903)%25,abs(637)%25),(abs(-9020)%25,abs(15301)%25),(abs(30007)%25,abs(23641)%25) on duplicate key update id=values(id),data=values(data); rollback; commit; insert ignore into t1(data) values (abs(-14383)%25); update ignore t1 set data=abs(12301)%25 where id=abs(-4766)%25; insert ignore into t1(data) values (abs(-6911)%25),(abs(-22057)%25),(abs(-5090)%25); insert into t1(data) values (abs(-1263)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-25175)%25,abs(-14249)%25); update ignore t2 set data=abs(21840)%25 where data=abs(13967)%25; start transaction; replace into t2(id,data) values (null,abs(-9545)%25),(null,abs(-10208)%25),(abs(30954)%25,abs(-2013)%25); replace into t1 select * from t2 where data=abs(8044)%25; commit; insert into t1(data) values (abs(7975)%25),(abs(-1473)%25),(abs(-25544)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t1(id,data) values (abs(5292)%25,abs(10957)%25),(abs(-28789)%25,abs(671)%25); insert into t2(id,data) values (abs(-26801)%25,abs(17890)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(6240)%25; start transaction; insert ignore into t2(id,data) values (abs(27247)%25,abs(14622)%25); commit; insert ignore into t2 select * from t1 where id=abs(17909)%25; insert ignore into t2(data) values (abs(7249)%25); insert ignore into t1(data) values (abs(20173)%25),(abs(-27514)%25),(abs(-3174)%25); replace into t2(id,data) values (abs(25097)%25,abs(29413)%25); insert ignore into t1(data) values (abs(-28630)%25),(abs(28024)%25); insert into t2(id,data) values (null,abs(28702)%25),(null,abs(-14880)%25),(abs(-12908)%25,abs(-28028)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(6203)%25,abs(-13333)%25); update ignore t1 set id=abs(30282)%25,data=abs(16732)%25 where id=abs(7280)%25; insert ignore into t1(data) values (abs(-8732)%25),(abs(23828)%25),(abs(-13619)%25); insert into t2(id,data) values (abs(6732)%25,abs(-32325)%25),(abs(23707)%25,abs(14948)%25),(abs(-2395)%25,abs(-1668)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(20225)%25,abs(-9737)%25),(abs(21244)%25,abs(-14798)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-2508)%25),(abs(-21547)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(31122)%25,abs(-12456)%25); start transaction; insert ignore into t1(id,data) values (abs(5380)%25,abs(-17275)%25); replace into t2 select * from t1 where data=abs(-4658)%25; commit; rollback; insert ignore into t1(id,data) values (abs(23457)%25,abs(-4313)%25),(null,abs(-9473)%25); insert into t2(data) values (abs(-19113)%25),(abs(9156)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(5355)%25,abs(-18411)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(-4912)%25,abs(24538)%25),(null,abs(17386)%25); insert ignore into t1(id,data) values (abs(-13553)%25,abs(31807)%25),(abs(21043)%25,abs(30043)%25),(abs(25464)%25,abs(-10665)%25); start transaction; insert ignore into t1(id,data) values (null,abs(-27200)%25),(null,abs(15205)%25),(abs(3702)%25,abs(-12147)%25); insert into t2(data) values (abs(6350)%25),(abs(-28532)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(id,data) values (null,abs(-13793)%25),(null,abs(-25625)%25),(abs(32252)%25,abs(24686)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-18330)%25,abs(9373)%25) on duplicate key update id=values(id),data=values(data); start transaction; start transaction; update ignore t1 set id=abs(11176)%25,data=abs(7342)%25 where data=abs(25816)%25; insert into t2(id,data) values (abs(-32013)%25,abs(-17169)%25),(null,abs(-18725)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(2296)%25,abs(11032)%25); commit; start transaction; insert into t2(id,data) values (abs(12554)%25,abs(2689)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(5669)%25 where id=abs(11497)%25; start transaction; insert ignore into t1(data) values (abs(-25211)%25); insert into t2(id,data) values (abs(-5662)%25,abs(3554)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(25336)%25),(abs(29642)%25),(abs(11667)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(32467)%25,abs(4522)%25),(abs(30352)%25,abs(10405)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(6247)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(4042)%25; insert ignore into t1(id,data) values (abs(-3557)%25,abs(-19481)%25); insert into t1(data) values (abs(-24454)%25),(abs(18745)%25),(abs(-31011)%25) on duplicate key update id=values(id),data=values(data); rollback; replace into t1 select * from t2 where data=abs(-10117)%25; replace into t2(id,data) values (abs(-2754)%25,abs(-12354)%25); insert ignore into t1(id,data) values (null,abs(-19723)%25),(null,abs(-22493)%25),(abs(-12253)%25,abs(18073)%25); insert into t2(data) values (abs(28806)%25),(abs(13052)%25),(abs(14785)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1 select * from t2 where data=abs(-17309)%25; start transaction; insert ignore into t1(id,data) values (abs(9312)%25,abs(10362)%25); insert ignore into t2(id,data) values (abs(16645)%25,abs(-4767)%25),(null,abs(5971)%25); update ignore t1 set id=abs(-20098)%25,data=abs(7720)%25 where id=abs(-10427)%25; insert ignore into t2 select * from t1 where id=abs(-5328)%25; replace into t2(id,data) values (null,abs(16446)%25),(null,abs(-11868)%25),(abs(-9842)%25,abs(-30847)%25); insert into t1(data) values (abs(21982)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(id,data) values (abs(2227)%25,abs(12547)%25),(abs(-16823)%25,abs(-22560)%25),(abs(-2836)%25,abs(-17003)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(21292)%25 where data=abs(24412)%25; update ignore t2 set data=abs(-31977)%25 where data=abs(18760)%25; insert ignore into t2(id,data) values (abs(31118)%25,abs(4309)%25),(null,abs(17807)%25); insert into t2(id,data) values (abs(-21903)%25,abs(-20800)%25),(abs(8419)%25,abs(308)%25),(abs(11823)%25,abs(-28473)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-24488)%25,abs(-9488)%25); update ignore t1 set id=abs(-23170)%25,data=abs(-8055)%25 where id=abs(-18119)%25; update ignore t2 set id=abs(6772)%25,data=abs(-16849)%25 where id=abs(-9495)%25; insert ignore into t2 select * from t1 where data=abs(10567)%25; insert into t1(id,data) values (abs(-7833)%25,abs(-22418)%25) on duplicate key update id=values(id),data=values(data); commit; insert ignore into t1(id,data) values (abs(-13654)%25,abs(-21209)%25),(null,abs(-30023)%25); update ignore t1 set id=abs(9241)%25,data=abs(-16154)%25 where data=abs(4077)%25; insert ignore into t2(id,data) values (abs(-12770)%25,abs(9799)%25),(abs(-24643)%25,abs(20706)%25),(abs(28693)%25,abs(11117)%25); start transaction; insert ignore into t2(id,data) values (abs(21857)%25,abs(-14739)%25),(null,abs(-28613)%25); insert ignore into t2(data) values (abs(-6503)%25),(abs(-15662)%25),(abs(30474)%25); insert into t2(id,data) values (abs(-13448)%25,abs(31264)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-26429)%25,abs(22282)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(-30125)%25),(null,abs(28756)%25),(abs(-9444)%25,abs(-16164)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(22359)%25),(abs(22125)%25); update ignore t1 set data=abs(22012)%25 where id=abs(-9252)%25; insert ignore into t1(id,data) values (abs(-3126)%25,abs(27772)%25); rollback; rollback; insert ignore into t2(id,data) values (abs(11092)%25,abs(26212)%25),(abs(-15089)%25,abs(-25658)%25),(abs(-17977)%25,abs(28969)%25); set sql_mode=abs(-1856427123); insert ignore into t1 select * from t2 where data=abs(-32382)%25; replace into t1 select * from t2 where data=abs(-15411)%25; replace into t1 select * from t2 where id=abs(-23531)%25; start transaction; replace into t2(id,data) values (abs(-15224)%25,abs(8765)%25); insert ignore into t2 select * from t1 where data=abs(-27973)%25; start transaction; insert ignore into t1 select * from t2 where id=abs(-3318)%25; update ignore t1 set id=abs(25252)%25,data=abs(-19412)%25 where id=abs(17654)%25; insert ignore into t1(id,data) values (abs(14731)%25,abs(-16181)%25); insert into t2(id,data) values (abs(25984)%25,abs(-5003)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(16384)%25,abs(3556)%25); update ignore t2 set data=abs(-3750)%25 where data=abs(6034)%25; insert ignore into t2(id,data) values (abs(-599)%25,abs(19047)%25); insert ignore into t2(id,data) values (abs(31363)%25,abs(956)%25),(abs(-9188)%25,abs(25007)%25); insert ignore into t1(data) values (abs(27697)%25); set sql_mode=abs(-2036378180); commit; insert into t2(id,data) values (abs(-32627)%25,abs(16057)%25),(abs(-5939)%25,abs(-30023)%25),(abs(-1775)%25,abs(29557)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(10162)%25,abs(31854)%25),(null,abs(-12113)%25); update ignore t2 set id=abs(-68)%25,data=abs(5387)%25 where id=abs(-4977)%25; update ignore t2 set data=abs(-12730)%25 where data=abs(-4687)%25; update ignore t2 set data=abs(-16841)%25 where id=abs(5001)%25; insert into t1(id,data) values (abs(-3822)%25,abs(27476)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-24488)%25,abs(-13519)%25),(abs(-23752)%25,abs(-22483)%25),(abs(-21403)%25,abs(-7880)%25); insert ignore into t1(id,data) values (null,abs(3534)%25),(null,abs(-9405)%25),(abs(9477)%25,abs(11327)%25); start transaction; insert into t1(id,data) values (null,abs(3726)%25),(null,abs(-19382)%25),(abs(-31547)%25,abs(-3307)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(15625)%25),(null,abs(-30198)%25),(abs(-24302)%25,abs(15144)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-15298)%25,abs(9666)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-28512)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(-28286)%25; insert ignore into t2(id,data) values (abs(-12014)%25,abs(-25322)%25),(null,abs(18922)%25); insert ignore into t1(id,data) values (abs(18707)%25,abs(23211)%25); insert ignore into t2(data) values (abs(3915)%25),(abs(2902)%25); insert into t2(id,data) values (abs(22943)%25,abs(-14420)%25),(null,abs(27718)%25) on duplicate key update id=values(id),data=values(data); commit; insert ignore into t1(data) values (abs(-5909)%25),(abs(-7190)%25); rollback; replace into t1(id,data) values (abs(-9996)%25,abs(-20717)%25); rollback; insert ignore into t1(id,data) values (abs(10489)%25,abs(-22385)%25); replace into t2(id,data) values (null,abs(15097)%25),(null,abs(18988)%25),(abs(-28493)%25,abs(25936)%25); delete from t1 where data=abs(-3917)%25; insert ignore into t1(id,data) values (abs(-19412)%25,abs(4828)%25),(null,abs(-22313)%25); insert ignore into t1(id,data) values (abs(6880)%25,abs(21687)%25); replace into t2(id,data) values (abs(-11792)%25,abs(-4479)%25),(null,abs(-25049)%25); start transaction; set session completion_type=0; insert into t2(id,data) values (null,abs(21472)%25),(null,abs(-18674)%25),(abs(-1958)%25,abs(-18532)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1325733644); insert into t1(data) values (abs(-32043)%25),(abs(-2354)%25),(abs(-24605)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-23253)%25,abs(3231)%25),(null,abs(-24951)%25); commit; insert into t1(data) values (abs(-20969)%25),(abs(24319)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-30052)%25),(abs(-28778)%25); replace into t1 select * from t2 where data=abs(-29153)%25; insert ignore into t1(id,data) values (abs(-30270)%25,abs(-16176)%25); insert into t2(id,data) values (abs(27055)%25,abs(5498)%25),(abs(1327)%25,abs(-31743)%25) on duplicate key update id=values(id),data=values(data); commit; replace into t2(id,data) values (null,abs(-13253)%25),(null,abs(-14945)%25),(abs(-15938)%25,abs(15081)%25); insert into t1(data) values (abs(-497)%25),(abs(13999)%25) on duplicate key update id=values(id),data=values(data); rollback; insert into t1(data) values (abs(18709)%25),(abs(14436)%25),(abs(-7486)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(-8198)%25; rollback; replace into t2(id,data) values (null,abs(-31063)%25),(null,abs(30367)%25),(abs(4612)%25,abs(26178)%25); delete from t2 where id=abs(9603)%25; start transaction; rollback; set sql_mode=abs(-1732736941); insert into t2(data) values (abs(23532)%25),(abs(23990)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(id,data) values (abs(7232)%25,abs(25308)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(-10218)%25; insert ignore into t2(id,data) values (abs(-9737)%25,abs(2272)%25); insert into t1(data) values (abs(-14949)%25),(abs(20500)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(29534)%25,abs(-2468)%25),(null,abs(17826)%25); replace into t1 select * from t2 where id=abs(-8321)%25; replace into t1 select * from t2 where data=abs(15322)%25; insert ignore into t1(data) values (abs(-24922)%25),(abs(545)%25),(abs(14424)%25); insert into t1(data) values (abs(-19580)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-9909)%25,abs(-6611)%25); start transaction; insert into t1(id,data) values (abs(24837)%25,abs(11357)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-15632)%25,abs(-12362)%25),(null,abs(6075)%25); insert ignore into t1(data) values (abs(-2511)%25),(abs(-1158)%25),(abs(8815)%25); commit; insert into t1(data) values (abs(29971)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-5813)%25),(abs(-19115)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1899463518); delete from t1 where data=abs(16212)%25; insert ignore into t1(id,data) values (abs(-2461)%25,abs(26662)%25); set sql_mode=abs(-2067955081); insert ignore into t1 select * from t2 where data=abs(4526)%25; insert ignore into t1(id,data) values (abs(-27583)%25,abs(16902)%25),(abs(21906)%25,abs(9009)%25),(abs(-14628)%25,abs(1552)%25); insert into t2(data) values (abs(21640)%25),(abs(18487)%25),(abs(1811)%25) on duplicate key update id=values(id),data=values(data); commit; replace into t1(id,data) values (null,abs(8363)%25),(null,abs(-24311)%25),(abs(-17699)%25,abs(11388)%25); commit; insert ignore into t1(id,data) values (abs(-7028)%25,abs(7523)%25); delete from t1 where data=abs(-26618)%25; insert ignore into t2(id,data) values (abs(29104)%25,abs(462)%25); start transaction; update ignore t1 set id=abs(29329)%25,data=abs(-4424)%25 where id=abs(5356)%25; commit; insert ignore into t2(id,data) values (abs(23842)%25,abs(-10415)%25),(null,abs(-24817)%25); insert into t1(data) values (abs(-30558)%25),(abs(-18527)%25),(abs(6604)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(4787)%25,abs(8793)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-30833)%25 where id=abs(32254)%25; start transaction; insert into t1(id,data) values (abs(22387)%25,abs(26977)%25) on duplicate key update id=values(id),data=values(data); start transaction; delete from t2 where data=abs(-31238)%25; insert ignore into t1(id,data) values (abs(31028)%25,abs(7202)%25),(abs(2823)%25,abs(-23558)%25); insert into t1(data) values (abs(-4203)%25),(abs(2503)%25),(abs(-2973)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where data=abs(-24137)%25; start transaction; start transaction; insert ignore into t2(id,data) values (abs(-4241)%25,abs(-17794)%25); insert into t1(id,data) values (abs(-10915)%25,abs(22249)%25),(abs(-18911)%25,abs(-23388)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-30351)%25; update ignore t2 set id=abs(28310)%25,data=abs(3431)%25 where data=abs(-4403)%25; insert into t1(id,data) values (abs(-9428)%25,abs(2212)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(22168)%25 where id=abs(-701)%25; insert into t1(data) values (abs(13380)%25),(abs(-742)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(13047)%25 where id=abs(-30824)%25; replace into t2(id,data) values (abs(7157)%25,abs(5044)%25); replace into t2(id,data) values (null,abs(24315)%25),(null,abs(213)%25),(abs(-8383)%25,abs(-20959)%25); insert into t1(id,data) values (null,abs(-12425)%25),(null,abs(-25098)%25),(abs(-12368)%25,abs(-3744)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(15667)%25,abs(-13139)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(-6191)%25; delete from t1 where data=abs(-32314)%25; set sql_mode=abs(-1759898847); insert into t2(id,data) values (abs(14560)%25,abs(28609)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(250)%25),(null,abs(-27323)%25),(abs(-13910)%25,abs(6198)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(id,data) values (abs(24768)%25,abs(-2494)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(19349)%25),(abs(-1178)%25); rollback work and chain no release; commit; insert into t2(data) values (abs(15709)%25),(abs(-30558)%25),(abs(-32307)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(data) values (abs(32658)%25),(abs(-31244)%25); insert ignore into t2 select * from t1 where id=abs(10642)%25; replace into t1 select * from t2 where data=abs(-6850)%25; insert into t1(data) values (abs(-11438)%25),(abs(-27245)%25),(abs(-3383)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(-28181)%25; insert into t2(id,data) values (null,abs(23234)%25),(null,abs(-9549)%25),(abs(14990)%25,abs(-2204)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(8287)%25,data=abs(-14535)%25 where id=abs(-31124)%25; update ignore t2 set data=abs(872)%25 where data=abs(26290)%25; delete from t1 where data=abs(13231)%25; replace into t2(id,data) values (abs(387)%25,abs(-7588)%25),(null,abs(31219)%25); insert ignore into t2(id,data) values (abs(6135)%25,abs(-19837)%25); commit; update ignore t2 set data=abs(-21650)%25 where data=abs(-29368)%25; insert ignore into t1 select * from t2 where data=abs(-2930)%25; rollback; replace into t1(id,data) values (abs(-23116)%25,abs(-28949)%25),(null,abs(7696)%25); insert ignore into t1(data) values (abs(-2975)%25),(abs(-15701)%25),(abs(28156)%25); insert into t2(id,data) values (abs(687)%25,abs(14677)%25),(abs(12090)%25,abs(-9074)%25),(abs(13607)%25,abs(-10883)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-2945)%25,data=abs(-22620)%25 where id=abs(-19685)%25; insert into t2(id,data) values (abs(26783)%25,abs(-5984)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-536)%25,abs(-14219)%25) on duplicate key update id=values(id),data=values(data); delete from t1 where id=abs(16957)%25; select @@autocommit; insert ignore into t2(data) values (abs(-7088)%25),(abs(32645)%25); insert into t1(id,data) values (abs(5497)%25,abs(-14684)%25),(abs(-11735)%25,abs(-5636)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t1(data) values (abs(-5501)%25),(abs(8957)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where data=abs(-21080)%25; insert ignore into t2(data) values (abs(7142)%25),(abs(-31808)%25); update ignore t1 set id=abs(30037)%25,data=abs(-7328)%25 where id=abs(-648)%25; replace into t1 select * from t2 where id=abs(18891)%25; insert into t1(data) values (abs(15628)%25),(abs(7804)%25),(abs(-26967)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2(id,data) values (abs(-21743)%25,abs(5781)%25),(null,abs(25147)%25); insert ignore into t1(data) values (abs(-8696)%25); insert into t1(id,data) values (null,abs(11402)%25),(null,abs(7162)%25),(abs(916)%25,abs(-10643)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(2405)%25; start transaction; insert into t2(id,data) values (null,abs(-24296)%25),(null,abs(-6988)%25),(abs(-11987)%25,abs(-7508)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t2(id,data) values (abs(17365)%25,abs(6397)%25),(abs(-19001)%25,abs(12470)%25),(abs(20731)%25,abs(7297)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-5117)%25) on duplicate key update id=values(id),data=values(data); update ignore t2 set data=abs(-13334)%25 where data=abs(-30518)%25; insert ignore into t2(id,data) values (abs(28312)%25,abs(-17252)%25); replace into t1 select * from t2 where data=abs(-25288)%25; replace into t1 select * from t2 where data=abs(-18364)%25; commit; update ignore t1 set id=abs(30943)%25,data=abs(-21062)%25 where id=abs(-2498)%25; update ignore t1 set id=abs(-12746)%25,data=abs(24358)%25 where id=abs(4765)%25; insert into t1(id,data) values (abs(31129)%25,abs(13596)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-23718)%25),(abs(11842)%25),(abs(29992)%25); insert ignore into t1(id,data) values (abs(-22053)%25,abs(-9545)%25); insert into t2(data) values (abs(-18003)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (null,abs(-20508)%25),(null,abs(27662)%25),(abs(-27515)%25,abs(826)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where id=abs(-26405)%25; insert ignore into t1(data) values (abs(-5252)%25),(abs(-30558)%25); start transaction; rollback; insert ignore into t1(id,data) values (abs(46)%25,abs(30731)%25),(null,abs(10415)%25); rollback; replace into t1(id,data) values (abs(-250)%25,abs(-15714)%25); commit; insert ignore into t2(id,data) values (abs(-205)%25,abs(-9245)%25),(null,abs(28802)%25); insert ignore into t1 select * from t2 where data=abs(18419)%25; replace into t1(id,data) values (abs(-2263)%25,abs(18832)%25); commit; insert ignore into t2(data) values (abs(10975)%25),(abs(-748)%25); update ignore t1 set id=abs(19342)%25,data=abs(-15219)%25 where id=abs(392)%25; replace into t2 select * from t1 where id=abs(3680)%25; update ignore t1 set id=abs(26771)%25,data=abs(30511)%25 where id=abs(7075)%25; commit; insert ignore into t1(id,data) values (abs(-9779)%25,abs(10877)%25); insert ignore into t1(id,data) values (abs(-21586)%25,abs(27250)%25); replace into t2 select * from t1 where id=abs(24894)%25; replace into t1(id,data) values (abs(5446)%25,abs(13187)%25),(null,abs(13687)%25); insert into t2(id,data) values (abs(-6060)%25,abs(25507)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-17579)%25),(abs(-26621)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (null,abs(2647)%25),(null,abs(-15413)%25),(abs(-19914)%25,abs(-2043)%25); replace into t1 select * from t2 where data=abs(17149)%25; insert into t1(id,data) values (abs(-19445)%25,abs(2887)%25),(abs(16192)%25,abs(-2826)%25) on duplicate key update id=values(id),data=values(data); set sql_mode=abs(-1559026255); insert into t1(id,data) values (abs(-32051)%25,abs(-9694)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where data=abs(28912)%25; insert ignore into t2(data) values (abs(27397)%25); start transaction; insert into t1(data) values (abs(-8543)%25),(abs(-7859)%25),(abs(18115)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(18523)%25,abs(-13484)%25),(abs(-9733)%25,abs(-26128)%25),(abs(-8582)%25,abs(-28721)%25); insert into t1(id,data) values (abs(-2474)%25,abs(-6705)%25) on duplicate key update id=values(id),data=values(data); rollback; update ignore t2 set data=abs(31042)%25 where id=abs(-31655)%25; insert ignore into t2(id,data) values (abs(-28824)%25,abs(-17528)%25),(null,abs(-12509)%25); start transaction; insert ignore into t2(id,data) values (abs(7641)%25,abs(-2171)%25),(null,abs(-13207)%25); replace into t2(id,data) values (null,abs(18184)%25),(null,abs(-17819)%25),(abs(-14159)%25,abs(-25103)%25); set sql_mode=abs(-1866147137); rollback; replace into t2(id,data) values (null,abs(-31283)%25),(null,abs(1417)%25),(abs(26067)%25,abs(24177)%25); insert ignore into t1(id,data) values (abs(30466)%25,abs(25837)%25); insert ignore into t2(id,data) values (abs(-26451)%25,abs(29756)%25),(null,abs(4267)%25); insert into t1(id,data) values (abs(-9193)%25,abs(30382)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(18727)%25,abs(-25973)%25),(abs(22162)%25,abs(-29943)%25),(abs(942)%25,abs(5587)%25); insert ignore into t2(id,data) values (abs(-17042)%25,abs(-3062)%25); insert ignore into t1 select * from t2 where id=abs(22096)%25; delete from t2 where data=abs(-3683)%25; insert ignore into t2(data) values (abs(16245)%25),(abs(26233)%25); insert into t1(id,data) values (abs(-12298)%25,abs(13322)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(-14424)%25,data=abs(-14458)%25 where id=abs(1279)%25; set sql_mode=abs(-1997588223); insert ignore into t1(id,data) values (abs(848)%25,abs(2184)%25); insert ignore into t2(data) values (abs(-19759)%25),(abs(-29250)%25); update ignore t2 set data=abs(17637)%25 where id=abs(-17263)%25; insert ignore into t2(id,data) values (abs(-4498)%25,abs(-4997)%25),(abs(11884)%25,abs(17971)%25),(abs(15427)%25,abs(-16823)%25); delete from t1 where data=abs(-5405)%25; update ignore t2 set id=abs(-9366)%25,data=abs(-13201)%25 where data=abs(-23585)%25; replace into t2 select * from t1 where data=abs(-5164)%25; update ignore t1 set id=abs(-7987)%25,data=abs(-3283)%25 where id=abs(-10900)%25; rollback; rollback; insert into t2(id,data) values (abs(-16786)%25,abs(11917)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (null,abs(-4511)%25),(null,abs(-2468)%25),(abs(30275)%25,abs(-17801)%25); replace into t1(id,data) values (abs(23195)%25,abs(-4545)%25); update ignore t2 set id=abs(-24824)%25,data=abs(-7394)%25 where data=abs(-28751)%25; update ignore t2 set data=abs(-8748)%25 where id=abs(-3620)%25; start transaction; delete from t1 where data=abs(15852)%25; update ignore t1 set id=abs(1447)%25,data=abs(16682)%25 where data=abs(-25124)%25; insert ignore into t1(data) values (abs(-6019)%25),(abs(7969)%25); rollback; insert into t1(id,data) values (abs(27633)%25,abs(-1918)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-26343)%25,abs(15616)%25),(null,abs(28534)%25); rollback; update ignore t1 set id=abs(4738)%25,data=abs(-20817)%25 where data=abs(24547)%25; insert ignore into t1 select * from t2 where id=abs(-6818)%25; update ignore t2 set data=abs(-16295)%25 where data=abs(13347)%25; update ignore t2 set data=abs(18079)%25 where data=abs(1903)%25; insert into t1(id,data) values (abs(-8432)%25,abs(15504)%25) on duplicate key update id=values(id),data=values(data); replace into t1(id,data) values (abs(31744)%25,abs(17878)%25); insert ignore into t1 select * from t2 where data=abs(12487)%25; insert ignore into t1(id,data) values (abs(662)%25,abs(13842)%25),(abs(10441)%25,abs(-23348)%25); delete from t1 where data=abs(-11438)%25; update ignore t2 set data=abs(-18872)%25 where data=abs(-17022)%25; insert ignore into t2(id,data) values (abs(20788)%25,abs(20165)%25); insert ignore into t2(data) values (abs(-14428)%25); insert ignore into t2(id,data) values (abs(29020)%25,abs(-31784)%25),(abs(27979)%25,abs(14170)%25); rollback; insert ignore into t2(data) values (abs(5716)%25); commit; insert ignore into t1 select * from t2 where data=abs(-16178)%25; insert ignore into t2(data) values (abs(-12578)%25); insert into t1(data) values (abs(14383)%25),(abs(-7038)%25),(abs(-17657)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(4807)%25,abs(-25847)%25),(null,abs(-8198)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(31468)%25),(abs(-17651)%25),(abs(9307)%25) on duplicate key update id=values(id),data=values(data); delete from t2 where id=abs(-30969)%25; start transaction; rollback; replace into t1 select * from t2 where data=abs(-6299)%25; replace into t2(id,data) values (abs(-28799)%25,abs(-32369)%25),(null,abs(24577)%25); insert into t1(id,data) values (abs(23493)%25,abs(28892)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t2(data) values (abs(21202)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-28373)%25,abs(-30518)%25),(null,abs(30137)%25); insert ignore into t1 select * from t2 where id=abs(-4548)%25; insert into t1(id,data) values (abs(-20951)%25,abs(1450)%25),(abs(18448)%25,abs(1963)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(17347)%25,data=abs(-26947)%25 where id=abs(-5024)%25; update ignore t2 set id=abs(26947)%25,data=abs(24247)%25 where id=abs(18278)%25; insert into t1(id,data) values (abs(32606)%25,abs(-23810)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-31715)%25),(abs(-12548)%25),(abs(20331)%25); insert ignore into t1(data) values (abs(-373)%25),(abs(4864)%25),(abs(-4752)%25); insert ignore into t2(data) values (abs(-7058)%25); insert into t2(id,data) values (abs(-4892)%25,abs(10576)%25),(abs(6148)%25,abs(-20483)%25),(abs(-5321)%25,abs(-12205)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert ignore into t2(id,data) values (abs(-30488)%25,abs(6794)%25); insert ignore into t2(data) values (abs(-23915)%25),(abs(-27950)%25); update ignore t2 set data=abs(-28237)%25 where data=abs(-25943)%25; insert into t2(id,data) values (abs(19807)%25,abs(19552)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set data=abs(13658)%25 where id=abs(16606)%25; insert into t2(id,data) values (abs(17385)%25,abs(-25310)%25),(abs(-11508)%25,abs(25357)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(25493)%25,abs(27783)%25),(abs(10399)%25,abs(-22684)%25),(abs(-19633)%25,abs(31471)%25); replace into t2 select * from t1 where id=abs(27182)%25; insert ignore into t2(id,data) values (abs(12898)%25,abs(-18761)%25),(null,abs(-24248)%25); insert ignore into t2(data) values (abs(22622)%25); start transaction; insert into t1(data) values (abs(-12825)%25),(abs(-27871)%25),(abs(22372)%25) on duplicate key update id=values(id),data=values(data); xa commit 'xid1'; replace into t1(id,data) values (abs(10953)%25,abs(2332)%25),(null,abs(9302)%25); insert into t1(id,data) values (abs(-347)%25,abs(-9187)%25) on duplicate key update id=values(id),data=values(data); commit; insert into t1(data) values (abs(-2548)%25),(abs(24459)%25),(abs(29057)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-13709)%25,abs(-31345)%25); replace into t1 select * from t2 where data=abs(-16088)%25; update ignore t1 set id=abs(2137)%25,data=abs(-5892)%25 where id=abs(23601)%25; update ignore t2 set id=abs(-20777)%25,data=abs(-25314)%25 where id=abs(-32183)%25; replace into t2 select * from t1 where data=abs(-18035)%25; insert into t1(data) values (abs(12238)%25),(abs(3855)%25),(abs(-7643)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(-32210)%25; replace into t2(id,data) values (abs(10210)%25,abs(-10631)%25); insert into t1(data) values (abs(14794)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-1186)%25,abs(1627)%25),(null,abs(32257)%25) on duplicate key update id=values(id),data=values(data); replace into t2(id,data) values (abs(-7761)%25,abs(23266)%25); rollback; replace into t2(id,data) values (null,abs(9745)%25),(null,abs(14497)%25),(abs(-29708)%25,abs(9534)%25); update ignore t2 set data=abs(6502)%25 where data=abs(24541)%25; insert ignore into t1(data) values (abs(-8594)%25); update ignore t1 set id=abs(1872)%25,data=abs(-1415)%25 where id=abs(13126)%25; insert into t2(id,data) values (abs(-21903)%25,abs(-16293)%25),(abs(3622)%25,abs(19650)%25),(abs(-7381)%25,abs(-11094)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(id,data) values (abs(16799)%25,abs(19516)%25) on duplicate key update id=values(id),data=values(data); replace into t2 select * from t1 where id=abs(17033)%25; insert ignore into t1(data) values (abs(-28595)%25); insert into t1(data) values (abs(-9947)%25),(abs(-26117)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2 select * from t1 where id=abs(-22449)%25; insert ignore into t1(data) values (abs(21715)%25),(abs(25183)%25),(abs(-2845)%25); insert ignore into t1(id,data) values (null,abs(13402)%25),(null,abs(-16247)%25),(abs(-11938)%25,abs(-30661)%25); rollback; insert into t2(id,data) values (null,abs(24111)%25),(null,abs(19328)%25),(abs(29120)%25,abs(4088)%25) on duplicate key update id=values(id),data=values(data); replace into t1 select * from t2 where data=abs(30707)%25; commit; update ignore t1 set id=abs(11949)%25,data=abs(30471)%25 where id=abs(30992)%25; update ignore t2 set data=abs(-15764)%25 where id=abs(-31089)%25; insert ignore into t2 select * from t1 where id=abs(-18023)%25; commit; insert ignore into t1(id,data) values (abs(14047)%25,abs(29592)%25); commit; insert into t2(id,data) values (abs(-3758)%25,abs(-4418)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(32752)%25),(abs(-7319)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(14209)%25,abs(-7411)%25); replace into t1 select * from t2 where data=abs(-19373)%25; rollback; insert ignore into t1(data) values (abs(-31228)%25),(abs(-15601)%25),(abs(-1212)%25); set sql_mode=abs(-1807686661); replace into t1(id,data) values (abs(21202)%25,abs(14339)%25),(null,abs(6406)%25); insert ignore into t1(id,data) values (null,abs(20377)%25),(null,abs(-2080)%25),(abs(-4949)%25,abs(22642)%25); insert into t1(id,data) values (abs(10445)%25,abs(20068)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-30960)%25),(abs(-20607)%25),(abs(17902)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-25073)%25,abs(-24458)%25) on duplicate key update id=values(id),data=values(data); rollback; insert into t2(id,data) values (abs(13573)%25,abs(-4793)%25),(abs(22184)%25,abs(15479)%25),(abs(-32371)%25,abs(-19282)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(20116)%25,data=abs(16627)%25 where data=abs(-22658)%25; replace into t1 select * from t2 where data=abs(-8765)%25; set sql_mode=abs(-2097107087); insert into t2(id,data) values (abs(31732)%25,abs(20350)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(1397)%25,abs(-17495)%25) on duplicate key update id=values(id),data=values(data); insert into t1(id,data) values (abs(-28391)%25,abs(-13280)%25),(null,abs(22674)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-32193)%25,abs(23923)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t1(data) values (abs(11466)%25),(abs(14617)%25),(abs(22792)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(15396)%25),(abs(17310)%25),(abs(-29767)%25) on duplicate key update id=values(id),data=values(data); rollback; insert ignore into t2(id,data) values (abs(-24545)%25,abs(16522)%25),(null,abs(32278)%25); insert ignore into t1(id,data) values (null,abs(13682)%25),(null,abs(-31538)%25),(abs(6069)%25,abs(-17553)%25); replace into t2 select * from t1 where id=abs(10200)%25; insert ignore into t1(data) values (abs(-20972)%25),(abs(14003)%25); insert ignore into t1(data) values (abs(2914)%25),(abs(-5338)%25); start transaction; replace into t1(id,data) values (abs(10442)%25,abs(-12101)%25),(null,abs(22531)%25); insert into t1(id,data) values (abs(-5347)%25,abs(-6384)%25) on duplicate key update id=values(id),data=values(data); update ignore t1 set id=abs(26228)%25,data=abs(17147)%25 where data=abs(3776)%25; rollback; insert ignore into t2(id,data) values (abs(-32618)%25,abs(8919)%25); replace into t2(id,data) values (abs(-5228)%25,abs(-1948)%25),(null,abs(-29543)%25); insert into t2(id,data) values (abs(11302)%25,abs(-3939)%25) on duplicate key update id=values(id),data=values(data); insert into t2(data) values (abs(-15005)%25),(abs(-30047)%25) on duplicate key update id=values(id),data=values(data); rollback; insert into t1(data) values (abs(17581)%25),(abs(-30119)%25),(abs(24398)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-7263)%25),(abs(-24954)%25),(abs(23791)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(-20259)%25),(abs(32763)%25),(abs(10909)%25) on duplicate key update id=values(id),data=values(data); start transaction; insert into t2(id,data) values (abs(-77)%25,abs(-10772)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(id,data) values (abs(-23540)%25,abs(11787)%25),(null,abs(-19925)%25); update ignore t1 set id=abs(-7943)%25,data=abs(-17327)%25 where id=abs(4677)%25; start transaction; insert into t1(data) values (abs(8619)%25),(abs(24007)%25),(abs(-25388)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t1(data) values (abs(-15188)%25),(abs(18874)%25),(abs(-11189)%25); insert into t1(id,data) values (abs(23796)%25,abs(-27399)%25),(abs(22611)%25,abs(8873)%25) on duplicate key update id=values(id),data=values(data); start transaction; update ignore t1 set id=abs(22540)%25,data=abs(-21950)%25 where id=abs(11857)%25; replace into t1 select * from t2 where id=abs(22628)%25; replace into t1(id,data) values (abs(-8208)%25,abs(-5807)%25),(null,abs(-23890)%25); insert into t2(id,data) values (abs(10321)%25,abs(-3606)%25),(null,abs(24199)%25) on duplicate key update id=values(id),data=values(data); insert into t1(data) values (abs(14807)%25),(abs(7318)%25),(abs(13359)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (null,abs(-11622)%25),(null,abs(22327)%25),(abs(-396)%25,abs(-20552)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-13092)%25,abs(1564)%25) on duplicate key update id=values(id),data=values(data); insert into t2(id,data) values (abs(-20498)%25,abs(20632)%25) on duplicate key update id=values(id),data=values(data); insert ignore into t2(id,data) values (abs(-18933)%25,abs(5283)%25);