## Test case for bug 36172#--sourceinclude/not_embedded.inc--sourceinclude/have_innodb.incSETstorage_engine=InnoDB;# we do not really care about what gets printed, we are only# interested in getting success or failure according to our# expectations--disable_query_log--disable_result_loglet$file_format=`select @@innodb_file_format`;let$file_format_check=`select @@innodb_file_format_check`;let$file_per_table=`select @@innodb_file_per_table`;SETGLOBALinnodb_file_format='Barracuda';SETGLOBALinnodb_file_per_table=on;DROPTABLEIFEXISTS`table0`;CREATETABLE`table0`(`col0`tinyint(1)DEFAULTNULL,`col1`tinyint(1)DEFAULTNULL,`col2`tinyint(4)DEFAULTNULL,`col3`dateDEFAULTNULL,`col4`timeDEFAULTNULL,`col5`set('test1','test2','test3')DEFAULTNULL,`col6`timeDEFAULTNULL,`col7`text,`col8`decimal(10,0)DEFAULTNULL,`col9`set('test1','test2','test3')DEFAULTNULL,`col10`floatDEFAULTNULL,`col11`doubleDEFAULTNULL,`col12`enum('test1','test2','test3')DEFAULTNULL,`col13`tinyblob,`col14`year(4)DEFAULTNULL,`col15`set('test1','test2','test3')DEFAULTNULL,`col16`decimal(10,0)DEFAULTNULL,`col17`decimal(10,0)DEFAULTNULL,`col18`blob,`col19`datetimeDEFAULTNULL,`col20`doubleDEFAULTNULL,`col21`decimal(10,0)DEFAULTNULL,`col22`datetimeDEFAULTNULL,`col23`decimal(10,0)DEFAULTNULL,`col24`decimal(10,0)DEFAULTNULL,`col25`longtext,`col26`tinyblob,`col27`timeDEFAULTNULL,`col28`tinyblob,`col29`enum('test1','test2','test3')DEFAULTNULL,`col30`smallint(6)DEFAULTNULL,`col31`doubleDEFAULTNULL,`col32`floatDEFAULTNULL,`col33`char(175)DEFAULTNULL,`col34`tinytext,`col35`tinytext,`col36`tinyblob,`col37`tinyblob,`col38`tinytext,`col39`mediumblob,`col40`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMP,`col41`doubleDEFAULTNULL,`col42`smallint(6)DEFAULTNULL,`col43`longblob,`col44`varchar(80)DEFAULTNULL,`col45`mediumtext,`col46`decimal(10,0)DEFAULTNULL,`col47`bigint(20)DEFAULTNULL,`col48`dateDEFAULTNULL,`col49`tinyblob,`col50`dateDEFAULTNULL,`col51`tinyint(1)DEFAULTNULL,`col52`mediumint(9)DEFAULTNULL,`col53`floatDEFAULTNULL,`col54`tinyblob,`col55`longtext,`col56`smallint(6)DEFAULTNULL,`col57`enum('test1','test2','test3')DEFAULTNULL,`col58`datetimeDEFAULTNULL,`col59`mediumtext,`col60`varchar(232)DEFAULTNULL,`col61`decimal(10,0)DEFAULTNULL,`col62`year(4)DEFAULTNULL,`col63`smallint(6)DEFAULTNULL,`col64`timestampNOTNULLDEFAULT'0000-00-00 00:00:00',`col65`blob,`col66`longblob,`col67`int(11)DEFAULTNULL,`col68`longtext,`col69`enum('test1','test2','test3')DEFAULTNULL,`col70`int(11)DEFAULTNULL,`col71`timeDEFAULTNULL,`col72`timestampNOTNULLDEFAULT'0000-00-00 00:00:00',`col73`timestampNOTNULLDEFAULT'0000-00-00 00:00:00',`col74`varchar(170)DEFAULTNULL,`col75`set('test1','test2','test3')DEFAULTNULL,`col76`tinyblob,`col77`bigint(20)DEFAULTNULL,`col78`decimal(10,0)DEFAULTNULL,`col79`datetimeDEFAULTNULL,`col80`year(4)DEFAULTNULL,`col81`decimal(10,0)DEFAULTNULL,`col82`longblob,`col83`text,`col84`char(83)DEFAULTNULL,`col85`decimal(10,0)DEFAULTNULL,`col86`floatDEFAULTNULL,`col87`int(11)DEFAULTNULL,`col88`varchar(145)DEFAULTNULL,`col89`dateDEFAULTNULL,`col90`decimal(10,0)DEFAULTNULL,`col91`decimal(10,0)DEFAULTNULL,`col92`mediumblob,`col93`timeDEFAULTNULL,KEY`idx0`(`col69`,`col90`,`col8`),KEY`idx1`(`col60`),KEY`idx2`(`col60`,`col70`,`col74`),KEY`idx3`(`col22`,`col32`,`col72`,`col30`),KEY`idx4`(`col29`),KEY`idx5`(`col19`,`col45`(143)),KEY`idx6`(`col46`,`col48`,`col5`,`col39`(118)),KEY`idx7`(`col48`,`col61`),KEY`idx8`(`col93`),KEY`idx9`(`col31`),KEY`idx10`(`col30`,`col21`),KEY`idx11`(`col67`),KEY`idx12`(`col44`,`col6`,`col8`,`col38`(226)),KEY`idx13`(`col71`,`col41`,`col15`,`col49`(88)),KEY`idx14`(`col78`),KEY`idx15`(`col63`,`col67`,`col64`),KEY`idx16`(`col17`,`col86`),KEY`idx17`(`col77`,`col56`,`col10`,`col55`(24)),KEY`idx18`(`col62`),KEY`idx19`(`col31`,`col57`,`col56`,`col53`),KEY`idx20`(`col46`),KEY`idx21`(`col83`(54)),KEY`idx22`(`col51`,`col7`(120)),KEY`idx23`(`col7`(163),`col31`,`col71`,`col14`))ENGINE=InnoDBDEFAULTCHARSET=latin1ROW_FORMAT=COMPRESSEDKEY_BLOCK_SIZE=2;insertignoreinto`table0`set`col23`=7887371.5084383683,`col24`=4293854615.6906948000,`col25`='vitalist',`col26`='widespread',`col27`='3570490',`col28`='habitual',`col30`=-5471,`col31`=4286985783.6771750000,`col32`=6354540.9826654866,`col33`='defoliation',`col34`='logarithms',`col35`='tegument\'s',`col36`='scouting\'s',`col37`='intermittency',`col38`='elongates',`col39`='prophecies',`col40`='20560103035939',`col41`=4292809130.0544143000,`col42`=22057,`col43`='Hess\'s',`col44`='bandstand',`col45`='phenylketonuria',`col46`=6338767.4018677324,`col47`=5310247,`col48`='12592418',`col49`='churchman\'s',`col50`='32226125',`col51`=-58,`col52`=-6207968,`col53`=1244839.3255104220,`col54`='robotized',`col55`='monotonous',`col56`=-26909,`col58`='20720107023550',`col59`='suggestiveness\'s',`col60`='gemology',`col61`=4287800670.2229986000,`col62`='1944',`col63`=-16827,`col64`='20700107212324',`col65`='Nicolais',`col66`='apteryx',`col67`=6935317,`col68`='stroganoff',`col70`=3316430,`col71`='3277608',`col72`='19300511045918',`col73`='20421201003327',`col74`='attenuant',`col75`='15173',`col76`='upstroke\'s',`col77`=8118987,`col78`=6791516.2735374002,`col79`='20780701144624',`col80`='2134',`col81`=4290682351.3127537000,`col82`='unexplainably',`col83`='Storm',`col84`='Greyso\'s',`col85`=4289119212.4306774000,`col86`=7617575.8796655172,`col87`=-6325335,`col88`='fondue\'s',`col89`='40608940',`col90`=1659421.8093508712,`col91`=8346904.6584368423,`col92`='reloads',`col93`='5188366';CHECKTABLEtable0EXTENDED;INSERTIGNOREINTO`table0`SET`col19`='19940127002709',`col20`=2383927.9055146948,`col21`=4293243420.5621204000,`col22`='20511211123705',`col23`=4289899778.6573381000,`col24`=4293449279.0540481000,`col25`='emphysemic',`col26`='dentally',`col27`='2347406',`col28`='eruct',`col30`=1222,`col31`=4294372994.9941406000,`col32`=4291385574.1173744000,`col33`='borrowing\'s',`col34`='septics',`col35`='ratter\'s',`col36`='Kaye',`col37`='Florentia',`col38`='allium',`col39`='barkeep',`col40`='19510407003441',`col41`=4293559200.4215522000,`col42`=22482,`col43`='decussate',`col44`='Brom\'s',`col45`='violated',`col46`=4925506.4635456400,`col47`=930549,`col48`='51296066',`col49`='voluminously',`col50`='29306676',`col51`=-88,`col52`=-2153690,`col53`=4290250202.1464887000,`col54`='expropriation',`col55`='Aberdeen\'s',`col56`=20343,`col58`='19640415171532',`col59`='extern',`col60`='Ubana',`col61`=4290487961.8539081000,`col62`='2147',`col63`=-24271,`col64`='20750801194548',`col65`='Cunaxa\'s',`col66`='pasticcio',`col67`=2795817,`col68`='Indore\'s',`col70`=6864127,`col71`='1817832',`col72`='20540506114211',`col73`='20040101012300',`col74`='rationalized',`col75`='45522',`col76`='indene',`col77`=-6964559,`col78`=4247535.5266884370,`col79`='20720416124357',`col80`='2143',`col81`=4292060102.4466386000,`col82`='striving',`col83`='boneblack\'s',`col84`='redolent',`col85`=6489697.9009369183,`col86`=4287473465.9731131000,`col87`=7726015,`col88`='perplexed',`col89`='17153791',`col90`=5478587.1108127078,`col91`=4287091404.7004304000,`col92`='Boulez\'s',`col93`='2931278';CHECKTABLEtable0EXTENDED;DROPTABLEtable0;EVALSETGLOBALinnodb_file_format=$file_format;EVALSETGLOBALinnodb_file_format_check=$file_format_check;EVALSETGLOBALinnodb_file_per_table=$file_per_table;