drop table if exists table66;
CREATE TABLE `table66` (
`col4` char(218) ,   
`col5` year(4) ,   
`col6` datetime ,   
`col7` varchar(39) ,   
`col8` double ,   
`col9` decimal(10,0) ,   
`col10` char(10),   
`col11` year(4) ,
`col12` tinytext,
`col13` tinyblob,
`col14` date ,
`col15` int,
`col16` varchar(81) ,
`col17` tinytext,
`col18` blob,
`col19` double ,
`col20` double ,
`col21` varchar(216) ,
`col22` char(10),
`col23` decimal(10,0) ,
`col24` text,
`col25` varchar(118) ,
`col26` tinytext,
`col27` tinyblob,
`col28` double ,
`col29` tinyint(4) ,
`col30` longtext,
`col31` tinyint(1) ,
`col32` char(212) ,
`col33` timestamp,
`col34` year(4) ,
`col35` tinyint(1) ,
`col36` char(10),
`col37` decimal(10,0) ,
`col38` tinyint(4) ,
`col39` double ,
`col40` decimal(10,0) ,
`col41` char(10),
`col42` longblob,
`col43` text,
`col44` blob,
`col45` year(4) ,
`col46` longtext,
`col47` int(11) ,
`col48` set('test1','test2','test3') ,
`col49` bigint(20) ,
`col50` date ,
`col51` tinyblob,
`col52` float ,
`col53` year(4) ,
`col54` decimal(10,0) ,
`col55` tinyblob,
`col56` float ,
`col57` bigint(20) ,
`col58` timestamp ,
`col59` char(10),
`col60` bigint(20) ,
`col61` year(4) ,
`col62` year(4) ,
`col63` double ,
`col64` tinytext,
`col65` tinyint(4) ,
`col66` longtext,
`col67` time ,
`col68` bigint(20) ,
`col69` char(142) ,
`col70` longtext,
`col71` time ,
`col72` year(4) ,
`col73` longblob,
`col74` char(10),
`col75` decimal(10,0) ,
`col76` int,
`col77` tinytext,
`col78` date ,
`col79` double ,
`col80` tinyint(4) ,
`col81` float ,
`col82` bigint(20) ,
`col83` double ,
`col84` varchar(124) ,
`col85` double ,
`col86` tinyblob,
`col87` tinyblob,
`col88` double ,
`col89` date ,
`col90` decimal(10,0) ,
`col91` set('test1','test2','test3') ,
`col92` blob,
`col93` char(174) ,
`col94` double ,
`col95` tinytext,
`col96` decimal(10,0) ,
`col97` year(4) ,
`col98` tinyblob,
`col99` datetime ,
`col100` longblob,
`col101` date ,
`col102` float ,
`col103` float ,
`col104` int(11) ,
`col105` longblob,
`col106` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`col107` float ,
`col108` text,
`col109` float ,
`col110` decimal(10,0) ,
`col111` double ,
`col112` double ,
`col113` blob,
`col114` varchar(152) ,
`col115` bigint(20) ,
`col116` decimal(10,0) ,
`col117` mediumint(9) ,
`col118` tinytext,
`col119` tinyblob,
`col120` int(11) ,
`col121` bigint(20) ,
`col122` double ,
`col123` date ,
`col124` longtext,
`col125` longtext,
`col126` double ,
`col127` varchar(84) ,
`col128` text,
`col129` double ,
`col130` char(10),
`col131` time ,
`col132` year(4) ,
`col133` blob,
`col134` tinytext,
`col135` double ,
`col136` tinytext,
`col137` bigint(20) ,
`col138` datetime ,
`col139` double ,
`col140` decimal(10,0) ,
`col141` longtext,
`col142` tinyint(1) ,
`col143` time ,
`col144` time ,
`col145` float ,
`col146` longblob,
`col147` float ,
`col148` text,
`col149` mediumint(9) ,
`col150` tinyblob,
`col151` tinyblob,
`col152` tinytext,
`col153` tinyblob,
`col154` tinyblob,
`col155` tinytext,
`col156` tinyint(1) ,
`col157` tinytext,
`col158` time ,
`col159` date ,
`col160` longtext,
`col161` char(10),
`col162` text,
`col163` decimal(10,0) ,
`col164` time ,
`col165` longblob,
`col166` tinyint(4) ,
`col167` bigint(20) ,
`col168` decimal(10,0) ,
`col169` int,
`col170` tinytext,
`col171` tinyint(4) ,
`col172` tinyint(1) ,
`col173` tinytext,
`col174` decimal(10,0) ,
`col175` double 
) engine=maria DEFAULT CHARSET=latin1 COMMENT='generated';


insert ignore into `table66` set 
`col10`=abs(28449) % 2,
`col11`='1973',
`col12`=if(abs(-30039)%100<20,null,'forgery\'s'),
`col13`=if(abs(24672)%100<20,null,'adductor\'s'),
`col16`=if(abs(26872)%100<20,null,'0xf810e016ee0b78e1ce8b1c6cf8d2e82bf8507453768a3908dc20cecfc9a0ac0ac00079d0645a4c'),
`col18`=if(abs(-15854)%100<20,null,'unattractiveness'),
`col19`=if(abs(4287439673.9896235000)%100<20,null,25288),
`col20`=if(abs(4290800136.7527390000)%100<20,null,8887),
`col21`=if(abs(-26086)%100<20,null,'0x2334181c6068aab18b348ecc1e2600b81e1c5f821eee3e204824'),
`col22`=abs(-21921) % 2,
`col23`=if(abs(1503277.6900540178)%100<20,null,-23298),
`col25`=if(abs(29674)%100<20,null,'0xc8d094f888ee20c83baef8d9380a168d40f4906e742a4dc0daeacb809e64095c71d510c7c0f83a6a0a04b8d6a0d9bea2dc3d4bd44d9c5002e440707c40ead8b3eb20a100a8524b1616a338a440ea02a25a08041810a08cac087cd47b4a79f08730946c5800600ae45e1c08f637'),
`col26`=if(abs(28642)%100<20,null,'insubstantiality\'s'),
`col27`=if(abs(-3188)%100<20,null,'exine\'s'),
`col29`=if(abs(-47)%100<20,null,-24131),
`col32`=if(abs(-3658)%100<20,null,'shortener\'s'),
`col34`='1917',
`col36`=abs(27782) % 2,
`col37`=if(abs(4864972.0244758446)%100<20,null,32302),
`col38`=if(abs(97)%100<20,null,-14079),
`col39`=if(abs(3362872.0521256141)%100<20,null,27191),
`col40`=if(abs(3348292.2110660113)%100<20,null,-1163),
`col41`=abs(-18533) % 2,
`col42`=if(abs(2094)%100<20,null,'Montparnasse'),
`col43`=if(abs(-15983)%100<20,null,'Massasoit\'s'),
`col44`=if(abs(2497)%100<20,null,'lags'),
`col45`='2057',
`col46`=if(abs(-31691)%100<20,null,'miscegenation\'s'),
`col47`=if(abs(-1269564297)%100<20,null,1089),
`col49`=if(abs(-1815717335)%100<20,null,-17504),
`col51`=if(abs(-15263)%100<20,null,'virelay'),
`col52`=if(abs(2227333.3279519030)%100<20,null,-5210),
`col53`='2032',
`col54`=if(abs(791647.5947447127)%100<20,null,32576),
`col55`=if(abs(20293)%100<20,null,'tumblebug'),
`col56`=if(abs(4288698564.2967925000)%100<20,null,17141),
`col57`=if(abs(-2138460927)%100<20,null,14495),
`col59`=abs(7624) % 2,
`col60`=if(abs(-1500892492)%100<20,null,-68),
`col63`=if(abs(4290890487.3789482000)%100<20,null,-32129),
`col65`=if(abs(22)%100<20,null,15722),
`col79`=if(abs(4292420489.2606282000)%100<20,null,-23891),
`col84`=if(abs(-21248)%100<20,null,'0x4f9888d044435050eab83cb3dcad88b01886e434e216'),
`col85`=if(abs(4294260188.6230965000)%100<20,null,16867),
`col86`=if(abs(-11659)%100<20,null,'prewar'),
`col87`=if(abs(-2253)%100<20,null,'Radnorshire'),
`col90`=if(abs(4287254529.4026613000)%100<20,null,23506),
`col92`=if(abs(6472)%100<20,null,'electroplated'),
`col93`=if(abs(-13523)%100<20,null,'sparkiest'),
`col95`=if(abs(23998)%100<20,null,'Crimea'),
`col96`=if(abs(4287719060.2789087000)%100<20,null,20527),
`col98`=if(abs(-14090)%100<20,null,'firebrat'),
`col99`='19161023095430',
`col100`=if(abs(-31178)%100<20,null,'clinical'),
`col102`=if(abs(4407547.5205542166)%100<20,null,18226),
`col103`=if(abs(4286834687.5994444000)%100<20,null,27520),
`col104`=if(abs(-2105663477)%100<20,null,28591),
`col105`=if(abs(1929)%100<20,null,'renascent'),
`col107`=if(abs(5972348.8099917602)%100<20,null,-11408),
`col108`=if(abs(-11262)%100<20,null,'aircraftmen'),
`col110`=if(abs(6530491.4546037167)%100<20,null,-17672),
`col111`=if(abs(4289897795.5000763000)%100<20,null,3742),
`col112`=if(abs(1680557.8560441907)%100<20,null,13944),
`col113`=if(abs(-27195)%100<20,null,'dekameter'),
`col115`=if(abs(-2083419827)%100<20,null,-17272),
`col117`=if(abs(1704826)%100<20,null,17880),
`col118`=if(abs(-2848)%100<20,null,'judicatory'),
`col119`=if(abs(-28087)%100<20,null,'mistitles'),
`col120`=if(abs(-2100119097)%100<20,null,22465),
`col121`=if(abs(-1868777891)%100<20,null,15172),
`col122`=if(abs(7039857.3608508557)%100<20,null,-22154),
`col125`=if(abs(70)%100<20,null,'Hong\'s'),
`col126`=if(abs(3820673.5968199712)%100<20,null,-24185),
`col127`=if(abs(12331)%100<20,null,'0x674e14584e88fca3fed0a0b1488a440008228aa01454a65cf09e3f0fa0511c3ce2f8688450'),
`col128`=if(abs(20335)%100<20,null,'Zoroaster\'s'),
`col129`=if(abs(3916577.6225165562)%100<20,null,-4088),
`col130`=abs(-15003) % 2,
`col132`='2016',
`col134`=if(abs(-26555)%100<20,null,'Caesarea'),
`col135`=if(abs(4288484655.2416148000)%100<20,null,-30073),
`col136`=if(abs(-17577)%100<20,null,'upbraid'),
`col137`=if(abs(-1742797945)%100<20,null,-21651),
`col138`='20751113181230',
`col139`=if(abs(4288997063.9889216000)%100<20,null,1816),
`col141`=if(abs(-31448)%100<20,null,'threnodist'),
`col142`=if(abs(88)%100<20,null,-19748),
`col143`='6930607',
`col144`='5760250',
`col145`=if(abs(3591496.9625843074)%100<20,null,76),
`col146`=if(abs(20875)%100<20,null,'rename'),
`col147`=if(abs(4294789439.6773582000)%100<20,null,32314),
`col148`=if(abs(7072)%100<20,null,'recesses'),
`col150`=if(abs(-26540)%100<20,null,'cuckoo'),
`col152`=if(abs(23553)%100<20,null,'shortened'),
`col153`=if(abs(-30422)%100<20,null,'inhabitant'),
`col154`=if(abs(30457)%100<20,null,'Orwellian'),
`col155`=if(abs(-30263)%100<20,null,'Ptolemies'),
`col156`=if(abs(-41)%100<20,null,6382),
`col157`=if(abs(2557)%100<20,null,'horsewhips'),
`col158`='2764427',
`col160`=if(abs(-15872)%100<20,null,'girlhood'),
`col161`=abs(15378) % 2,
`col163`=if(abs(4286662730.9309368000)%100<20,null,-19516),
`col167`=if(abs(-1881918655)%100<20,null,6927),
`col169`=if(abs(-14442)%100<20,null,-6392),
`col170`=if(abs(29965)%100<20,null,'resynthesis'),
`col173`=if(abs(-451)%100<20,null,'Clute'),
`col174`=if(abs(3262594.6284981840)%100<20,null,17846);

check table table66;

/*comment the next line to get a crash !*/
delete from `table66` where `col5` = '2128';

check table table66;

update ignore `table66` set `col165`=repeat('a',7000);
check table table66;