drop table if exists t2; create table t2(a varchar(255),b char(255),key(a))engine=maria row_format=dynamic transactional=0; insert into t2(a,b) values(repeat('o',124),'a'); insert into t2(a,b) values(repeat('h',226),'a'); insert into t2(a,b) values(repeat('i',236),repeat('f',227)); insert into t2(a,b) values(repeat('l',234),repeat('s',71)); insert into t2(a,b) values (repeat('b',13),repeat('r',243)); insert into t2(a,b) values (repeat('g',236),repeat('h',108)); insert into t2(a,b) values (repeat('y',205),repeat('k',140)); insert into t2(a,b) values (repeat('c',99),repeat('i',214)); insert into t2(a,b) values (repeat('g',145),repeat('l',248)); insert into t2(a,b) values (repeat('o',131),repeat('v',181)); insert into t2(a,b) values (repeat('e',63),repeat('l',75)); insert into t2(a,b) values (repeat('q',155),repeat('c',101)); insert into t2(a,b) values (repeat('k',87),repeat('k',92)); insert into t2(a,b) values (repeat('i',54),repeat('z',86)); insert into t2(a,b) values (repeat('p',84),repeat('d',131)); insert into t2(a,b) values (repeat('m',119),repeat('j',146)); insert into t2(a,b) values (repeat('c',2),repeat('o',118)); insert into t2(a,b) values (repeat('a',174),repeat('p',147)); insert into t2(a,b) values (repeat('g',160),repeat('u',55)); insert into t2(a,b) values (repeat('t',147),repeat('s',99)); insert into t2(a,b) values (repeat('n',107),repeat('h',240)); insert into t2(a,b) values ('nupdjlafwfvuuvruxkyjxpmupihzgspkaybijztkeukgzzkrxmd','lrvgnmpagwhpyuoioeixvmxhmrynnaxpcjxtbsirqerzzggrklkxcfdeisfbyjpkikadvrweolewwqavotzkvzaneqmfafzaszwfndyiqlutjwucbsolxddxkhuexiqzhcggelytdkrddumteebabfdaqysqapklgkzltuoecfwjwljkkxnmzrxpbkpsxonrnyrtakbtqprymewmillggyvqdzjymjhrvidxkxzpixoxi'); insert into t2(a,b) values (repeat('g',40),repeat('z',14)); insert into t2(a,b) values (repeat('i',173),repeat('n',211)); insert into t2(a,b) values (repeat('q',126),repeat('u',126)); insert into t2(a,b) values (repeat('i',217),repeat('c',116)); insert into t2(a,b) values (repeat('f',161),repeat('y',38)); insert into t2(a,b) values (repeat('i',28),repeat('z',200)); insert into t2(a,b) values (repeat('a',35),repeat('b',1)); insert into t2(a,b) values (repeat('y',27),repeat('j',94)); insert into t2(a,b) values (repeat('o',100),repeat('d',12)); insert into t2(a,b) values (repeat('o',175),repeat('x',63)); insert into t2(a,b) values (repeat('f',69),repeat('o',92)); insert into t2(a,b) values (repeat('k',156),repeat('u',190)); insert into t2(a,b) values (repeat('n',220),repeat('b',143)); insert into t2(a,b) values (repeat('q',247),repeat('w',152)); insert into t2(a,b) values (repeat('y',180),repeat('t',31)); insert into t2(a,b) values (repeat('v',209),repeat('n',224)); insert into t2(a,b) values (repeat('m',169),repeat('k',63)); insert into t2(a,b) values (repeat('y',170),repeat('k',25)); insert into t2(a,b) values (repeat('r',151),repeat('y',137)); insert into t2(a,b) values (repeat('d',38),repeat('q',71)); insert into t2(a,b) values (repeat('g',64),repeat('j',3)); insert into t2(a,b) values (repeat('k',77),repeat('n',52)); insert into t2(a,b) values (repeat('l',150),repeat('v',52)); insert into t2(a,b) values (repeat('s',150),repeat('b',82)); insert into t2(a,b) values (repeat('u',127),repeat('i',226)); insert into t2(a,b) values (repeat('l',15),repeat('e',128)); insert into t2(a,b) values (repeat('m',33),repeat('b',51)); insert into t2(a,b) values (repeat('r',177),repeat('d',144)); insert into t2(a,b) values (repeat('v',197),repeat('g',171)); insert into t2(a,b) values (repeat('k',62),repeat('t',145)); insert into t2(a,b) values (repeat('h',219),repeat('q',46)); insert into t2(a,b) values (repeat('u',161),repeat('i',40)); insert into t2(a,b) values (repeat('y',118),repeat('a',115)); insert into t2(a,b) values (repeat('i',184),repeat('l',150)); insert into t2(a,b) values (repeat('z',202),repeat('d',237)); insert into t2(a,b) values (repeat('j',113),repeat('p',30)); insert into t2(a,b) values (repeat('q',95),repeat('n',183)); insert into t2(a,b) values (repeat('q',164),repeat('s',181)); insert into t2(a,b) values (repeat('e',54),repeat('a',177)); insert into t2(a,b) values (repeat('e',60),repeat('j',121)); insert into t2(a,b) values (repeat('l',203),repeat('p',55)); insert into t2(a,b) values (repeat('g',77),repeat('p',193)); insert into t2(a,b) values (repeat('y',44),repeat('s',198)); insert into t2(a,b) values (repeat('j',196),repeat('y',85)); insert into t2(a,b) values (repeat('t',45),repeat('o',39)); insert into t2(a,b) values (repeat('l',190),repeat('f',74)); insert into t2(a,b) values (repeat('l',89),repeat('d',19)); insert into t2(a,b) values (repeat('q',45),repeat('g',208)); insert into t2(a,b) values (repeat('e',191),repeat('b',139)); insert into t2(a,b) values (repeat('t',38),repeat('u',91)); insert into t2(a,b) values (repeat('f',148),repeat('d',135)); insert into t2(a,b) values (repeat('c',25),repeat('c',208)); insert into t2(a,b) values (repeat('v',97),repeat('w',214)); insert into t2(a,b) values (repeat('i',83),repeat('r',244)); insert into t2(a,b) values (repeat('s',166),repeat('h',231)); insert into t2(a,b) values (repeat('d',96),repeat('o',49)); insert into t2(a,b) values (repeat('v',82),repeat('x',91)); insert into t2(a,b) values (repeat('n',127),repeat('i',30)); insert into t2(a,b) values (repeat('i',201),repeat('r',157)); insert into t2(a,b) values (repeat('x',184),repeat('u',178)); insert into t2(a,b) values (repeat('d',76),repeat('s',234)); insert into t2(a,b) values (repeat('u',17),repeat('i',149)); insert into t2(a,b) values (repeat('a',178),repeat('x',142)); insert into t2(a,b) values ('hwvfiavnmufgbulapzrolonwxufheqymvjncnczlzcjokzqlsvmomcjzgzwzquyxpunxdmotdczocwliaprpubwaeccsulvittgizcutxxb','ztphigaaorgrbasqqrpwtxfkukjbbeufcwsuxftrkfffyyroymiccfjsvpaaczpducmcjdnbyurblsnbtcnwqmrplktbbdoxiahfgjfovoodtbjoyckqgapwfeieremdsuimzxhlydzzpbkpjboulyyiwguxkielgqvipsfpsaezkmxwgrwfdbuhlvhainsotdw'); insert into t2(a,b) values (repeat('x',28),repeat('i',240)); insert into t2(a,b) values (repeat('p',21),repeat('t',115)); insert into t2(a,b) values (repeat('k',241),repeat('c',135)); insert into t2(a,b) values (repeat('i',243),repeat('i',219)); insert into t2(a,b) values (repeat('b',172),repeat('g',83)); insert into t2(a,b) values (repeat('z',94),repeat('h',63)); insert into t2(a,b) values (repeat('i',218),repeat('w',129)); insert into t2(a,b) values (repeat('a',177),repeat('s',232)); insert into t2(a,b) values (repeat('g',251),repeat('m',88)); insert into t2(a,b) values (repeat('q',161),repeat('h',210)); insert into t2(a,b) values (repeat('x',231),repeat('b',218)); insert into t2(a,b) values (repeat('p',51),repeat('i',77)); insert into t2(a,b) values (repeat('f',141),repeat('e',14)); insert into t2(a,b) values (repeat('m',28),repeat('h',31)); insert into t2(a,b) values (repeat('r',77),repeat('h',81)); insert into t2(a,b) values (repeat('h',56),repeat('x',162)); insert into t2(a,b) values (repeat('k',23),repeat('d',4)); insert into t2(a,b) values (repeat('f',198),repeat('x',38)); insert into t2(a,b) values (repeat('o',243),repeat('m',101)); insert into t2(a,b) values (repeat('d',160),repeat('p',88)); insert into t2(a,b) values (repeat('h',82),repeat('a',212)); check table t2 extended;