-- sql #1 create table t_evocp8e0 ( c_ray1y7y int unique , c_dcyscg tinyint unique , c_wdj4m tinyint unique , primary key(c_ray1y7y) NONCLUSTERED) shard_row_id_bits=4 pre_split_regions=2; -- sql #14 insert into t_evocp8e0 (c_ray1y7y, c_dcyscg, c_wdj4m) values (1511529463, (NOT NOT(cast( (452778752810411432 != cast(null as decimal)) as unsigned))), (NOT NOT(cast( (-690116 != 7373817114683487958) as unsigned)))), (-305425584, (NOT NOT(cast( (cast('da9' as char) <=> cast(cast(null as char) as char)) as unsigned))), (-374655375 is NULL)), (2019904431, (cast(null as char) not like 'ew_'), (2079804013 in ( 1657665902, cast(cast(null as signed) as signed), -1136741462, cast(cast(null as signed) as signed)))), (-1848528823, (NOT NOT(cast( (cast(2147483649.2 as double) != cast(-8336201020873985094 as signed)) as unsigned))), ((NOT NOT(cast( (5232122087662209983 || -2004320788) as unsigned)))) and ((NOT NOT(cast( (cast(cast(null as decimal) as decimal) != cast(-6461779 as signed)) as unsigned))))); -- sql #49 alter table t_evocp8e0 add column c_to int; -- sql #50 create table t_ktz ( c_q22yixwl int not null , c_kw48 int , c_u1 int unique , primary key(c_u1) CLUSTERED) pre_split_regions=6; -- sql #51 alter table t_ktz set tiflash replica 1; -- sql #52 insert into t_evocp8e0 select distinct cast( (((select c_q22yixwl from t_ktz order by c_q22yixwl limit 1 offset 2) is not NULL) DIV subq_0.c2) as signed) as c0, (NOT NOT(cast( (cast(subq_0.c1 as signed) <= cast(subq_0.c1 as signed)) as unsigned))) as c1, (cast( (cast((NOT NOT(cast( (cast((subq_0.c2 < ( select (select c_q22yixwl from t_ktz order by c_q22yixwl limit 1 offset 4) as c0 from t_ktz as ref_4 where (NOT NOT(cast( (7598067081203674781 >= subq_0.c2) as unsigned))) order by c0 desc limit 1)) as unsigned) = cast(-6196296739316181151 as signed)) as unsigned))) as unsigned) - cast(subq_0.c2 as signed)) as char) like 'qy_0_w') as c2, subq_0.c0 as c3 from (select distinct ref_0.c_q22yixwl as c0, count( cast(cast(null as char) as char)) as c1, count( cast((NOT NOT(cast( (cast(ref_0.c_u1 as signed) < cast(72.69 as double)) as unsigned))) as unsigned)) as c2, count( cast((NOT NOT(cast( (cast(68.75 as double) || cast(60.58 as double)) as unsigned))) as unsigned)) as c3, count(*) as c4 from t_ktz as ref_0 where (NOT NOT(cast( (cast(68.7 as double) <=> cast(ref_0.c_u1 as signed)) as unsigned))) group by ref_0.c_q22yixwl) as subq_0 where (NOT NOT(cast( (cast(bin( cast(6789897580854764272 as signed)) as char) <> cast(case when (NOT NOT(cast( (cast(cast(null as char) as char) = cast(cast(null as char) as char)) as unsigned))) then unhex( cast(substring( cast('givq' as char), cast((EXISTS ( select ref_1.c_kw48 as c0, ref_1.c_u1 as c1, ref_1.c_kw48 as c2, (select c_q22yixwl from t_ktz order by c_q22yixwl limit 1 offset 50) as c3, ref_1.c_q22yixwl as c4, ref_1.c_u1 as c5, ref_1.c_u1 as c6, (select c_q22yixwl from t_ktz order by c_q22yixwl limit 1 offset 3) as c7, ref_1.c_q22yixwl as c8, ref_1.c_q22yixwl as c9 from t_ktz as ref_1 where (NOT NOT(cast( (cast(65536.4 as double) > cast(ref_1.c_q22yixwl as signed)) as unsigned))))) as unsigned), cast((subq_0.c3 <= ( select ref_2.c_q22yixwl as c0 from t_ktz as ref_2 where ((select count(c_q22yixwl) from t_ktz) not in ( select cast(null as signed) as c0 from t_ktz as ref_3 where (ref_3.c_q22yixwl not in ( ref_3.c_q22yixwl, ref_3.c_q22yixwl, -412086586)))) order by c0 asc limit 1)) as unsigned)) as char)) else lower( cast('m8muj94z' as char)) end as char)) as unsigned))); -- sql #54 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-980691090, 720968098, 692803580), (1838158183, -147550210, 892060349), (1008831635, 568656218, -913910993), (125677754, -2044778190, 576002825); -- sql #55 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1954805604, cast(cast(null as signed) as signed), 1742170084), (124175570, -364451052, -1588634476), (340294794, -1845535615, 2079122742), (-2102322367, 537386738, -80567228); -- sql #56 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1139760513, -1630620254, 2065719422), (-1841402606, -1225441150, 1024316640), (-1186210152, -658162655, -758009664), (1907397344, 642124947, 1388287383); -- sql #57 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1272343829, 742199893, -1877381505), (-854158846, cast(cast(null as signed) as signed), 453094465), (426483306, 53317601, 1322760146), (381315892, -1652053959, -862974535); -- sql #58 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (2026535069, 1983268442, -315372195), (1419203897, cast(cast(null as signed) as signed), 227680935), (-1425339740, -1138479791, -681130049), (401904295, -632857992, 691044199); -- sql #61 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1793910701, cast(cast(null as signed) as signed), -1256528923), (546385387, -317871729, -1475966242), (1329216948, -2119967129, 1292944960), (1566353776, 1261329460, 527484353); -- sql #66 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-250156290, -62396196, 1074660415), (-376552123, -1170421915, -1006074896), (1465083955, 1045506977, -1472362716), (-1471102574, -2058723447, -940156955); -- sql #69 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1957733529, -757920270, -1304425823), (1511940893, 360686939, -1019774484), (1382508307, 1285496721, -1063146267), (1235410629, -2017694163, -1527884070); -- sql #70 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1091118597, -59978712, 113531947), (1835795179, -1791861041, 1323682111), (-1871919925, cast(null as signed), 1513572757), (-1031448576, 2081814201, 1159752590); -- sql #71 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1336448641, 587939591, -200559480), (657792569, -1903315799, -1247644107), (-564280634, 220694857, 1670600084), (-1703798255, 1865858587, -255537670); -- sql #72 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (2105478689, cast(cast(null as signed) as signed), -1564057558), (-229639509, cast(cast(null as signed) as signed), 883120378), (-1626578167, cast(cast(null as signed) as signed), -83435074), (538082019, -1908954668, -1169727194); -- sql #74 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-2033347188, -1391791987, 497275178), (1981999738, -1405821930, -1302659545), (-898210394, 666353675, -239110405), (1319776791, -1858059025, -1786537053); -- sql #77 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (763524754, -151216886, 199539232), (-1784431138, cast(null as signed), 222031379), (-773202002, 1218250558, -945206456), (-2028200887, 163808574, 2008484001); -- sql #78 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-905279633, -1005773645, 1427984467), (-291141943, 646052187, -716918946), (1002442544, -1742151682, -2111178477), (663742045, -1176773827, -638166839); -- sql #79 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (858853524, 1002174082, -2000763012), (1166811366, 1740276571, -1748444952), (-1506243327, -306661752, 2069571129), (-695453683, -1949016308, 2011979858); -- sql #80 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (178755408, -1592125108, 2026453516), (1088033360, -869859361, 908599746), (-1564125797, 1154357504, -1531189951), (-1717986463, -902070800, -1051188589); -- sql #81 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (331777310, -380557816, -1027978062), (-394449830, -1529954843, 1233647098), (416132310, -1375932931, -122288366), (1173947863, 517830597, 914867864); -- sql #84 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1599718201, -1361358700, -434334966), (453134700, -1429424051, -1894945765), (1041353587, 883699347, -1335949734), (2100563058, 1302947671, 1387627900); -- sql #85 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (138285977, 374648508, 3543665), (-28848974, -232306988, 1197908604), (-200169249, -424212012, -842845607), (74557808, cast(cast(null as signed) as signed), 244421545); -- sql #89 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1420452512, -1640922215, 1064472917), (1494513546, 467270130, 305347171), (-1466596258, cast(cast(null as signed) as signed), -408301906), (-1770844450, 1455056263, 1298704738); -- sql #91 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1075252860, cast(cast(null as signed) as signed), 1735442661), (802329304, -1605086566, 1793028887), (-1865118292, 793012253, 1789393247), (-500826050, -2032367313, -616888892); -- sql #93 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1708869615, -505702009, 1833805134), (1484279915, 2038491753, 2100777136), (778574674, 204494267, -753831511), (-524478809, 365950842, 1602880589); -- sql #94 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1504560003, 458756923, 1606721310), (1575794368, 1673689509, 615757588), (1916394737, 441774198, 1569348451), (-125232719, 1459766655, -1074991817); -- sql #95 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (154590109, 825429862, 1059345446), (525867555, -1324894380, -1203801487), (1343543077, -1478613319, 1019948655), (1711830885, -683631065, -2085416010); -- sql #96 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (986041339, 1459245127, 1845688103), (-1904693768, -417200126, -264869301), (-1017902946, 1367455466, -1959749229), (-1604961779, -2040425132, -692422631); -- sql #102 delete from t_evocp8e0 where (NOT NOT(cast( (cast((EXISTS ( select ref_0.c_u1 as c0 from t_ktz as ref_0 where ((NOT NOT(cast( (cast(ref_0.c_kw48 as signed) && cast(ref_0.c_kw48 as signed)) as unsigned)))) or ((NOT NOT(cast( (cast(ref_0.c_u1 as signed) XOR cast((select c_q22yixwl from t_ktz order by c_q22yixwl limit 1 offset 6) as signed)) as unsigned)))) group by ref_0.c_u1 order by c0 desc limit 136)) as unsigned) && cast(round( cast(t_evocp8e0.c_to as decimal)) as decimal)) as unsigned))); -- sql #104 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1140250868, 1139826719, 2040922452), (69994795, -875937281, -394892892), (591331238, 1171784545, -730518702), (122854258, 1937154689, 183741963); -- sql #108 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (402538045, -949889005, -2009518664), (492208117, cast(cast(null as signed) as signed), -1804401784), (2109645998, -555021285, 1052614958), (-1050570546, -352807091, -1741120573); -- sql #110 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1428653942, cast(cast(null as signed) as signed), 1933102523), (-1156872032, -1903352608, -695825285), (-638572216, -1585515185, 847173263), (634624048, 1385766498, 1867605030); -- sql #111 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1837868148, -97370710, 1257028967), (1019221013, 1993833173, -1444338505), (1711648736, -2050221368, -380758246), (-450094523, -761873470, 1593803200); -- sql #117 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-837477360, 2025282446, -164982215), (-1323359205, 1065309421, -1899087105), (-2061022938, -1230105550, -1984014934), (991513684, -400412536, 127014285); -- sql #118 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-806276858, -210475064, -41988467), (2079108813, cast(cast(null as signed) as signed), 3289299), (763848109, 411409909, 1100861693), (-222562389, -356250387, -1314314696); -- sql #120 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1291950732, 989069949, 557357007), (-900151698, -1773643608, 668769356), (-586903881, -1141450721, 2013522254), (-1937437152, -516299221, -227694665); -- sql #124 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1419848123, -546055341, 1921526207), (1772596963, -15221314, 465659443), (1120868833, cast(null as signed), 1561327474), (731611684, 293536865, -556223189); -- sql #126 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1756143415, 1687274784, -1510551597), (-1822238764, -1866740894, 665001212), (-1748938117, -970967845, -762408282), (181332285, -1111778810, 279599378); -- sql #128 analyze table t_evocp8e0; -- sql #129 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1641732984, -1891629084, 43706520), (-137503852, -1333713092, -827694992), (-864166781, cast(cast(null as signed) as signed), -1440168971), (96961182, 395257211, 2017724148); -- sql #131 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1548068526, -1994766127, -652282707), (-1774319947, 99343857, 22095465), (-1303904623, -305013892, 894923933), (-1389246097, 1010910710, 1164851798); -- sql #135 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1589100350, cast(null as signed), 1232807219), (-1320377605, 1614880320, -1303275717), (-1137085633, 2056851089, -932775510), (680389026, 386119263, 1980840266); -- sql #138 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (829153045, 709784464, -645799098), (-855581199, 395011378, 661842740), (-504994587, 1492113174, -2078499226), (2063216633, cast(cast(null as signed) as signed), -1019719929); -- sql #139 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1374368219, 1278887140, 1128165564), (1843860899, 1798655071, -1307438419), (-756908592, -1196894361, -73879307), (-326595977, -1758646086, -158184832); -- sql #141 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (832883253, -281629705, -1904523317), (-1008503312, 389428288, -1501218311), (-1607022072, -766795405, -332093872), (-707326219, -414963545, -860575618); -- sql #145 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1654069929, -602479792, 1150025322), (-1758455985, 1048806060, -710355758), (1665294802, cast(null as signed), -411169737), (311582360, 851280428, 668279365); -- sql #146 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1192574556, -1269621106, 1936551892), (-1634862905, cast(cast(null as signed) as signed), 2107429323), (1866054687, 1036614071, 673133951), (868025699, 970240446, -810322668); -- sql #147 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-276800957, -379751081, 1742376572), (185949225, cast(cast(null as signed) as signed), -364603122), (-1013621224, -1248250655, -411387118), (-773147814, 1560310124, 1608857389); -- sql #148 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-349980756, 880034088, -1963295577), (1110362642, 1641953980, 568881315), (-324530947, -1529764749, -1179847322), (2018144748, cast(null as signed), -150016354); -- sql #149 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (277234001, -1465435028, 2018415775), (-418152664, -1576765165, 398323111), (1541349009, -1038386984, 1377198124), (-64830234, -1410583118, -1089283715); -- sql #150 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (420053492, -518398037, -846187582), (-1893186876, -1344598195, -873538768), (439322306, -1976702773, -884735846), (-789451299, 2033669458, -1608706195); -- sql #152 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1255349768, -1565652984, -585993694), (-1739646712, -58046038, 1948453990), (584520020, -1355684458, -1165138970), (2108506722, -1186617346, -105708752); -- sql #155 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1191411062, 1535575001, -886462463), (-841341541, 1094788217, 1858203575), (-648928081, 599488091, -342479853), (-431567030, 1101424237, 1764373271); -- sql #156 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-253748906, cast(cast(null as signed) as signed), -1200791785), (78125112, 1655237191, -1143704809), (659727127, 1092348152, -1117744156), (-274546105, -776458500, -1029507385); -- sql #158 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-489825839, 1524376057, 387957920), (1137485371, -1153022099, -1370707943), (818704712, 1827852354, -2120659995), (-501243265, 460369520, -702247384); -- sql #161 delete from t_evocp8e0 where (cast(coalesce( (select c_kw48 from t_ktz order by c_kw48 limit 1 offset 18) , t_evocp8e0.c_ray1y7y ) as signed) not in ( select ref_0.c_q22yixwl as c0 from t_ktz as ref_0 where (ref_0.c_kw48 between ref_0.c_u1 and ref_0.c_u1) union ( select 715058729 as c0 from t_ktz as ref_1 where 1=1 ))); -- sql #162 update t_evocp8e0 set c_dcyscg = (((select c_u1 from t_ktz order by c_u1 limit 1 offset 2) is NULL)) or ((NOT NOT(cast( (cast((t_evocp8e0.c_dcyscg <> ( select (t_evocp8e0.c_to is NULL) as c0 from t_ktz as ref_0 where 0<>0 order by c0 asc limit 1)) as unsigned) > cast(t_evocp8e0.c_wdj4m as signed)) as unsigned)))) where (NOT NOT(cast( (cast(case when (t_evocp8e0.c_wdj4m is NULL) then case when (NOT NOT(cast( (cast(51.46 as double) < cast(9.23 as double)) as unsigned))) then cast(null as char) else 'v_i3' end else right( cast(cast(null as char) as char), cast(cast( (cast(t_evocp8e0.c_to as decimal) & cast((select c_q22yixwl from t_ktz order by c_q22yixwl limit 1 offset 6) as signed)) as signed) as signed)) end as char) < cast(space( 10) as char)) as unsigned))); -- sql #163 create index t_m_idx_1 on t_evocp8e0 (c_ray1y7y, c_dcyscg); -- sql #164 alter table t_evocp8e0 add column c_oq628f text; -- sql #165 create index t_qtfhf_idx_1 on t_evocp8e0 (c_ray1y7y, c_dcyscg, c_wdj4m, c_to); -- sql #166 create table t_c6sdm_smrn ( c_zch int , c_qcsmy0w int , c_lc5_gue5 int , c_yqxr int , c_j tinyint unique , c_x68 text , primary key(c_qcsmy0w, c_zch) NONCLUSTERED) shard_row_id_bits=5 pre_split_regions=2; -- sql #167 alter table t_c6sdm_smrn set tiflash replica 1; -- sql #168 alter table t_c6sdm_smrn add column c_n3le03 int; -- sql #169 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (336745809, 1120785573, 823849108), (439651816, -341648248, -1324458165), (1227342315, -1495776534, 1587715408), (-348536975, 1077343610, 1590611383); -- sql #172 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-54517710, cast(null as signed), 1854756631), (-1139915499, -635932880, -2116653652), (1188380154, cast(cast(null as signed) as signed), -1082813258), (-985247641, 1681394830, -1751457759); -- sql #174 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1482529650, -1585726734, 1611091185), (182385766, 777704572, -705458023), (244319460, cast(cast(null as signed) as signed), -1069328620), (-1726426416, -1458720033, -52640223); -- sql #178 insert into t_c6sdm_smrn (c_zch, c_qcsmy0w, c_lc5_gue5, c_yqxr, c_j, c_x68, c_n3le03) values (1676512998, 479598051, -1231345542, -365924370, (-1032829489 in ( 1075180203, -798425203, -841833998, -8446794)), 'jk9763', 366498594), (1123596132, 1093132148, -275714644, 1412791545, (NOT NOT(cast( (cast((NOT NOT(cast( (cast(129.2 as double) <= cast(-7340764041150593346 as signed)) as unsigned))) as unsigned) > cast(cast(null as double) as double)) as unsigned))), 'kdsis', -981101859), (-1242878580, -967246461, 141185548, -978496799, (NOT NOT(cast( (cast(65536.2 as double) != cast((-1579735594 in ( -360574698, cast(cast(null as signed) as signed), 312692271, -1894032694, -1252506343)) as unsigned)) as unsigned))), 'n1omf', 1787234354), (-158913372, 407965357, 2134532400, -1184425151, (1323496258 in ( -1680107480, cast(cast(null as signed) as signed), -728233524)), 'xdrkh_98i', -841646344); -- sql #179 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (606793654, -1559421018, 2084937796), (1648452407, 1976275098, -1083219876), (992681300, -349774431, -1178344500), (-2030568596, cast(cast(null as signed) as signed), -306431633); -- sql #180 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1860806192, -641778559, 1266475611), (-672469720, 126200956, -887458149), (753147793, 1415894511, -983541800), (1764204632, -1887718436, -1309526074); -- sql #184 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1149807704, 1986326385, 1481135978), (-1914044976, 867610947, 918600437), (-86905085, -141785992, -1886037625), (1037320931, -1204933541, 1090410422); -- sql #187 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1960135434, -2015802503, 1954145359), (-724584074, -1310367453, -1129336450), (113027323, 1861835841, 1493339317), (-1243627361, -1712061386, 1017392118); -- sql #190 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (506939459, 264307094, -1694783769), (-1384515268, 1151841356, -1726420308), (-651881380, 1552228506, 1389831702), (-1042459442, -1238403718, 1059827488); -- sql #198 analyze table t_evocp8e0; -- sql #199 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1030987217, -607861572, 965933009), (1531898057, -754152362, -1317476350), (293547975, 132708421, 1184675329), (-444930631, 445878777, -737551487); -- sql #203 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (837007173, -1112068367, -1727932273), (-339918594, -317199942, 680212735), (-1426494772, -691386601, -347464192), (-1506778564, 95754749, -958839483); -- sql #204 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1391668247, 1668686491, -174394574), (-1157405371, -1481487256, -2074898605), (-95461795, -1985207545, 569364121), (599918721, -1346533366, -1126586932); -- sql #207 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1576804954, 688509608, 680004700), (-619152364, -1414721978, 122297262), (1983582500, -1132386254, -1870660176), (-667754040, cast(cast(null as signed) as signed), 693636153); -- sql #209 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1360213345, cast(cast(null as signed) as signed), 906754181), (1531276716, cast(cast(null as signed) as signed), -1658478508), (-437161306, -577799123, 831066791), (-1167358525, -599797986, -311831491); -- sql #211 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-242213793, 45225782, 2084875623), (-1474643951, -348075258, 1748977172), (-1081474578, 1209349366, -115507448), (1182805204, 694945180, -1414460263); -- sql #215 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (357694127, cast(cast(null as signed) as signed), -1628153098), (-116920452, -2001702752, -749324678), (-1178406877, -523492352, 1693136145), (-1154817013, 1415544281, 1835103943); -- sql #218 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-611777027, cast(cast(null as signed) as signed), 426816011), (628791097, -5098100, 1659879866), (1769808645, 2089860148, -570690658), (2036392307, 1257825850, 806612631); -- sql #219 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1206355406, -1963473704, 2034919858), (1071976592, cast(cast(null as signed) as signed), 1785269826), (-1868398058, -339248992, -1712406100), (-1905176955, cast(cast(null as signed) as signed), -164457111); -- sql #223 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1732792108, -1812212810, 1246305625), (-282780615, -906584455, -1979779894), (458175370, 750228917, -1061438869), (-814246091, 178881042, 1177938557); -- sql #224 analyze table t_ktz; -- sql #229 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1058981800, 1963866050, -1982266053), (733789980, cast(null as signed), 542712878), (1845497360, cast(cast(null as signed) as signed), 1298555140), (-656323989, -1989261178, 858374778); -- sql #230 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1381303964, cast(cast(null as signed) as signed), -2078956202), (244788792, -1545433324, -1626099493), (-1387693367, 600910954, -318229360), (2014965224, -1466090186, 778441256); -- sql #233 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1483590555, 974004818, -1915936819), (-484381828, 958463544, -739874317), (1306471625, 166283553, 644154562), (134831033, -286135396, -538031028); -- sql #235 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (276849706, -62839458, 1019413228), (160483030, 906009490, -1516771010), (-2143094989, 521011959, 1412918967), (-891250173, -1271626981, 821972042); -- sql #238 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1073496665, cast(cast(null as signed) as signed), -1249450939), (-1818975585, cast(null as signed), 891517536), (-522176687, -29651194, 1460336145), (1430605290, -1160611833, -456049145); -- sql #244 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (546494716, -1165023472, 908628869), (480795989, 837587662, -1429129751), (-1434925660, 570908301, 1772571061), (867571943, -1686673388, -1173484483); -- sql #246 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-559456268, 453133730, -268387842), (-163808349, -2025770893, -633344171), (-496613582, -1896019953, -1763265784), (-1367326497, -840672856, -264128445); -- sql #247 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (2081727526, -1937974949, 456422811), (-613551931, 1536665675, -153407721), (1884743541, 422547007, 864363615), (-1403302426, 84489639, 1771659259); -- sql #249 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-400273719, 408776799, 1311896759), (-348696003, 902159113, 24607152), (-961728632, cast(cast(null as signed) as signed), 1992371703), (-542051410, -736627117, 282880173); -- sql #251 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (67985885, -1585505553, -1119316011), (-1384846413, 611736678, -1105951784), (-1675581204, 1313218002, 1369140365), (384533403, 1827677441, 184834138); -- sql #256 create table t_s436oao0nr ( c_atq2lf4e6v int , c_vpiqmsh6 double unique , c_jb6qd70seo int , c_sd_11z double , primary key(c_atq2lf4e6v) CLUSTERED) pre_split_regions=2; -- sql #257 insert into t_s436oao0nr (c_atq2lf4e6v, c_vpiqmsh6, c_jb6qd70seo, c_sd_11z) values (-379863511, 67.65, 891984448, cast(null as double)), (-1679695693, 13.24, 666574534, 1.90), (-306677037, 4.27, 367638362, 9223372036854775809.6), (1926086568, cast(null as double), 891686579, 65534.7); -- sql #258 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-595377191, -807929150, -396859372), (1045628282, -1085696680, 259993554), (-1701076587, -1978280421, -850490751), (-2091251199, cast(null as signed), -2034015128); -- sql #259 insert into t_s436oao0nr (c_atq2lf4e6v, c_vpiqmsh6, c_jb6qd70seo, c_sd_11z) values (859176437, 6.89, -2036908123, 15.35), (-1307256453, 52.1, 477573083, 32766.1), (-1625774750, 35.56, cast(null as signed), 91.2), (77956570, 47.58, -885537991, cast(null as double)); -- sql #261 insert into t_s436oao0nr (c_atq2lf4e6v, c_vpiqmsh6, c_jb6qd70seo, c_sd_11z) values (-1964798165, cast(null as double), 1465170873, cast(null as double)), (-1334762558, 40.38, -520866277, 9223372036854775807.4), (-1723047931, 72.13, cast(cast(null as signed) as signed), 26.76), (757534711, 9223372036854775806.1, -33070823, 127.0); -- sql #264 insert into t_s436oao0nr (c_atq2lf4e6v, c_vpiqmsh6, c_jb6qd70seo, c_sd_11z) values (-969530164, 129.2, -1852995870, 31.82), (-1359414227, 26.27, -125648832, 94.16), (1881935689, 87.36, -1404810817, 18.86), (1986183199, cast(null as double), -1933709515, 4294967294.0); -- sql #265 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (253518320, -6546207, 584593358), (1365363491, 31238349, -998614091), (-1688667099, -283763199, -1935882735), (1179766794, -1403978092, -1476070113); -- sql #266 insert into t_s436oao0nr (c_atq2lf4e6v, c_vpiqmsh6, c_jb6qd70seo, c_sd_11z) values (321091809, 44.56, -637197181, 83.27), (-992173960, 18446744073709551614.9, -1523492279, 29.30), (158743688, 42.68, cast(cast(null as signed) as signed), 51.35), (-631938568, 128.2, 1003901504, 65534.2); -- sql #268 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-2091902536, 1857153778, -189066803), (1323659027, 609659047, 1280292668), (-604042081, 1583802364, 259469182), (595126736, 882549558, 1517910500); -- sql #269 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (1014843130, -511510768, 1890147221), (1486596786, 1659700098, 808928943), (-2057840453, 802889638, -1538835762), (1339091344, cast(cast(null as signed) as signed), -718542080); -- sql #271 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1095207298, 218195689, 1857608889), (-1772154482, 2122672987, -708994500), (253218456, -1248193056, 449547618), (1239843259, 113948553, -689409213); -- sql #272 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (-1665525785, -313006887, 666215765), (1091851878, -1312011365, -1784543258), (-1225844170, cast(cast(null as signed) as signed), 1693882131), (-1981436740, -1835994917, 562464433); -- sql #273 insert into t_s436oao0nr (c_atq2lf4e6v, c_vpiqmsh6, c_jb6qd70seo, c_sd_11z) values (1518698603, 30.34, 792525460, 85.58), (943769403, 21.72, 1464599069, 42.56), (703928266, 75.50, 1279231199, 128.3), (1497501678, 89.84, 197819975, 32767.6); -- sql #274 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (137858951, -642811696, -1495937376), (829663601, 1019187764, 115897645), (-2029590309, -1557864991, 359949865), (83389673, 1978641556, 1405741591); -- sql #278 insert into t_ktz (c_q22yixwl, c_kw48, c_u1) values (88990569, 1213444052, 67406092), (923366592, 1011079742, 2012768900), (-1830142258, -1683682387, -221698773), (188892375, -1063107323, -430636657); -- sql #279 alter table t_ktz add column c_k0yjq8k text; -- sql #280 create index t_og_idx_1 on t_ktz (c_q22yixwl);