DROP DATABASE IF EXISTS mysql971ph2561;
CREATE DATABASE mysql971ph2561;
USE mysql971ph2561;
CREATE TABLE IF NOT EXISTS t0(c0 FLOAT  COLUMN_FORMAT FIXED , c1 FLOAT   UNIQUE COMMENT 'asdf' , c2 FLOAT , c3 SMALLINT , c4 LONGTEXT   COMMENT 'asdf'  COLUMN_FORMAT DEFAULT);
CREATE TABLE t1 LIKE t0;
CREATE TABLE t2(c0 MEDIUMTEXT , c1 FLOAT , c2 VARCHAR(500)  COLUMN_FORMAT FIXED COMMENT 'asdf'  STORAGE MEMORY , c3 DECIMAL  STORAGE MEMORY);
INSERT INTO t0(c4, c1, c2) VALUES("", 0.48950625577033136, 0.31421630014781743), ('po', 0.27294712745202976, 1227275979), ('*[', 0.5895831154988895, 0.7080381468754681), ('jMht', -1443174877, 116445250), ('', 0.3622061602240113, 1.576079809E9), (".T?", 251319078, 284577590), ('', 1725132829, -1313071887), ('()', -187699710, 1011893768);
REPLACE LOW_PRIORITY INTO t0(c4) VALUES(""), (""), ('/&'), ("	w"), ("Ho");
INSERT LOW_PRIORITY IGNORE INTO t1(c1, c0, c3) VALUES(-681828716, -799551601, -278385418), (-1131205093, 0.4383497834878046, 1622329420), (-2.07871732E8, 0.7275991586204398, -1358909225), (922764031, 0.5695492757671811, -1959966628), (471649200, 622680641, -1237512248), (-1428467933, 0.21026210691494573, 1820878117);
INSERT DELAYED IGNORE INTO t1(c4) VALUES("*?CvzhE"), ("q?P5"), ('|g'), ('6B'), ("z~7'Tl"), ("Ij"), (''), ("q7");
INSERT LOW_PRIORITY IGNORE INTO t1(c4, c1) VALUES('Z/6''QU''G?', 0.7130387502021294), ("(<", 1563649596), ("", -615829971), (">?U%Nv", -384443193), ("", 395845768), ('', -1856143671);
INSERT HIGH_PRIORITY IGNORE INTO t2(c3, c1, c0) VALUES(0.7402906804175591, 0.3899040273493034, "s\r3)} x"), (0.25276134942257134, 0.02185789443148256, ''), (0.6511988609681834, 0.5008667616494594, '0?A*'), (-1647596405, 0.26753817149657366, "0.05828183694400013"), (-1537547464, -438825827, ""), (-1375007910, -472074140, '2izofH<');
REPLACE DELAYED INTO t2(c2, c3, c1, c0) VALUES("?", -980382076, 0.8526878664552373, "qC][]"), ("", -1.753107688E9, -883949480, "~XZN"), ('0.7918606092718725', 1643819497, -1.886003638E9, 'e?'), ("", 0.7105095742323133, 1486951353, "");
INSERT HIGH_PRIORITY INTO t0(c1) VALUES(0.14444238906819917), (-1618045906), (0.9095328501435632), (-300001021), (0.19296876344421088);
INSERT DELAYED IGNORE INTO t2(c2) VALUES(">9"), ("[c^SS9)R"), ("0.22129878703767658"), ("D#");
INSERT DELAYED INTO t1(c1, c2, c4, c0) VALUES(1962451344, 0.8496054271743427, '?c', 1775041009), (870990285, 9223372036854775807, "7h", -20085987), (711260699, 0.22224100545688164, "0.700436742264125", 623791152), (997856727, 2.8457759E8, '', 0.044012879147072526);
INSERT IGNORE INTO t1(c3) VALUES(-2008628221), (-2056242039), (1708856244), (-184275310), (-207871732), (1966046962);
select TABLE_NAME, ENGINE from information_schema.TABLES where table_schema = 'mysql971ph2561';
INSERT LOW_PRIORITY IGNORE INTO t2(c2) VALUES("Z?#K"), ("-668670671"), ("6}*bW7"), ("|JXx"), ('Pq'), ('1718835606');
REPLACE LOW_PRIORITY INTO t2(c1, c2) VALUES(0.9719919494015682, 'h{v'), (0.9919592610531943, '-1035534476'), (-1546128380, '5Sd4k'), (-1.546494831E9, "Tl"), (0.9591814357704601, "-,"), (0.05828183694400013, 'J(U/9lA'), (-756203063, '1415380838'), (680577146, "\rd");
INSERT INTO t2(c3, c2, c1, c0) VALUES(-1061798483, 'e[] ', 442749178, '-1237512248'), (0.20383814778719067, 'Bm', 205062960, 'GHi.dPo?'), (-510701967, '?[', -1892473064, ''), (0.203111160572521, "QE", 0.692891394838368, 'Y|wz-S{3'), (0.31969091294489593, "NdUC*D", 0.005523375530233188, "#vr"), (393959962, '-284592168', 0.7235811317512307, ""), (0.30452084852402794, '<n?r?[JE', 353770333, '-1443174877');
REPLACE DELAYED INTO t0(c4) VALUES("WBJHm"), (''), ('_JM{'), ("-18004612");
INSERT LOW_PRIORITY IGNORE INTO t2(c0, c3, c2, c1) VALUES("", 0.02816169368545074, "-1621638712", 2.49674416E8), ("h", 1283955242, "", 0.38955783076350714), ('', 418542953, "", 0.7744594595289656), ("Iq", 0.23877264554837963, "", 0.8029121906994139), ("!#", -799551601, "vH", 361101619), ("0.6588934249580235", -1974209245, "?{1", 0.8610418529084488), ('B?y_', 1.313886515E9, '2A', 498392843);
INSERT IGNORE INTO t0(c4, c1) VALUES('Rz', 0.3990389091677382), ("?%", 0.4235462552920235), ("ZG?", 1794214737), ("-1753107688", -1647596405), ("", 1083763143), ('0.043853129880065955', 0.8014834608353583);
REPLACE INTO t1(c2) VALUES(0.14945981960570853), (0.31608646233925475), (-1443174877), (246018033), (-1322511552);
REPLACE INTO t2(c0, c3, c2, c1) VALUES("eT", 0.14715369381626686, "-925787678", 0.253442247881832), ('Q?', -331758868, "?.", 0.42103893276122695), ("", -964749987, '-1114334734', 0.6244245491553043), ('^/9''U4p', 0.4877876300398172, '', 936033141), ('?D', 0.21297716191072835, "B,", -94443685), ("0.3233297323805754", 0.498184008591528, "249674416", 0.8661435551161886), ('-1515463732', 0.33778011792732876, "", -1153836401), ("", 416112041, '0.37663270864672604', 0.336811726036944);
INSERT LOW_PRIORITY IGNORE INTO t1(c1, c2, c3, c0, c4) VALUES(0.7954521518877629, 0.24446450063189795, -1670576337, -2056242039, "1645866103"), (0.27853446507884083, 0.19423584015679163, -501013037, 1718835606, '0.0'), (0.8354776856577967, -799551601, -624085013, 654276673, '-1942980955'), (-1509535772, -1974209245, 612362416, 0.5273442123966795, "gv"), (-1347333248, 1.31873913E9, -1110088828, -742444927, ".)"), (1573484620, 0.7080381468754681, -2137220738, 0.3338229605335481, "%"), (0.08141908409779286, -2089263960, -1620978352, 1177776312, "s\r S<D|"), (-434607642, -4.79757001E8, -1647596405, 0.6668045012367918, "N");
INSERT HIGH_PRIORITY IGNORE INTO t2(c2) VALUES('?c'), ("o~/)(]CN"), ('-1515463732'), ('205062960'), (""), (""), ('0.6978681869910514'), ("_*");
REPLACE DELAYED INTO t0(c0, c1) VALUES(-1333959235, 0.3265870171580535), (-466085871, 780079086), (-1753107688, 0.4175196662467118), (0.9095328501435632, 0.9163141957375355), (-293737436, 0.7709491060722784), (711260699, 0.5282051352753914), (778654464, 1475108752);
REPLACE LOW_PRIORITY INTO t2(c3, c1, c2, c0) VALUES(395227896, -7.99551601E8, '', 't'), (0.2782604453375864, 1304892540, "-434607642", "0.22389367073725874"), (0.29820991842423794, -1144984332, 'v|', "0.7080381468754681"), (-1181096596, 1153405968, '0.3200818031297431', 'Ls'), (-1.759566122E9, -6.81828716E8, '+	(.	)?sbbj', '0.544103057379504'), (0.6005334930359246, 0.008684775303127834, '+Aau8^\r%\r', '');
INSERT INTO t0(c1) VALUES(0.1719638103458042), (0.19654122560215015), (1718835606), (2046196771), (2.0506296E8), (1032495874), (-207871732);
INSERT HIGH_PRIORITY IGNORE INTO t0(c0, c2) VALUES(380030979, 0.04151173468066305), (-1691516030, 1415380838), (0.663915780460966, 1645866103), (-1140503314, 0.6066393257418741), (0.019435660222356876, 1064896368), (-1814010264, 0.275650395112512), (0.6336005574626532, 1575534942);
INSERT DELAYED IGNORE INTO t0(c3, c2, c0) VALUES(-1489960823, -1838273980, -1.114334734E9), (-1023013662, 0.5719514333231681, 834193636), (-434607642, 0.7080381468754681, -104846671), (2073086743, 0.15342010280427754, 0.7780125715160835), (1587661989, -384443193, 1859514753);
INSERT HIGH_PRIORITY INTO t0(c2) VALUES(-1885379446), (303655783), (1446691189), (914847136);
INSERT DELAYED IGNORE INTO t2(c1) VALUES(-668670671), (1.718835606E9), (-2.04715113E9), (-1.764764393E9), (499462476), (233343431), (-1417790631);
INSERT IGNORE INTO t0(c2) VALUES(0.3576317538557766), (3.17793955E8), (-643358360), (1504657588), (1646170357), (-411420309), (-807115784), (0.6104223206604443);
INSERT DELAYED IGNORE INTO t0(c4) VALUES('922764031'), (" "), ("317793955"), ('Ki8Fif'), ('wq');
REPLACE DELAYED INTO t0(c2, c1, c0, c4) VALUES(1135058908, 0.1325318797982492, 0.9284004077126781, "-18004612"), (0.9419312844997638, 0.2789165545490314, 320758634, "XlMc0"), (755997149, 1775113786, 0.3233297323805754, 'F}'), (2142110958, 2067901161, -287732062, "0.5182335384817575"), (0.6416116208500952, -770274145, -1922351922, '');
REPLACE INTO t2(c2, c0) VALUES(NULL, ''), (',?vUi~s', "A]G'aT"), ('0.5343399971563801', ''), ('fuU~Xw', '-1944456994');
REPLACE LOW_PRIORITY INTO t0(c2) VALUES(998222296), (1538845340), (-837875210), (-0.0);
INSERT IGNORE INTO t2(c3, c0, c2, c1) VALUES(-412754550, "612362416", "??cpYQC_", -1184414195), (-1035534476, '', '', 0.25560498061632786), (1822449994, '', '0.202386068956818', 295927022), (-988289737, "0.3677714625786833", ' JG.7)Y~', 1591115881), (0.9869590166846073, '0.02816169368545074', NULL, 303655783);
REPLACE DELAYED INTO t1(c4, c2) VALUES("?BZX?", 0.6503384297714633), ('0.029381546617354704', -1796335873), ('{U?w)? <?', 660278527), ('0.6446996696071913', 0.5172416716697339), (NULL, 0.7759000603556885), ('/4', -1418556728);
REPLACE INTO t2(c0, c1, c2, c3) VALUES("0.544103057379504", 2046196771, '1015486667', NULL), ("kv", 1852118361, 'u?', 0.1226960484245051), ("0.8760563196535007", -9.25787678E8, "", 0.9509757480741622), ("?", 1415380838, '', 0.2882252222830397), ('{', 1.446691189E9, '0.3233297323805754', 0.8513446653444012), ("4'", 0.7010603126559137, '-756203063', 0.9078197759315867), ('.Lt<	4?_', 723450919, "n}", 0.1034254061498967);
REPLACE DELAYED INTO t1(c0, c2, c4, c1) VALUES(-261838644, 1616466725, "", 1446691189), (1132257953, -565018625, "-434607642", -1035534476), (-1065845965, -584743529, 'W ', 0.021409336055707495), (0.08196032209510429, 0.8242076046692439, "BzE*lrA9T", 1142635704), (0.29275601425541353, 711627220, "", 0.9628445965067693), (0.9390347765384225, -1515463732, 'iB?e?(', -303156016), (0.03164912538050968, 0.24506978251295708, "D&25>B", 0.4258249310906551);
REPLACE DELAYED INTO t2(c1, c3, c0, c2) VALUES(1.718835606E9, -1412250084, "5IW", 'p?'), (0.34268058502502097, 0.06714579137017129, '-1618045906', "922764031"), (0.024501092931039303, 0.5370205868316975, '922764031', "?MNMb"), (0.06897243334017522, -1337571915, '', ''), (1895884136, -312855952, "0.28248414451247816", ""), (0.9543718084840112, -1730972048, 'v{', '0.7206430526618723');
INSERT IGNORE INTO t2(c2, c0, c3) VALUES('A?	', "", 0.5066490213697501), ("?0KnC", '?KZ', -668670671), ("U,", "", 0.04732164498854863), ('', "_DXK?E", 0.7080381468754681), ("Qh", '?', -1.515463732E9), ('V', '1318739130', -288888427), ('M?', '1502532229', 1545501368);
REPLACE LOW_PRIORITY INTO t1(c2, c0) VALUES(654045071, -1.443174877E9), (513050341, 0.38736650407852014), (-87393247, 1975541358), (0.0018121704030192864, 0.949572452041154), (3.03655783E8, -668194116), (1.346667614E9, 102673283), (1473210896, 0.012720010372740953), (0.9284933123355136, -1221570348);
REPLACE LOW_PRIORITY INTO t2(c3, c0) VALUES(0.2436782303100269, 'yZWX'), (2073086743, "4\r?9"), (1446691189, ''), (0.29726664040782924, "J5}?p"), (-461042012, '-1530842887'), (0.17276620215687832, '*'), (0.14774116572075524, ""), (0.331270136908977, "{n?w");
INSERT DELAYED INTO t2(c3, c0, c1) VALUES(-1800602947, "", 0.08761552456413602), (1442203362, "?", -1906914707), (-1130192812, 's', 0.6683825105165772), (2073086743, 'cYDk?]f', 0.013766233788220283), (0.8044751979891577, '.!*9g*x', 284577590), (0.60639139681454, '', 0.5804279830560739);
REPLACE LOW_PRIORITY INTO t2(c3, c0) VALUES(0.8169822925389958, '9c'), (0.5864479148542715, '0.278763547368714'), (0.2827310181986956, ''), (-813291841, '*N'), (1.47526367E8, ''), (710597196, '0.202386068956818'), (-1619991836, NULL);
INSERT LOW_PRIORITY IGNORE INTO t1(c1, c4) VALUES(-3.84443193E8, '?s9'), (7.11260699E8, '-1322511552'), (-1443174877, 'Dl'), (-1621638712, '-1647596405'), (0.6776593175770494, ''), (-1455862364, ""), (NULL, "e?");
INSERT INTO t2(c1, c3, c2) VALUES(0.8742258142532857, 1935324560, ".r"), (4095651, 0.5066485410083403, "1645866103"), (0.061492432581154, 0.4251361088543555, ""), (0.909077923409001, 0.24782921047800022, "w?"), (0.37983698116791564, 1311132024, "XlGFSvI<?"), (0.6802720234171651, -9.25787678E8, ""), (0.08308074308331193, -18004612, 'lL');
INSERT IGNORE INTO t2(c3) VALUES(0.04669132177385038), (-957639100), (0.7813916005246123), (0.28550959623895544), (0.6674303825481759);
REPLACE INTO t2(c0, c1) VALUES("2!Zk]6/k", 0.341954963365682), ('', 0.469904377971857), ('', 0.3678303055207526), ("0.3677714625786833", 1110765164), ("TRUE", -87393247), ("-284592168", 0.43582307979642587), ('znd', 0.6748526856388999);
REPLACE INTO t0(c0) VALUES(0.37198196194075317), (0.2713602727102148), (0.2536320801988776), (1385402315), (-269877577);
REPLACE LOW_PRIORITY INTO t1(c0, c2, c4) VALUES(-1618045906, 0.1406047188470524, '-2047151130'), (0.3462802414915256, 1.486951353E9, "Jm"), (0.855613783772057, 0.7178571582652238, "<{JsT>YMZ"), (0.3351110583466502, -184275310, "H-"), (1775041009, 0.2681183748924424, ' 6RfB2j'), (-7.56203063E8, 1292962678, '');
INSERT INTO t1(c1, c4) VALUES(0.537907057976629, "?>ukm?c2!"), (0.7370086033893144, ')%'), (-1025252985, '0.6771841193753205'), (0.2447833894878907, "ih+?(?_vG"), (-668670671, ""), (-284592168, '');
REPLACE LOW_PRIORITY INTO t2(c0, c2) VALUES('711260699', "\ro?ya9q}R"), ("", 'W'), ('', ""), ('rQ', "44Z19"), ('{S', "E3"), ('B?', '/'''), ('', "u"), ('I', '');
INSERT LOW_PRIORITY IGNORE INTO t2(c3, c0) VALUES(-1586344147, 'QQ'), (-0.0, '0.25560498061632786'), (395280903, 'gUF'), (-8.7393247E7, "()"), (0.6272261040938534, "_.Ii,?3"), (-416790076, '680577146'), (-298334925, '-');
CREATE INDEX i0 ON t2(c0(8));
SET SESSION information_schema_stats_expiry = 0;
ANALYZE TABLE t0, t1, t2;
ANALYZE TABLE t0 UPDATE HISTOGRAM ON c0, c1, c2, c3, c4;
ANALYZE TABLE t1 UPDATE HISTOGRAM ON c0, c1, c2, c3, c4;
ANALYZE TABLE t2 UPDATE HISTOGRAM ON c0, c1, c2, c3;