1--echo # 2--echo # wl#6711:User can choose tmp table engine between MyISAM and InnoDB 3--echo # 4# In order to support innodb_limit_optimistic_insert_debug 5--source include/have_debug.inc 6# In order to make the output of explain json-format stable 7--source include/have_innodb_16k.inc 8# Contains several strange queries with GROUP BY, so: 9--source include/turn_off_only_full_group_by.inc 10# =======================initialization==================== 11SET GLOBAL innodb_large_prefix=OFF; 12create table t1(a int, b varchar(20)); 13create table t2(a int, b varchar(20)); 14insert into t1 values(1, 'a'), (2, 'b'), (3, 'c'), (3, 'c'), (4, 'c'); 15insert into t2 values(2, 'd'), (3, 'e'), (4, 'f'), (4, 'f'), (5, 'e'), 16 (6, 'g'), (7, 'h'); 17analyze table t1; 18analyze table t2; 19 20# Notice: if want mysql to use innodb tmp table, the following variable 21# settings should not be commented 22# 23set @old_internal_tmp_disk_storage_engine= @@internal_tmp_disk_storage_engine; 24set global internal_tmp_disk_storage_engine='innodb'; 25set @old_big_tables= @@big_tables; 26set big_tables= on; 27set @old_optimizer_switch= @@optimizer_switch; 28set optimizer_switch='derived_merge=off'; 29 30#========================begin============================= 31# use SQL_BUFFER_RESULT 32explain format=json select SQL_BUFFER_RESULT * from t1; 33select SQL_BUFFER_RESULT * from t1 order by 1, 2; 34 35# If order by is not simple order 36 # If not(sort_order only uses fields from head table and the head table is not left join table) 37 explain format=json select * from t1 left join t2 on t1.b = t2.b order by t1.a; 38 select * from t1 left join t2 on t1.b = t2.b order by t1.a; 39 # If sorting by a sp or udf function due to their expensive and probably non-deterministic nature. 40 drop function if exists func1; 41 delimiter |; 42 create function func1(x int) 43 returns int deterministic 44 begin 45 declare z1, z2 int; 46 set z1 = x; 47 set z2 = z1+2; 48 return z2; 49 end| 50 delimiter ;| 51 explain format=json select * from t1 order by func1(a); 52 select * from t1 order by func1(a); 53 drop function func1; 54 # order by agg --In order to make it simple, we make group by index 55 create index indx1 on t1(b); 56 explain format=json SELECt a FROM t1 group by b order by sum(a); 57 SELECt a FROM t1 group by b order by sum(a); 58 drop index indx1 on t1; 59# a select with join and sql_big_result(only can work with group by or distinct) 60 explain format=json select SQL_BIG_RESULT distinct * from t1, t2; 61 select SQL_BIG_RESULT distinct * from t1, t2 order by 1, 2, 3, 4; 62 explain format=json select SQL_BIG_RESULT t1.b from t1, t2 group by t1.b; 63 select SQL_BIG_RESULT t1.b from t1, t2 group by t1.b order by 1; 64 explain format=json select SQL_BIG_RESULT distinct t1.a from t1, t2 group by t1.b; 65 select SQL_BIG_RESULT distinct t1.a from t1, t2 group by t1.b order by 1; 66 67# a select with join and grouping that uses tmp table for grouping 68 explain format=json select t1.* from t1 inner join t2 where t1.a = t2.a group by t1.a; 69 select t1.* from t1 inner join t2 where t1.a = t2.a group by t1.a order by 1, 2; 70 71# select distinct that uses tmp table for duplicate elimination 72 explain format=json select distinct t1.a from t1, t2 where t1.b = t2.b; 73 select distinct t1.a from t1, t2 where t1.b = t2.b order by 1; 74 # remove_dup_with_hash_index 75 explain format=json select distinct a from t1 group by b,a; 76 select distinct a from t1 group by b,a order by 1; 77# remove_dup_with_compare 78 set @old_big_tables=@@big_tables; 79 set big_tables=1; 80 drop table if exists t3; 81 create table t3 like t1; 82 INSERT INTO t3 VALUES (1, '1'), (1, '1'), (2, '2'), (3, '1'), (3, '1'), (4, '4'); 83 insert into t3 select 5 + 10000 * rand(), '5' from t3; 84 insert into t3 select 5 + 10000 * rand(), '5' from t3; 85 insert into t3 select 5 + 10000 * rand(), '5' from t3; 86 insert into t3 select 5 + 10000 * rand(), '5' from t3; 87 insert into t3 select 5 + 10000 * rand(), '5' from t3; 88 insert into t3 select 5 + 10000 * rand(), '5' from t3; 89 insert into t3 select 5 + 10000 * rand(), '5' from t3; 90 insert into t3 select 5 + 10000 * rand(), '5' from t3; 91 analyze table t3; 92 set @old_sort_buffer_size = @@sort_buffer_size; 93 set @@sort_buffer_size = 32804; 94 explain format=json select distinct b from t3 group by a; 95 select distinct b from t3 group by a order by 1; 96 set @@sort_buffer_size = @old_sort_buffer_size; 97 set big_tables=@old_big_tables; 98 drop table t3; 99#special case for distinct 100 drop table if exists t3; 101 create table t3(a int, b int, c int, d char, e blob); 102 insert into t3 values(1,2,3,'4','5'); 103 analyze table t3; 104 explain format=json select distinct t3.a,e from t3, t1 order by t3.b; 105 select distinct t3.a,e from t3, t1 order by t3.b; 106 drop table t3; 107 108#union 109explain format=json select * from t1 union all select * from t2; 110select * from t1 union all select * from t2; 111# union distinct with global order by 112 # filesort 113 explain format=json select * from t1 union select * from t2 order by 1, 2; 114 select * from t1 union select * from t2 order by 1, 2; 115 116# select with a single derived table 117explain format=json select tt.* from (select * from t1) as tt; 118select tt.* from (select * from t1) as tt order by 1, 2; 119# select with mutiple derived tables 120explain format=json select * from (select b from t1) as t1, (select b from t2) as t2; 121select * from (select b from t1) as t1, (select b from t2) as t2 order by 1, 2; 122# derived table uses 'ref' scan 123drop table if exists t3; 124create table t3(a int, b int, c int, d char); 125insert into t3 values(1,2,3,'4'); 126analyze table t3; 127create index t3_indx1 on t3(a); 128explain format=json select * from t1, (select * from t3) as t where t.a =5; 129select * from t1, (select * from t3) as t where t.a =5 order by 1, 2; 130drop table t3; 131 132#materialized semi-join 133explain format=json select * from t1 where t1.a in (select a from t2) ; 134select * from t1 where t1.a in (select a from t2) order by 1, 2; 135#tmp table for semi-join weedout 136set @tmp_optimizer_switch= @@optimizer_switch; 137 138if (`select locate('materialization', @@optimizer_switch) > 0`) 139{ 140 set optimizer_switch='materialization=off'; 141} 142if (`select locate('firstmatch', @@optimizer_switch) > 0`) 143{ 144 set optimizer_switch='firstmatch=off'; 145} 146if (`select locate('loosescan', @@optimizer_switch) > 0`) 147{ 148 set optimizer_switch='loosescan=off'; 149} 150explain format=json select * from t1 where t1.a in (select a from t2) ; 151select * from t1 where t1.a in (select a from t2) order by 1, 2; 152set optimizer_switch= @tmp_optimizer_switch; 153 154#system table 155explain format=json select * from information_schema.character_sets order by 1 limit 3; 156select * from information_schema.character_sets order by 1 limit 3; 157 158#muti-update 159explain format=json update t1, t2 set t1.a = 9, t2.a = 10 where t1.b = 'a'; 160update t1, t2 set t1.a = 9, t2.a = 10 where t1.b = 'a'; 161 162#count with distinct 163explain format=json select count(distinct a) from t1; 164select count(distinct a) from t1; 165 166#group_concat 167explain format=json select b, group_concat(a) from t1; 168select b, group_concat(a) from t1 order by 1, 2; 169#blob 170drop table if exists t1; 171create table t1(a int, b blob); 172insert into t1 values(1, 'ababab'); 173insert into t1 values(2, 'cccddd'); 174insert into t1 values(2, 'cccddd'); 175insert into t1 values(3, 'eeffddd'); 176analyze table t1; 177explain format=json 178 select * from t1 left join t2 on t1.a = t2.a order by t1.b; 179select * from t1 left join t2 on t1.a = t2.a order by t1.b; 180explain format=json select a from t1 group by b; 181select a from t1 group by b order by 1; 182explain format=json select distinct b from t1; 183select distinct b from t1 order by 1; 184#unique_constraint 185drop table if exists t2; 186CREATE TABLE `t2` 187( 188 `i1` int(11) NOT NULL, 189 `i2` int(11) NOT NULL, 190 `c1` tinytext 191 ); 192insert into t2 values(10, 20, 'aa'); 193insert into t2 values(20, 30, 'aabb'); 194insert into t2 values(30, 40, 'aabbcc'); 195analyze table t2; 196explain format=json select distinct concat(c1, repeat('xx', 250)) as cc from t2; 197select distinct concat(c1, repeat('xx', 250)) as cc from t2 order by 1; 198explain format=json select concat(c1, repeat('xx', 250)) as cc from t2 group by cc; 199select concat(c1, repeat('xx', 250)) as cc from t2 group by cc order by 1; 200explain format=json select count(distinct concat(c1, repeat('xx', 250))) as cc from t2; 201select count(distinct concat(c1, repeat('xx', 250))) as cc from t2 order by 1; 202 203create table test(c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, 204 c7 int, c8 int, c9 int, c10 int, c11 int, c12 int, 205 c13 int, c14 int, c15 int, c16 int, c17 int, c18 int 206 ); 207insert into test values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 208 13, 14, 15, 16, 17, 18); 209analyze table test; 210explain format=json select distinct * from test; 211select distinct * from test; 212drop table test; 213 214#from heap to ondisk //ref wl6711_heap_to_disk.test 215 216################################################### 217#BUG: Table->read_set is not set 218# for having condition which including avg 219################################################### 220drop table if exists t1; 221create table t1 222( 223a int, b varchar(30), 224primary key(a) 225); 226insert into t1 values (1,'one'); 227insert into t1 values (2,'two'); 228insert into t1 values (3,'three'); 229insert into t1 values (4,'four'); 230set @Oporto='Oporto'; 231select sum(a) + 200 as the_sum, @Oporto as the_town from t1 232where a > 1 233group by b 234having avg(a) > 2; 235 236#BUG: row_id is too long to use unique_constraint for semi-join 237create table t0 (a int); 238insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 239drop table if exists t1; 240create table t1 ( 241 a int, 242 b int 243 ) engine=innodb; 244insert into t1 values (1,1),(1,1),(2,2); 245create table t3 ( 246 a int, 247 b int, 248 key(b), 249 pk1 char(200), pk2 char(200), pk3 char(200), 250 primary key(pk1, pk2, pk3) 251 ) engine=innodb; 252insert into t3 select a,a, a,a,a from t0; 253analyze table t1,t3; 254#Due to cost changes, materialzed scan will be preferred 255#for this query instead of dups_weedout. 256#So changing optimizer_switch. 257set @old_optimizer_switch=@@optimizer_switch; 258set optimizer_switch='materialization=off'; 259explain format=json select * from t3 where b in (select a from t1); 260select * from t3 where b in (select a from t1); 261set @@optimizer_switch=@old_optimizer_switch; 262 263#multi-update 264update t1, t3 set t3.b=10, t1.a=20; 265select * from t1 order by 1,2; 266select * from t3 order by 1,2; 267create trigger trg before update on t3 for each row set new.b=new.b+1; 268update t1, t3 set t3.b=10, t1.a=20; 269select * from t3 order by 1,2; 270drop table t0, t1, t3; 271# 272# Check unique_constraint on values causing hash collision 273create table t1(f1 text); 274insert into t1 values ('a'),('a'),('mn'); 275# test select_union 276select f1,'' from t1 union select f1,'' from t1; 277# test end_write() 278# 'if' is needed to make '' non-const 279select distinct *,if(1,'',f1) from t1; 280#test end_update() 281select count(*), f1,if(1,'',f1) from t1 group by 2,3; 282# test Aggregator_distinct:add() 283select count(distinct f1,if(1,'',f1)) from t1; 284drop table t1; 285drop table t2; 286 287--echo # 288--echo # BUG#18432569: WL6737/WL6711: DEBUG CRASH IN 289--echo # ROW_SEL_CONVERT_MYSQL_KEY_TO_INNOBASE 290--echo # 291SET @old_big_tables=@@big_tables; 292SET big_tables=on; 293SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 294CREATE TABLE N ( 295col_int_key int(11) DEFAULT NULL, 296pk int(11) NOT NULL AUTO_INCREMENT, 297col_varchar_1024_utf8_key varchar(1024) CHARACTER SET utf8 DEFAULT NULL, 298PRIMARY KEY (pk), 299KEY col_int_key (col_int_key), 300KEY col_varchar_1024_utf8_key (col_varchar_1024_utf8_key(333)) 301) ; 302 303INSERT INTO N VALUES 304(1,3,repeat('a',1000)),(0,4,'tell'),(7,6,'o'),(6,7,'g'),(8,8,'can'), 305(9,15,repeat('a',1020)),(4,16,repeat('a',1020)),(6,18,'his'),(NULL,19,'going'), 306(7,22,'mean'),(8,23,'here'); 307 308CREATE TABLE P ( 309pk int(11) NOT NULL AUTO_INCREMENT, 310col_int_key int(11) DEFAULT NULL, 311col_varchar_10_latin1 varchar(10) DEFAULT NULL, 312PRIMARY KEY (pk), 313KEY col_int_key (col_int_key) 314) ; 315 316INSERT INTO P VALUES 317(1,4,'want'),(2,3,'g'),(3,NULL,'n'),(4,1,'so'),(5,-71827456,'k'),(6,NULL,'btez 318ldxvuu'),(7,NULL,'p'),(8,5,'t'),(9,517341184,'don\'t'),(10,-1507786752,'that\'s'); 319 320SELECT 321alias1 . pk AS field3 , 322alias3 . pk AS field5 , 323MIN( DISTINCT alias2 . col_int_key ) AS field8 324FROM ( SELECT * FROM P ) AS alias1 LEFT JOIN ( SELECT * FROM N ) AS 325alias2 RIGHT JOIN ( SELECT * FROM P ) AS alias3 326ON alias2 . col_varchar_1024_utf8_key = alias3 . col_varchar_10_latin1 327ON alias1 . pk = alias3 . col_int_key 328GROUP BY field3, field5 329ORDER BY 1,2,3; 330 331DROP TABLE N,P; 332SET big_tables=@old_big_tables; 333SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 334--echo # 335--echo # BUG#18542045: WL6737/WL6711:SELECT DISTINCT @VARIABLE 336--echo # WITH ORDER BY GIVING INCORRECT RESULTS 337--echo # 338CREATE TABLE t1 ( col_int_key int(11), col_varchar_key varchar(1), KEY col_int_key (col_int_key), KEY col_varchar_key (col_varchar_key,col_int_key))/*! engine=MyISAM */; 339INSERT INTO t1 VALUES (1,'a'); 340INSERT INTO t1 VALUES (4,'c'); 341INSERT INTO t1 VALUES (9,'e'); 342INSERT INTO t1 VALUES (5,'h'); 343INSERT INTO t1 VALUES (204,'h'); 344INSERT INTO t1 VALUES (2,'i'); 345INSERT INTO t1 VALUES (5,'i'); 346INSERT INTO t1 VALUES (9,'l'); 347INSERT INTO t1 VALUES (224,'p'); 348INSERT INTO t1 VALUES (3,'q'); 349INSERT INTO t1 VALUES (0,'s'); 350INSERT INTO t1 VALUES (7,'s'); 351INSERT INTO t1 VALUES (6,'u'); 352INSERT INTO t1 VALUES (3,'v'); 353INSERT INTO t1 VALUES (7,'v'); 354INSERT INTO t1 VALUES (3,'w'); 355INSERT INTO t1 VALUES (0,'y'); 356INSERT INTO t1 VALUES (3,'y'); 357INSERT INTO t1 VALUES (5,'y'); 358INSERT INTO t1 VALUES (1,'z'); 359CREATE TABLE t2 ( col_int_key int(11), col_varchar_key varchar(1), KEY col_int_key (col_int_key), KEY col_varchar_key (col_varchar_key,col_int_key))/*! engine=MyISAM */; 360INSERT INTO t2 VALUES (4,'b'); 361INSERT INTO t2 VALUES (1,'c'); 362INSERT INTO t2 VALUES (4,'d'); 363INSERT INTO t2 VALUES (6,'d'); 364INSERT INTO t2 VALUES (9,'d'); 365INSERT INTO t2 VALUES (24,'d'); 366INSERT INTO t2 VALUES (8,'e'); 367INSERT INTO t2 VALUES (7,'g'); 368INSERT INTO t2 VALUES (0,'j'); 369INSERT INTO t2 VALUES (8,'m'); 370INSERT INTO t2 VALUES (8,'m'); 371INSERT INTO t2 VALUES (4,'p'); 372INSERT INTO t2 VALUES (1,'q'); 373INSERT INTO t2 VALUES (4,'r'); 374INSERT INTO t2 VALUES (2,'s'); 375INSERT INTO t2 VALUES (1,'t'); 376INSERT INTO t2 VALUES (8,'v'); 377INSERT INTO t2 VALUES (9,'w'); 378INSERT INTO t2 VALUES (4,'x'); 379INSERT INTO t2 VALUES (6,'y'); 380 381SELECT DISTINCT 'i' 382FROM t1 STRAIGHT_JOIN ( t2 AS table2 JOIN t2 AS table3 ON ( table3.col_varchar_key = table2.col_varchar_key )) 383ON ( table3.col_varchar_key = table2.col_varchar_key ) 384ORDER BY table3.col_varchar_key ; 385 386SELECT found_rows(); 387 388SET @var1 = 'i'; 389 390SELECT DISTINCT @var1 391FROM t1 STRAIGHT_JOIN ( t2 AS table2 JOIN t2 AS table3 ON ( table3.col_varchar_key = table2.col_varchar_key )) 392ON ( table3.col_varchar_key = table2.col_varchar_key ) 393ORDER BY table3.col_varchar_key; 394 395SELECT found_rows(); 396 397DROP TABLE t1; 398DROP TABLE t2; 399SET sql_mode = default; 400 401--echo # 402--echo # BUG#18540717: WL6737/WL6711:DISTINCT AND 403--echo # UNION DISTINCT QUERIES SHOWING RESULT MISMATCH 404--echo # 405 406--disable_warnings 407CREATE TABLE t1 (col_varchar_10_utf8_key varchar(10), 408col_varchar_10_latin1_key varchar(10), 409col_int_key int(11), 410col_varchar_1024_latin1_key varchar(1024), 411pk int(11) auto_increment, 412PRIMARY KEY (pk), 413KEY col_varchar_10_utf8_key (col_varchar_10_utf8_key), 414KEY col_varchar_10_latin1_key (col_varchar_10_latin1_key), 415KEY col_int_key (col_int_key), 416KEY col_varchar_1024_latin1_key (col_varchar_1024_latin1_key (767)))/*! engine=InnoDB */; 417INSERT INTO t1 VALUES ('VPANI','fhlsfqrskw',NULL,'no',1); 418INSERT INTO t1 VALUES ('x','or',NULL,'lsfqrskwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcu',2); 419INSERT INTO t1 VALUES ('XUPNQ','sfqrskwmxg',0,'h',3); 420INSERT INTO t1 VALUES ('k','out',1,'qrskwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgivbxrnhtdcydodqphzihacfzxuzppaxpshqqghpztmmtbwqcebmqburuddenzepxhnfnlfmycgfdeilzyrnurvphljmhsjdejcjtonftcwojbqkksoimsiaxjiivsgogwswxzsxmpcjvtvhmkupgblnvgyhfrojviuuilaghuwflvgwwxlbaboktrgtlsbnmleemfxvcsdwulizbggywpjdlutquetytfbeohpumbbatkjrvxvvslg',4); 421INSERT INTO t1 VALUES ('i','something',1309278208,'CJPYD',5); 422INSERT INTO t1 VALUES ('OIQHF','PLDJR',NULL,'kwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhyt',6); 423INSERT INTO t1 VALUES ('ZIGQI','wmxgptnmvq',-1216937984,'xgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxi',7); 424INSERT INTO t1 VALUES ('gptnmvqpuf','UMZNK',-1198915584,'tnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgivbxrnhtdcydodqphzihacfzxuzppaxpshqqghpztmmtbwqcebmqburuddenzepxhnfnlfmycgfdeilzyrnurvphljmhsjdejcjt',8); 425INSERT INTO t1 VALUES ('GMKDJ','mvqpufippf',NULL,'w',9); 426INSERT INTO t1 VALUES ('okay','t',662765568,'to',10); 427INSERT INTO t1 VALUES ('pufippfjsw','g',0,'AFNKO',11); 428INSERT INTO t1 VALUES ('QXCYP','you\'re',4,'KCMVA',12); 429INSERT INTO t1 VALUES ('okay','DTEDL',63635456,'LJTAI',13); 430INSERT INTO t1 VALUES ('XOPQC','PCSAX',1,'PWVIZ',14); 431INSERT INTO t1 VALUES ('or','ADLAS',747241472,'r',15); 432INSERT INTO t1 VALUES ('j','vzbtnvzocn',NULL,'m',16); 433INSERT INTO t1 VALUES ('x','SRJST',6,'up',17); 434INSERT INTO t1 VALUES ('m','been',NULL,'tnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzg',18); 435INSERT INTO t1 VALUES ('you','MSKTD',-1543307264,'is',19); 436INSERT INTO t1 VALUES ('JGKZD','zocndndyym',NULL,'IYVZN',20); 437INSERT INTO t1 VALUES ('u','ocndndyymy',-488439808,'v',21); 438INSERT INTO t1 VALUES ('v','and',NULL,'OMAKY',22); 439INSERT INTO t1 VALUES ('from','yymyjuhfnt',2002321408,'e',23); 440INSERT INTO t1 VALUES ('it\'s','yjuhfntqer',NULL,'come',24); 441INSERT INTO t1 VALUES ('a','hfntqersfs',53542912,'FIHNG',25); 442INSERT INTO t1 VALUES ('ntqersfsyq','tell',7,'qersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqr',26); 443INSERT INTO t1 VALUES ('ersfsyqfdq','x',3,'TLKCK',27); 444INSERT INTO t1 VALUES ('w','fsyqfdqdln',NULL,'qfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasn',28); 445INSERT INTO t1 VALUES ('fdqdlnnayt','l',9,'SKRVI',29); 446INSERT INTO t1 VALUES ('RSQKC','I\'ll',5,'RIYFY',30); 447INSERT INTO t1 VALUES ('aytyyybsea','PPCCF',NULL,'ytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgiv',31); 448INSERT INTO t1 VALUES ('ORAGP','l',NULL,'AAANT',32); 449INSERT INTO t1 VALUES ('she','RFZSD',8,'WFINT',33); 450INSERT INTO t1 VALUES ('h','UASMF',-1822425088,'get',34); 451INSERT INTO t1 VALUES ('yybseabbrr','ZZJHQ',NULL,'a',35); 452INSERT INTO t1 VALUES ('her','seabbrrfgj',1366753280,'going',36); 453INSERT INTO t1 VALUES ('you\'re','eabbrrfgjl',NULL,'good',37); 454INSERT INTO t1 VALUES ('d','with',-441319424,'a',38); 455INSERT INTO t1 VALUES ('brrfgjltjk','rrfgjltjkh',NULL,'my',39); 456INSERT INTO t1 VALUES ('jltjkhakde','UQAIL',312999936,'DAFWP',40); 457INSERT INTO t1 VALUES ('ltjkhakdez','tjkhakdezp',129892352,'e',41); 458INSERT INTO t1 VALUES ('did','can\'t',6,'akdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgivbxrnhtdcydodqphzihacfzxuzppaxpshqqghpztmmtbwqcebmqburuddenzepxhnfnlfmycgfdeilzyrnurvphljmhsjdejcjtonftcwojb',42); 459INSERT INTO t1 VALUES ('him','there',-922222592,'k',43); 460INSERT INTO t1 VALUES ('was','is',2,'pelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgivbxrnhtdcydodqphzihacfzxuzp',44); 461INSERT INTO t1 VALUES ('q','WDPLG',-1286144000,'QCWSP',45); 462INSERT INTO t1 VALUES ('elkaqycfzn','YUUZH',250347520,'kaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezf',46); 463INSERT INTO t1 VALUES ('IHSMI','qycfznlnhk',2,'fznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzker',47); 464INSERT INTO t1 VALUES ('for','what',NULL,'is',48); 465INSERT INTO t1 VALUES ('znlnhkddyu','nlnhkddyux',NULL,'lnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvfici',49); 466INSERT INTO t1 VALUES ('d','FDBPU',-726204416,'a',50); 467INSERT INTO t1 VALUES ('know','FCZRO',5,'r',51); 468INSERT INTO t1 VALUES ('d','dyuxbdybmb',NULL,'p',52); 469INSERT INTO t1 VALUES ('could','OWEYU',NULL,'xbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgivbxrnhtdcydodqphzihacfzxuzppaxpshqqghpztmmtbwqcebmqburuddenzepxhnfnlfmycgfdeilzyrnurvphljmhsjdejcjtonftcwojbqkksoimsiaxjiivsgogwswxzsxmpcjvtvhmkupgblnvgyhfrojviuuilaghuwflvgwwxlbaboktrgtlsbnmleemfxvcsdwulizbggywpjdlutquetytfbeohpumbbatkjrvxvvslgkvonz',53); 470INSERT INTO t1 VALUES ('when','really',1748828160,'i',54); 471INSERT INTO t1 VALUES ('n','BXWOW',NULL,'EXDPY',55); 472INSERT INTO t1 VALUES ('can','w',5,'CUPBP',56); 473INSERT INTO t1 VALUES ('w','h',NULL,'PJMRU',57); 474INSERT INTO t1 VALUES ('y','t',4,'BQGLF',58); 475INSERT INTO t1 VALUES ('he\'s','ESKUI',NULL,'pmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxq',59); 476INSERT INTO t1 VALUES ('NUMTW','right',1108148224,'had',60); 477INSERT INTO t1 VALUES ('t','q',NULL,'g',61); 478INSERT INTO t1 VALUES ('amnnhugtii','e',NULL,'n',62); 479INSERT INTO t1 VALUES ('UTPGW','nnhugtiirh',8,'your',63); 480INSERT INTO t1 VALUES ('f','ALMKN',6,'s',64); 481INSERT INTO t1 VALUES ('gtiirhldcn','OMYWP',NULL,'can',65); 482INSERT INTO t1 VALUES ('iirhldcncs','irhldcncsu',-1262747648,'rhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckders',66); 483INSERT INTO t1 VALUES ('DSGUR','RTPKW',-1477967872,'ldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgivbxrnhtdcydodqphzihacfzxuzppaxpshqqghpztmmtbwqcebmqburuddenzepxhnfnlfmycgfdeilzyrnurvphljmhsjdejcjtonftcwojbqkksoimsiaxjiivsgogwswxzsxmpcjvtvhmkupgblnvgyhfrojviuuilaghuwflvgwwxlbaboktrgtlsbnmleemfxvcsdwulizbggywpjdlutquetytfbeohpumbbatkjrvxvvslgkvonzzrzteofjypextjfqqephtuywufiuuanklyghkrehibjitgbnhltciuszfiftxqdzjgulxdgfabupcsuexymxpvlxbutpls',67); 484INSERT INTO t1 VALUES ('dcncsuhynr','OUXZT',NULL,'no',68); 485INSERT INTO t1 VALUES ('could','if',NULL,'ncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzg',69); 486INSERT INTO t1 VALUES ('u','k',2,'suhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpx',70); 487INSERT INTO t1 VALUES ('all','are',-1586626560,'WGOKF',71); 488INSERT INTO t1 VALUES ('for','UBHHV',-959578112,'NCUGL',72); 489INSERT INTO t1 VALUES ('LJCIT','UVOAJ',NULL,'c',73); 490INSERT INTO t1 VALUES ('just','FGLLB',NULL,'b',74); 491INSERT INTO t1 VALUES ('not','they',1258029056,'BGJKE',75); 492INSERT INTO t1 VALUES ('DJFLP','JTQYF',-982384640,'it',76); 493INSERT INTO t1 VALUES ('were','OUKIQ',1,'FTSLX',77); 494INSERT INTO t1 VALUES ('who','icieitkbhf',2,'some',78); 495INSERT INTO t1 VALUES ('cieitkbhfo','ieitkbhfot',3,'q',79); 496INSERT INTO t1 VALUES ('d','oh',NULL,'IXASL',80); 497INSERT INTO t1 VALUES ('ZVPHZ','one',NULL,'your',81); 498INSERT INTO t1 VALUES ('JLKVG','kbhfotgbxg',488308736,'bhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdiei',82); 499INSERT INTO t1 VALUES ('LDPIN','what',1641086976,'UPYHB',83); 500INSERT INTO t1 VALUES ('k','o',25952256,'gbxgnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbu',84); 501INSERT INTO t1 VALUES ('hey','TXSJD',361758720,'been',85); 502INSERT INTO t1 VALUES ('xgnuyypbbp','x',4,'gnuyypbbpmclmxmnujdecohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgivbxrnhtdcydodqphzihacfzxuzppaxpshqqghpztmmtbwqcebmqburuddenzepxhnfnlfmycgfdeilzyrnurvphljmhsjdejcjtonftcwojbqkksoimsiaxjiivsgogwswxzsxmpcjvtvhmkupgblnvgyhfrojviuuilaghuwflvgwwxlbaboktrgtlsbnmleemfxvcsdwulizbggywpjdlutquetytfbeohpumbbatkjrvxvvslgkvonzzrzteofjypextjfqqephtuywufiuuanklyghkrehibjitgbnhltciuszfiftxqdzjgulxdgfabupcsuexymxpvlxbutplszcgzbpoomzheecewlmxcojkutqvjkbjwhoziafrmbfryznogbmiaqdnxgmwpm',86); 503INSERT INTO t1 VALUES ('XSKDR','CVEQA',NULL,'w',87); 504INSERT INTO t1 VALUES ('n','m',NULL,'had',88); 505INSERT INTO t1 VALUES ('really','how',NULL,'v',89); 506INSERT INTO t1 VALUES ('pbbpmclmxm','j',NULL,'c',90); 507INSERT INTO t1 VALUES ('say','IUPWT',NULL,'HYYXB',91); 508INSERT INTO t1 VALUES ('if','r',NULL,'PIPQP',92); 509INSERT INTO t1 VALUES ('up','w',-1128988672,'some',93); 510INSERT INTO t1 VALUES ('lmxmnujdec','xmnujdecoh',NULL,'did',94); 511INSERT INTO t1 VALUES ('p','you\'re',9,'CUNBE',95); 512INSERT INTO t1 VALUES ('ujdecohzvg','then',6,'cohzvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxoaejgtegzgbzuktuecedpoztsvrqwjkbavfmvkoyasnnyfhfnexgifgbubiwfmijaskpmekaxdieiubnvfepflkpnmoqroxehhkhtvkjcuvstuufixrwmdptkmtjyhmgutwjfckdersujhfhxahpkloqgubkwvkhijboxnnztgjjtvbxqczomrnkfrkeicfynbpxkileklntghbckaqvjwqdegqbrcbhlbnasnqtauzhgivbxrnhtdcydodqphzihacfzxuzppaxpshqqghpztmmtbwqcebmqburuddenzepxhnfnlfmycgfdeilzyrnurvphljmhsjdejcjtonftcwojbqkksoimsiaxjiivsgogwswxzsxmpcjvtvhmkupgblnvgyhfrojviuuilaghuwf',96); 513INSERT INTO t1 VALUES ('v','o',-46530560,'zvghxenmiqnldebgypjleqqrhvnzkertpohjvhcxhjgggmamgyauappsohijbklnmomfvtylahsatyeiodhbunlbbgqwayvaomtxkpvxdyozhioaxilvxhnjkmvgnrrugibyodirihwmohmvmhytcqphbqbcbjuxfenmghuigxsxtefiogkhiuijfajsuaympcmtezmxfezfwaaelkwdtlynyoyhwptdqffjihimhurbfxuagggpjuyyzclxcuuymzjbsiiwnxagdhzgrbjgkhtxlkjvzskzkybksdmzqajmsxo',97); 514INSERT INTO t1 VALUES ('d','mean',NULL,'one',98); 515INSERT INTO t1 VALUES ('VYJFE','LQAHF',NULL,'with',99); 516INSERT INTO t1 VALUES ('h','CSIEW',4,'z',100); 517SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 518CREATE TABLE E ( 519col_datetime datetime, 520col_varchar_1024_utf8 varchar(1024) CHARACTER SET utf8, 521col_varchar_1024_latin1_key varchar(1024) CHARACTER SET latin1, 522col_varchar_1024_utf8_key varchar(1024) CHARACTER SET utf8, 523col_varchar_10_latin1 varchar(10) CHARACTER SET latin1, 524pk integer auto_increment, 525col_varchar_10_latin1_key varchar(10) CHARACTER SET latin1, 526col_date_key date, 527col_int_key int, 528col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8, 529col_varchar_10_utf8 varchar(10) CHARACTER SET utf8, 530col_int int, 531col_datetime_key datetime, 532col_date date, 533col_varchar_1024_latin1 varchar(1024) CHARACTER SET latin1, 534/*Indices*/ 535key (col_varchar_1024_latin1_key ), 536key (col_varchar_1024_utf8_key ), 537primary key (pk), 538key (col_varchar_10_latin1_key ), 539key (col_date_key ), 540key (col_int_key ), 541key (col_varchar_10_utf8_key ), 542key (col_datetime_key )) ENGINE=myisam; 543 544CREATE OR REPLACE VIEW view_e AS SELECT * FROM E; 545 546INSERT /*! IGNORE */ INTO E VALUES ('01:41:57.028251', 'AZTSD', 'CTOWO', 'vwudihwrhagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbj', 'she', NULL, 'wudihwrhagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoq', '2002', 4, 'a', 'udihwrhagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxe', 1248788480, '2000-09-14 16:05:58.011397', '20060324201916.058151', 'dihwrhagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjx') , ('2008', 'like', 'i', 'j', 'YGSUR', NULL, 'ihwrhagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakf', '2007-02-09', 665124864, 'e', 'how', 9, NULL, '2002-01-01 11:24:35.034815', 'hwrhagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojin') , ('2008', 'd', 'the', 'wrhagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouth', 'g', NULL, 'rhagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwt', '10:06:36.028525', 1327169536, 'a', 'ZMLOK', 1, '02:03:19.003912', '2008-05-28 03:41:19.063907', 'hagghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahm') , ('2007-08-04', 'FHVLF', 'see', 'q', 'can', NULL, 'me', '2003-05-23', 557776896, 'FTXMB', 'agghnfsjivypqlxfopj', NULL, NULL, '20:23:24.057760', 'PPNGL') , (NULL, 'gghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqv', 'd', 'ghnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdw', 'l', NULL, 'say', '2009-12-07', NULL, 'CZZLN', 'c', 1871904768, '2003-03-25', '2006-08-08 12:45:22.031446', 'a') , (NULL, 'I', 'hnfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhi', 'r', 'w', NULL, 'say', '2008', NULL, 'nfsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtni', 'BXODI', 59375616, '15:21:03.064839', NULL, 'v') , ('2009-05-01', 'MQSDX', 'look', 'so', 'is', NULL, 'something', '2001-05-27', -145293312, 'on', 'fsjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypq', NULL, '2005-05-08', '2008-05-02', 'k') , (NULL, 'do', 'the', 'p', 'e', NULL, 'z', '2004-11-27', NULL, 'MUTTT', 'ILFHK', 8, '2008-10-27', '2006-12-05', 'want') , ('00:39:54.026500', 'c', 'sjivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkce', 'u', 'jivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibnia', NULL, 'o', '20:10:45.007165', NULL, 'YWLDS', 'ivypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtn', 1188823040, '08:14:32.025363', NULL, 'the') , ('2008-03-13 04:28:25.065216', 'NCIIY', 'vypqlxfopjvkegvqzbulawucdduxvslfzfaysgqvolxnfzpoaqmvzwtlfjttprznxyzxgugyqauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhso', 'n', 'come', NULL, 'back', NULL, 476905472, 'all', 'that', 8, '17:35:35.043707', '20031126235244.059587', 'NSOJS'); 547 548CREATE TABLE H ( 549col_varchar_1024_utf8 varchar(1024) CHARACTER SET utf8, 550col_date date, 551col_int int, 552col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8, 553col_datetime datetime, 554col_datetime_key datetime, 555col_varchar_1024_latin1_key varchar(1024) CHARACTER SET latin1, 556col_varchar_1024_latin1 varchar(1024) CHARACTER SET latin1, 557col_date_key date, 558col_varchar_1024_utf8_key varchar(1024) CHARACTER SET utf8, 559col_varchar_10_utf8 varchar(10) CHARACTER SET utf8, 560col_varchar_10_latin1 varchar(10) CHARACTER SET latin1, 561col_int_key int, 562col_varchar_10_latin1_key varchar(10) CHARACTER SET latin1, 563pk integer auto_increment, 564/*Indices*/ 565key (col_varchar_10_utf8_key ), 566key (col_datetime_key ), 567key (col_varchar_1024_latin1_key ), 568key (col_date_key ), 569key (col_varchar_1024_utf8_key ), 570key (col_int_key ), 571key (col_varchar_10_latin1_key ), 572primary key (pk)) ENGINE=innodb; 573SET sql_mode = default; 574CREATE OR REPLACE VIEW view_h AS SELECT * FROM H; 575 576INSERT /*! IGNORE */ INTO H VALUES ('PWKPA', '2003', -2071461888, 'ZMAPA', NULL, '2007-06-01', 'j', 'qauhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsf', '2003', 'v', 'can\'t', 'auhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqv', 9, 'for', NULL) , ('IYAMG', '2002-06-24', 3, 'HVCLY', '20051101101903.027848', '2007-11-13', 'i', 'uhibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhlsfqrskwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuh', '2006', 'JNNLF', 'hibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhlsfqrskwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseab', 'ibniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjun', NULL, 'right', NULL) , ('PIKTS', '20040703134305.015635', -1793392640, 'o', '10:13:42.038677', '08:06:05.040877', 'IVHVM', 'bniamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunp', '20050426124618.033428', 'BQLRU', 'niamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhlsfqr', 'mean', 488243200, 'I\'m', NULL) , ('iamhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhay', NULL, NULL, 'u', '10:38:19.045782', '2002', 'j', 'WCTUZ', '20080912005520.009494', 'amhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmn', 'all', 'mhtmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroy', -695730176, 'that', NULL) , ('htmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfw', '15:58:38.020659', 5, 'just', NULL, NULL, 'got', 'tmnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcip', '11:09:00.032967', 'mnfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiez', 'n', 'UIEZD', -793837568, 'JQCCK', NULL) , ('c', NULL, 2, 'OOCDS', '2004-10-14 09:59:29.025521', NULL, 'nfxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfk', 'this', '2000-04-01', 'it', 'this', 'or', 1732050944, 'ZBICQ', NULL) , ('know', '04:37:06.005578', 8, 'b', '2005-07-06 04:13:32.018141', '00:54:10.040062', 'i', 'fxfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavo', NULL, 'r', 'KARHF', 'p', 319291392, 'xfmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfz', NULL) , ('IVUJL', '2000-11-25 23:28:42.038112', 898301952, 'fmxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkml', NULL, '2002', 'NJUNY', 'VJCPX', '2008', 'o', 'PCIRX', 'w', -1041825792, 'v', NULL) , ('are', '2003-12-09 01:30:03.025234', -1310785536, 'b', '2005-04-05 07:49:11.008399', '20090315000439.040497', 'UKBQS', 'z', '2002-03-22 12:26:57.006275', 'look', 'come', 'for', 2490368, 'ULYXS', NULL) , ('i', NULL, -730923008, 'ZFKUP', '20040807230832.006451', '20051210104822.018844', 'mxslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxe', 'f', '2000-12-19', 'xslmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacg', 'y', 'EUETM', 3, 'HNFFZ', NULL) , ('ESQVC', '2005-08-10 20:19:43.000027', 5, 'NGYTB', NULL, NULL, 'd', 'd', '13:27:32.062794', 'slmxvfonsluayrofwafllupikoapp', 't', 'lmxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhl', 795148288, 'XMOZQ', NULL) , ('really', '2001-05-22', 8, 'mxvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvq', '20080504174501.046646', '2003-07-26 16:59:01.062296', 'n', 'how', '20070508055627.026593', 'RRFNA', 'in', 'xvfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjp', 132251648, 'get', NULL) , ('v', '19:53:48.009433', NULL, 'vfonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsus', '2008-08-08', '2001', 'JQUQZ', 'fonsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpg', '2006-05-05', 'x', 'for', 'WJXOZ', 131596288, 'want', NULL) , ('mean', NULL, 564068352, 'onsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhlsfqrskwmxgptnmvqpufippfjswvzb', '2007-09-04 06:46:51.041078', '11:50:05.047592', 'LITLN', 'd', '01:29:28.040385', 'UMOLK', 'l', 'they', 1351614464, 'TJEWO', NULL) , ('nsluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhlsfqrskwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpe', NULL, 3, 'did', '01:26:29.025020', '09:49:47.038765', 'VNUAV', 'sluayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobds', '2001-04-14', 'CIOAI', 'him', 'luayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxb', 7, 'get', NULL) , ('him', '20051204062403.046858', 7, 'his', '2003-10-28', '20030112051727.032070', 'MNJBY', 'uayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdq', NULL, 'o', 'WUELI', 'ayrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuy', 3, 'yrofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlis', NULL) , ('MNAVL', '2008-03-06 19:35:21.003444', 6, 'rofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtr', '20000826213619.059974', '2008-01-09', 'ofwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgp', 'they', '2001-01-13 13:17:36.051819', 'j', 'fwafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroax', 't', -1574109184, 'MYHDH', NULL) , ('NLQQN', '2007', 1663107072, 'RLVYW', '20060608121825.039733', '2009-12-14', 'have', 'wafllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxb', '2006-11-01', 'afllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthz', 'IZLCS', 'fllupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuh', NULL, 'llupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgp', NULL) , ('all', '2004-10-20 06:15:14.000148', 1531052032, 'lupikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojx', '2008-07-04', '20051221140927.040451', 'HQHLZ', 'upikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhlsfqrskwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyuxbdybmbilkqrpmamnnhugtiirhldcncsuhynrejvficieitkbhfotgbxgnuyypbbpmclmxmnujdecohzvghxenmiq', '23:21:16.032958', 'x', 'who', 'DUCAC', -1769340928, 'RCCAO', NULL) , ('LLRCI', '2001', 1, 'JAFVM', '20081001131456.014526', '2005-08-01 02:35:59.003461', 'XDKFW', 'pikoappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhlsfqrskwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnh', '20000112134749.024329', 'ikoappgllpkbyrdtndwiuyqhqwojelnqhxb', 'JWYNU', 'koappgllpkbyrdtndwiuyqhqwojelnqhxbjofuiriycjpvagsuslqucvesvyryyjweexpijmgvjtgoezsrmunpdoqtzxndnpykhcpjcdwggiezgodearmshmwmkkrfjzusjavotnutitpavotqbpzwwjvxeortxgyqkcgmdtlmnbfcheiknzwgpepqxrzxljangusrqbmtlgtaluztuozrnvqqjeqqrblaolnyqgeovcddebcxpdmfddubuyyfjxbxdgrqejaewcldqyxhwkyragqvpahruvgmjupbfzyhfqzdoyoqjsfaucwloqdfwcjrimtetszkzwjcfuhgwctcrhucgtzdnzgpuqriybmwzfkhmedgfnomhbvpfodqdjdxqzsjkzrlraecuxepzamhxwnbczfxwjqdvacgoobmscvejweiytakwruoodqedvzipbhxncdqhayqmlisykbwqdezkrmggxhdilrmxnghjuxecpgroesfpetnuyxqumqhxhwdwfxsclqithgcojxmunpdyvdlvygsaetufkcexebfwmhsobdsjhdymqwmjsznpygumzsalkmlojinuxoakfrkmsctseenuwdtroyrqoocpmpgsouthzzugewroaxcipvpdxmdpgpjdcpypqcdeawvhyzrahmbdjungbhpvtozzstmbweqmzshvpcbyawbtyiwfamoecfbfkfzuhuvrdxxewbmmwvpxrhtnigmoxbabdhfpkdifnjmfshrssbwxsdrtmugchxgaehhsfrhfjfqkmsvgowahrffhlsfqrskwmxgptnmvqpufippfjswvzbtnvzocndndyymyjuhfntqersfsyqfdqdlnnaytyyybseabbrrfgjltjkhakdezpelkaqycfznlnhkddyux', -337510400, 'will', NULL); 577 578(SELECT table3.col_varchar_10_latin1_key, 579table1.col_varchar_1024_latin1_key, 580table1.col_varchar_1024_latin1_key 581FROM view_e AS table1 582LEFT JOIN view_h AS table2 583LEFT JOIN t1 AS table3 ON table2.col_int_key = table3.pk ON table1.col_varchar_1024_latin1_key = table3.col_varchar_10_utf8_key ) 584UNION DISTINCT ( 585SELECT table3.col_varchar_10_latin1_key, 586table1.col_varchar_1024_latin1_key, 587table1.col_varchar_1024_latin1_key 588FROM view_e AS table1 589LEFT JOIN view_h AS table2 590LEFT JOIN t1 AS table3 ON table2.col_int_key = table3.pk ON table1.col_varchar_1024_latin1_key = table3.col_varchar_10_utf8_key ); 591 592SELECT found_rows(); 593 594DROP VIEW view_e,view_h; 595DROP TABLE t1,E,H; 596--enable_warnings 597 598--echo # 599--echo # BUG#18542045: WL6737/WL6711:SELECT DISTINCT @VARIABLE 600--echo # WITH ORDER BY GIVING INCORRECT RESULTS 601--echo # 602SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 603CREATE TABLE t(a BLOB, b INT); 604INSERT INTO t VALUES('1',3); 605INSERT INTO t VALUES('1',2); 606SELECT DISTINCT t.a FROM t t, t t1 ORDER BY SQRT(t.b); 607DROP TABLE t; 608SET sql_mode = default; 609 610--echo # 611--echo # BUG#18921514: WL6711: CRASH IN THD_TO_INNODB_SESSION 612--echo # AT HANDLER/HA_INNODB.CC 613--echo # 614--disable_warnings 615CREATE TABLE C ( 616 pk INTEGER AUTO_INCREMENT, 617 col_int_nokey INTEGER NOT NULL, 618 col_int_key INTEGER NOT NULL, 619 620 col_date_key DATE NOT NULL, 621 col_date_nokey DATE NOT NULL, 622 623 col_time_key TIME NOT NULL, 624 col_time_nokey TIME NOT NULL, 625 626 col_datetime_key DATETIME NOT NULL, 627 col_datetime_nokey DATETIME NOT NULL, 628 629 col_varchar_key VARCHAR(1) NOT NULL, 630 col_varchar_nokey VARCHAR(1) NOT NULL, 631 632 PRIMARY KEY (pk), 633 KEY (col_int_key), 634 KEY (col_date_key), 635 KEY (col_time_key), 636 KEY (col_datetime_key), 637 KEY (col_varchar_key, col_int_key) 638 ); 639 640INSERT /*! IGNORE */ INTO C ( 641 col_int_key, col_int_nokey, 642 col_date_key, col_date_nokey, 643 col_time_key, col_time_nokey, 644 col_datetime_key, col_datetime_nokey, 645 col_varchar_key, col_varchar_nokey 646 ) 647VALUES (1, 3, '2009-12-01', '2009-12-01', 648 '00:21:38.058143', '00:21:38.058143', '2007-05-28 00:00:00', '2007-05-28 649 00:00:00', 'c', 'c'), 650 (8, 5, '2004-12-17', '2004-12-17', '04:08:02.046897', 651 '04:08:02.046897', '2009-07-25 09:21:20.064099', '2009-07-25 652 09:21:20.064099', 'm', 'm'), 653 (9, 3, '2000-03-14', '2000-03-14', 654 '16:25:11.040240', '16:25:11.040240', '2002-01-16 00:00:00', '2002-01-16 655 00:00:00', 'd', 'd'), 656 (24, 246, '2000-10-08', '2000-10-08', '10:14:58.018534', 657 '10:14:58.018534', '2006-10-12 04:32:53.031976', '2006-10-12 658 04:32:53.031976', 'd', 'd'), 659 (6, 2, '2006-05-25', '2006-05-25', 660 '19:47:59.011283', '19:47:59.011283', '2001-02-15 03:08:38.035426', 661 '2001-02-15 03:08:38.035426', 'y', 'y'), 662 (1, 9, '2008-01-23', '2008-01-23', 663 '11:14:24.032949', '11:14:24.032949', '2004-10-02 20:31:15.022553', 664 '2004-10-02 20:31:15.022553', 't', 't'), 665 (6, 3, '2007-06-18', '2007-06-18', 666 NULL, NULL, '2002-08-20 22:48:00.035785', '2002-08-20 22:48:00.035785', 'd', 667 'd'); 668SELECT DISTINCT 669table2 . `col_time_key` AS field1 , 670table1 . `col_datetime_key` AS field2 , 671table1 . `col_datetime_key` AS field3 672FROM ( C AS table1 STRAIGHT_JOIN ( ( C AS table2 INNER JOIN C AS table3 ON (( 673table3 . `pk` != table2 . `col_int_nokey` ) 674AND ( table3 . `pk` = table2 . `col_int_key` ) ) ) ) ON (( table3 .`pk` >= 675table2 . `col_int_key` ) 676AND (table3 .`pk` <> table2 . `pk` ) ) ) 677ORDER BY table1 . `col_datetime_key` , field1, field2, field3; 678 679DROP TABLE C; 680--enable_warnings 681 682--echo # 683--echo # BUG#18956748: WL6711: CRASH AT MY_RAW_FREE IN MYSYS/MY_MALLOC.C 684--echo # 685CREATE TABLE C ( 686 pk int(11) NOT NULL AUTO_INCREMENT, 687 col_int_nokey int(11) DEFAULT NULL, 688 col_int_key int(11) DEFAULT NULL, 689 col_date_key date DEFAULT NULL, 690 col_date_nokey date DEFAULT NULL, 691 col_time_key time DEFAULT NULL, 692 col_time_nokey time DEFAULT NULL, 693 col_datetime_key datetime DEFAULT NULL, 694 col_datetime_nokey datetime DEFAULT NULL, 695 col_varchar_key varchar(1) DEFAULT NULL, 696 col_varchar_nokey varchar(1) DEFAULT NULL, 697 PRIMARY KEY (pk), 698 KEY col_int_key (col_int_key), 699 KEY col_date_key (col_date_key), 700 KEY col_time_key (col_time_key), 701 KEY col_datetime_key (col_datetime_key), 702 KEY col_varchar_key (col_varchar_key,col_int_key) 703 ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; 704 705INSERT INTO C VALUES 706(1,NULL,7,'2004-04-09','2004-04-09','14:03:03','14:03:03','2001-11-28 707 00:50:27','2001-11-28 00:50:27','c','c'); 708SELECT DISTINCT 709alias1 . col_datetime_key AS field1 , 710alias1 . col_time_key AS field2 , 711alias1 . col_int_nokey AS field3 , 712alias1 . col_date_key AS field4 , 713alias2 . col_int_key AS field5 , 714alias2 . col_time_key AS field6 , 715alias2 . col_varchar_key AS field7 , 716alias1 . col_time_key AS field8 , 717alias1 . col_varchar_nokey AS field9 , 718alias1 . col_date_key AS field10 , 719alias1 . col_varchar_key AS field11 , 720alias1 . col_datetime_key AS field12 , 721alias1 . col_date_key AS field13 , 722alias1 . col_date_key AS field14 , 723alias1 . col_time_key AS field15 , 724alias2 . col_date_key AS field16 , 725alias2 . col_int_key AS field17 , 726alias1 . col_datetime_key AS field18 , 727alias2 . col_int_key AS field19 , 728alias1 . col_varchar_key AS field20 , 729alias1 . col_varchar_key AS field21 , 730alias1 . col_int_key AS field22 , 731alias1 . col_time_key AS field23 , 732alias1 . col_time_key AS field24 , 733alias1 . col_datetime_key AS field25 , 734alias1 . col_int_nokey AS field26 , 735alias1 . col_int_key AS field27 , 736alias1 . col_varchar_key AS field28 , 737alias2 . col_time_key AS field29 , 738alias1 . col_varchar_key AS field30 , 739alias1 . col_int_key AS field31 , 740alias1 . col_int_nokey AS field32 741FROM ( C AS alias1, C AS alias2); 742DROP TABLE C; 743 744--echo # 745--echo # BUG#18999867: WL6711::RESULT MISMATCH WHEN USING 746--echo # INNODB AS TMP ENGINE FOR SUBQUERY 747--echo # 748CREATE TABLE C ( 749 col_int_key int(11) DEFAULT NULL, 750 pk int(11) NOT NULL AUTO_INCREMENT, 751 col_varchar_16_latin1_key varchar(16) DEFAULT NULL, 752 col_int int(11) DEFAULT NULL, 753 col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8 DEFAULT NULL, 754 col_varchar_10_latin1_key varchar(10) DEFAULT NULL, 755 col_varchar_10_latin1 varchar(10) DEFAULT NULL, 756 col_varchar_16_latin1 varchar(16) DEFAULT NULL, 757 col_varchar_16_utf8_key varchar(16) CHARACTER SET utf8 DEFAULT NULL, 758 col_varchar_16_utf8 varchar(16) CHARACTER SET utf8 DEFAULT NULL, 759 col_varchar_10_utf8 varchar(10) CHARACTER SET utf8 DEFAULT NULL, 760 PRIMARY KEY (pk), 761 KEY col_int_key (col_int_key), 762 KEY col_varchar_16_latin1_key (col_varchar_16_latin1_key), 763 KEY col_varchar_10_utf8_key (col_varchar_10_utf8_key), 764 KEY col_varchar_10_latin1_key (col_varchar_10_latin1_key), 765 KEY col_varchar_16_utf8_key (col_varchar_16_utf8_key) 766 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; 767 768INSERT INTO C VALUES 769(8,1,'o',6,'qlbynryfw','from','w','lby','bynry','ynryfwcfedjhz','I'), 770(6,2,'nry',127008768,'q','ryfw','p','h','b','have','i'), 771(7,3,'he\'s',9,'his','yfwcfedjhz','go','q','m','me','r'), 772(4,4,'fwc',0,'w','t','wcfedjh','w','c','o','f'); 773 774CREATE TABLE D ( 775 pk int(11) NOT NULL AUTO_INCREMENT, 776 col_varchar_16_utf8 varchar(16) CHARACTER SET utf8 DEFAULT NULL, 777 col_varchar_10_utf8 varchar(10) CHARACTER SET utf8 DEFAULT NULL, 778 col_varchar_10_latin1_key varchar(10) DEFAULT NULL, 779 col_varchar_10_latin1 varchar(10) DEFAULT NULL, 780 col_varchar_16_utf8_key varchar(16) CHARACTER SET utf8 DEFAULT NULL, 781 col_int_key int(11) DEFAULT NULL, 782 col_varchar_16_latin1 varchar(16) DEFAULT NULL, 783 col_varchar_16_latin1_key varchar(16) DEFAULT NULL, 784 col_varchar_10_utf8_key varchar(10) CHARACTER SET utf8 DEFAULT NULL, 785 col_int int(11) DEFAULT NULL, 786 PRIMARY KEY (pk), 787 KEY col_varchar_10_latin1_key (col_varchar_10_latin1_key), 788 KEY col_varchar_16_utf8_key (col_varchar_16_utf8_key), 789 KEY col_int_key (col_int_key), 790 KEY col_varchar_16_latin1_key (col_varchar_16_latin1_key), 791 KEY col_varchar_10_utf8_key (col_varchar_10_utf8_key) 792 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; 793 794INSERT INTO D VALUES 795(1,'l','it\'s','o','you\'re','f',0,'they','with','this',1); 796 797SELECT 798COUNT(DISTINCT alias2.`col_int_key`) 799 FROM C AS alias1 , D AS alias2 800 WHERE alias1.`col_int_key` = 47; 801 802DROP TABLE C,D; 803 804--disable_warnings 805CREATE TABLE B ( 806 pk int(11) NOT NULL AUTO_INCREMENT, 807 col_int_nokey int(11) NOT NULL, 808 col_int_key int(11) NOT NULL, 809 col_date_key date NOT NULL, 810 col_date_nokey date NOT NULL, 811 col_time_key time NOT NULL, 812 col_time_nokey time NOT NULL, 813 col_datetime_key datetime NOT NULL, 814 col_datetime_nokey datetime NOT NULL, 815 col_varchar_key varchar(1) NOT NULL, 816 col_varchar_nokey varchar(1) NOT NULL, 817 PRIMARY KEY (pk), 818 KEY col_int_key (col_int_key), 819 KEY col_date_key (col_date_key), 820 KEY col_time_key (col_time_key), 821 KEY col_datetime_key (col_datetime_key), 822 KEY col_varchar_key (col_varchar_key,col_int_key) 823 ); 824 825INSERT IGNORE INTO B VALUES 826(1,4,0,'0000-00-00','0000-00-00','21:22:34','21:22:34','2002-02-13 827 17:30:06','2002-02-13 17:30:06','j','j'), 828 (2,6,8,'2004-09-18','2004-09-18','10:50:38','10:50:38','200 829 8-09-27 00:34:58','2008-09-27 00:34:58','v','v'); 830 831CREATE TABLE C ( 832 pk int(11) NOT NULL AUTO_INCREMENT, 833 col_int_nokey int(11) NOT NULL, 834 col_int_key int(11) NOT NULL, 835 col_date_key date NOT NULL, 836 col_date_nokey date NOT NULL, 837 col_time_key time NOT NULL, 838 col_time_nokey time NOT NULL, 839 col_datetime_key datetime NOT NULL, 840 col_datetime_nokey datetime NOT NULL, 841 col_varchar_key varchar(1) NOT NULL, 842 col_varchar_nokey varchar(1) NOT NULL, 843 PRIMARY KEY (pk), 844 KEY col_int_key (col_int_key), 845 KEY col_date_key (col_date_key), 846 KEY col_time_key (col_time_key), 847 KEY col_datetime_key (col_datetime_key), 848 KEY col_varchar_key (col_varchar_key,col_int_key) 849 ); 850 851INSERT INTO C VALUES 852 (5,2,6,'2006-05-25','2006-05-25','19:47:59','19:47:59', 853 '2001-02-15 03:08:38','2001-02-15 03:08:38','y','y'), 854 (6,9,1,'2008-01-23','2008-01-23','11:14:24','11:14:24', 855 '2004-10-02 20:31:15','2004-10-02 20:31:15','t','t'), 856 (8,8,2,'2002-10-13','2002-10-13','00:00:00','00:00:00', 857 '1900-01-01 00:00:00','1900-01-01 00:00:00','s','s'); 858 859CREATE TABLE BB ( 860 pk int(11) NOT NULL AUTO_INCREMENT, 861 col_int_nokey int(11) NOT NULL, 862 col_int_key int(11) NOT NULL, 863 col_date_key date NOT NULL, 864 col_date_nokey date NOT NULL, 865 col_time_key time NOT NULL, 866 col_time_nokey time NOT NULL, 867 col_datetime_key datetime NOT NULL, 868 col_datetime_nokey datetime NOT NULL, 869 col_varchar_key varchar(1) NOT NULL, 870 col_varchar_nokey varchar(1) NOT NULL, 871 PRIMARY KEY (pk), 872 KEY col_int_key (col_int_key), 873 KEY col_date_key (col_date_key), 874 KEY col_time_key (col_time_key), 875 KEY col_datetime_key (col_datetime_key), 876 KEY col_varchar_key (col_varchar_key,col_int_key) 877 ); 878 879INSERT INTO BB VALUES 880(10,2,6,'2003-05-14','2003-05-14','09:41:11','09:41:11','2001-11-10 881 22:10:37','2001-11-10 22:10:37','k','k'), 882 (11,1,7,'2007-12-24','2007-12-24','08:54:06','08:54:06','2002-09-18 883 16:27:07','2002-09-18 16:27:07','g','g'); 884 885 SELECT 886 OUTR . col_date_nokey AS x 887 FROM C AS OUTR2 LEFT JOIN B AS OUTR ON ( OUTR2 . col_varchar_key >= OUTR . 888 col_varchar_key ) 889 WHERE OUTR . col_int_key IN 890 ( 891 SELECT INNR . col_int_nokey AS y 892 FROM BB AS INNR 893 WHERE INNR . col_time_nokey BETWEEN '2007-11-26' AND '2002-11-26' 894 ) 895 AND OUTR . col_time_nokey < '2007-09-24' XOR OUTR . col_varchar_key IS NULL 896 ORDER BY OUTR . col_varchar_key , OUTR . pk; 897 898DROP TABLE B,C,BB; 899 900--echo # 901--echo # BUG#19019765: WL6711:RESULT DIFF WITH INNODB AS 902--echo # TMP STORAGE FOR SUB-QUERIES WITH DERIVED TABLE 903--echo # 904CREATE TABLE BB ( 905 pk int(11) NOT NULL AUTO_INCREMENT, 906 col_int_nokey int(11) NOT NULL, 907 col_int_key int(11) NOT NULL, 908 col_date_key date NOT NULL, 909 col_date_nokey date NOT NULL, 910 col_time_key time NOT NULL, 911 col_time_nokey time NOT NULL, 912 col_datetime_key datetime NOT NULL, 913 col_datetime_nokey datetime NOT NULL, 914 col_varchar_key varchar(1) NOT NULL, 915 col_varchar_nokey varchar(1) NOT NULL, 916 PRIMARY KEY (pk), 917 KEY col_int_key (col_int_key), 918 KEY col_date_key (col_date_key), 919 KEY col_time_key (col_time_key), 920 KEY col_datetime_key (col_datetime_key), 921 KEY col_varchar_key (col_varchar_key,col_int_key) 922 ) ; 923 924INSERT INTO BB VALUES (10,2,6,'2003-05-14','2003-05-14','09:41:11','09:41:11','2001-11-10 22:10:37','2001-11-10 22:10:37','k','k'),(11,1,7,'2007-12-24','2007-12-24','08:54:06','08:54:06','2002-09-18 16:27:07','2002-09-18 16:27:07','g','g'); 925 926CREATE TABLE C ( 927 pk int(11) NOT NULL AUTO_INCREMENT, 928 col_int_nokey int(11) NOT NULL, 929 col_int_key int(11) NOT NULL, 930 col_date_key date NOT NULL, 931 col_date_nokey date NOT NULL, 932 col_time_key time NOT NULL, 933 col_time_nokey time NOT NULL, 934 col_datetime_key datetime NOT NULL, 935 col_datetime_nokey datetime NOT NULL, 936 col_varchar_key varchar(1) NOT NULL, 937 col_varchar_nokey varchar(1) NOT NULL, 938 PRIMARY KEY (pk), 939 KEY col_int_key (col_int_key), 940 KEY col_date_key (col_date_key), 941 KEY col_time_key (col_time_key), 942 KEY col_datetime_key (col_datetime_key), 943 KEY col_varchar_key (col_varchar_key,col_int_key) 944 ) ; 945INSERT IGNORE INTO C VALUES (3,3,9,'2000-03-14','2000-03-14','16:25:11','16:25:11','2002-01-16 00:00:00','2002-01-16 00:00:00','d','d'),(4,246,24,'2000-10-08','2000-10-08','10:14:58','10:14:58','2006-10-12 04:32:53','2006-10-12 04:32:53','d','d'),(5,2,6,'2006-05-25','2006-05-25','19:47:59','19:47:59','2001-02-15 03:08:38','2001-02-15 03:08:38','y','y'),(7,3,6,'2007-06-18','2007-06-18','00:00:00','00:00:00','2002-08-20 22:48:00','2002-08-20 22:48:00','d','d'),(9,1,4,'1900-01-01','1900-01-01','15:57:25','15:57:25','2005-08-15 00:00:00','2005-08-15 00:00:00','r','r'),(10,8,8,'0000-00-00','0000-00-00','07:05:51','07:05:51','1900-01-01 00:00:00','1900-01-01 00:00:00','m','m'); 946 947CREATE TABLE CC ( 948 pk int(11) NOT NULL AUTO_INCREMENT, 949 col_int_nokey int(11) NOT NULL, 950 col_int_key int(11) NOT NULL, 951 col_date_key date NOT NULL, 952 col_date_nokey date NOT NULL, 953 col_time_key time NOT NULL, 954 col_time_nokey time NOT NULL, 955 col_datetime_key datetime NOT NULL, 956 col_datetime_nokey datetime NOT NULL, 957 col_varchar_key varchar(1) NOT NULL, 958 col_varchar_nokey varchar(1) NOT NULL, 959 PRIMARY KEY (pk), 960 KEY col_int_key (col_int_key), 961 KEY col_date_key (col_date_key), 962 KEY col_time_key (col_time_key), 963 KEY col_datetime_key (col_datetime_key), 964 KEY col_varchar_key (col_varchar_key,col_int_key) 965 ); 966 967INSERT INTO CC VALUES (10,0,9,'2008-04-12','2008-04-12','03:52:43','03:52:43','2003-12-04 00:00:00','2003-12-04 00:00:00','z','z'); 968SELECT 969alias2 . `col_int_nokey` AS field1 970FROM ( CC AS alias1 INNER JOIN ( ( BB AS alias2 INNER JOIN 971 ( SELECT SQ1_alias1 . * FROM C AS SQ1_alias1 ) AS alias3 972 ON (alias3 . `col_int_key` = alias2 . `col_int_nokey` ) ) ) 973 ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` ) ) 974WHERE ( ( alias2 . `pk` , alias3 . `col_int_nokey` ) IN 975 ( SELECT 4 , 7 UNION SELECT 137, 6 ) ) 976 AND alias1 . `pk` > 149 AND alias1 . `pk` < ( 149 + 7 ) 977 OR alias3 . `col_varchar_key` < 'o'; 978 979DROP TABLE CC,C,BB; 980--echo # 981--echo # BUG#19067369: CRASH AT 982--echo # ROW_SEL_CONVERT_MYSQL_KEY_TO_INNOBASE FOR SUBQUERY 983--echo # 984CREATE TABLE C ( 985 pk INTEGER AUTO_INCREMENT, 986 col_int_nokey INTEGER NOT NULL, 987 col_int_key INTEGER NOT NULL, 988 989 col_date_key DATE NOT NULL, 990 col_date_nokey DATE NOT NULL, 991 992 col_time_key TIME NOT NULL, 993 col_time_nokey TIME NOT NULL, 994 995 col_datetime_key DATETIME NOT NULL, 996 col_datetime_nokey DATETIME NOT NULL, 997 998 col_varchar_key VARCHAR(1) NOT NULL, 999 col_varchar_nokey VARCHAR(1) NOT NULL, 1000 1001 PRIMARY KEY (pk), 1002 KEY (col_int_key), 1003 KEY (col_date_key), 1004 KEY (col_time_key), 1005 KEY (col_datetime_key), 1006 KEY (col_varchar_key, col_int_key) 1007 ); 1008 1009 INSERT /*! IGNORE */ INTO C ( 1010 col_int_key, col_int_nokey, 1011 col_date_key, col_date_nokey, 1012 col_time_key, col_time_nokey, 1013 col_datetime_key, col_datetime_nokey, 1014 col_varchar_key, col_varchar_nokey 1015 ) VALUES 1016(1, 3, '2009-12-01', '2009-12-01', '00:21:38.058143', '00:21:38.058143', 1017'2007-05-28 00:00:00', '2007-05-28 00:00:00', 'c', 'c'), 1018(8, 5, '2004-12-17', '2004-12-17', '04:08:02.046897', 1019 '04:08:02.046897', '2009-07-25 09:21:20.064099', '2009-07-25 1020 09:21:20.064099', 'm', 'm'), 1021(9, 3, '2000-03-14', '2000-03-14', 1022'16:25:11.040240', '16:25:11.040240', '2002-01-16 00:00:00', '2002-01-16 102300:00:00', 'd', 'd'); 1024 1025CREATE TABLE CC ( 1026 pk INTEGER AUTO_INCREMENT, 1027 col_int_nokey INTEGER NOT NULL, 1028 col_int_key INTEGER NOT NULL, 1029 1030 col_date_key DATE NOT NULL, 1031 col_date_nokey DATE NOT NULL, 1032 1033 col_time_key TIME NOT NULL, 1034 col_time_nokey TIME NOT NULL, 1035 1036 col_datetime_key DATETIME NOT NULL, 1037 col_datetime_nokey DATETIME NOT NULL, 1038 1039 col_varchar_key VARCHAR(1) NOT NULL, 1040 col_varchar_nokey VARCHAR(1) NOT NULL, 1041 1042 PRIMARY KEY (pk), 1043 KEY (col_int_key), 1044 KEY (col_date_key), 1045 KEY (col_time_key), 1046 KEY (col_datetime_key), 1047 KEY (col_varchar_key, col_int_key) 1048 ) AUTO_INCREMENT=10; 1049 1050INSERT /*! IGNORE */ INTO CC ( 1051 col_int_key, col_int_nokey, 1052 col_date_key, col_date_nokey, 1053 col_time_key, col_time_nokey, 1054 col_datetime_key, col_datetime_nokey, 1055 col_varchar_key, col_varchar_nokey 1056 ) VALUES 1057(9, 0, '2008-04-12', '2008-04-12', 1058 '03:52:43.035922', '03:52:43.035922', '2003-12-04 00:00:00', '2003-12-04 1059 00:00:00', 'z', 'z'), 1060(4, 7, '2005-07-14', '2005-07-14', '21:10:39.061271', 1061 '21:10:39.061271', '2009-05-02 22:56:45.062451', '2009-05-02 1062 22:56:45.062451', 'n', 'n'), 1063(4, 5, '2002-12-21', '2002-12-21', 1064 '16:29:40.051764', '16:29:40.051764', '2009-10-26 12:51:42.058226', 1065 '2009-10-26 12:51:42.058226', 'j', 'j'), 1066(2, 7, '2002-03-18', '2002-03-18', 1067 '10:58:18.024863', '10:58:18.024863', '2009-02-26 14:13:52.000632', 1068 '2009-02-26 14:13:52.000632', 'l', 'l'), 1069(1, 2, NULL, NULL, '16:34:52.001480', 1070 '16:34:52.001480', '2004-11-23 02:21:32.018522', '2004-11-23 1071 02:21:32.018522', 'd', 'd'); 1072SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 1073CREATE TABLE transforms 1074SELECT 1075alias1 . `col_time_key` AS field1 , 1076alias2 . `col_time_key` AS field2 , 1077alias1 . `col_int_key` AS field3 , 1078alias2 . `col_int_key` AS field4 , 1079alias2 . `col_varchar_key` AS field5 , 1080alias1 . `col_int_key` AS field6 , 1081alias2 . `col_time_key` AS field7 , 1082alias1 . `pk` AS field8 , 1083alias1 . `col_datetime_key` AS field9 , 1084alias2 . `col_datetime_key` AS field10 , 1085alias2 . `col_date_key` AS field11 , 1086alias2 . `col_int_key` AS field12 , 1087alias2 . `col_int_key` AS field13 , 1088alias1 . `col_varchar_nokey` AS field14 , 1089alias1 . `col_date_key` AS field15 , 1090alias2 . `col_int_key` AS field16 , 1091alias1 . `col_varchar_key` AS field17 1092FROM ( C AS alias1 , CC AS alias2 ) 1093WHERE alias1 . `col_int_key` NOT IN (237) 1094ORDER BY field1, field2, field3, field4, field5, field6, field7, field8, 1095field9, field10, field11, field12, field13, field14, field15, field16, 1096field17, alias1 . `col_date_key` , alias2 .`pk` ASC; 1097SET sql_mode = default; 1098SELECT * FROM transforms 1099WHERE (`field1`, `field2`, `field3`, `field4`, `field5`, `field6`, `field7`, 1100`field8`, `field9`, `field10`, `field11`, `field12`, `field13`, `field14`, 1101`field15`, `field16`, `field17`) 1102NOT IN ( 1103SELECT 1104alias1 . `col_time_key` AS field1 , 1105alias2 . `col_time_key` AS field2 , 1106alias1 . `col_int_key` AS field3 , 1107alias2 . `col_int_key` AS field4 , 1108alias2 . `col_varchar_key` AS field5 , 1109alias1 . `col_int_key` AS field6 , 1110alias2 . `col_time_key` AS field7 , 1111alias1 . `pk` AS field8 , 1112alias1 . `col_datetime_key` AS field9 , 1113alias2 . `col_datetime_key` AS field10 , 1114alias2 . `col_date_key` AS field11 , 1115alias2 . `col_int_key` AS field12 , 1116alias2 . `col_int_key` AS field13 , 1117alias1 . `col_varchar_nokey` AS field14 , 1118alias1 . `col_date_key` AS field15 , 1119alias2 . `col_int_key` AS field16 , 1120alias1 . `col_varchar_key` AS field17 1121FROM ( C AS alias1 , CC AS alias2 ) 1122WHERE alias1 . `col_int_key` NOT IN (237) 1123ORDER BY field1, field2, field3, field4, field5, field6, field7, field8, 1124field9, field10, field11, field12, field13, field14, field15, field16, 1125field17, alias1 . `col_date_key` , alias2 .`pk` ASC ); 1126 1127DROP TABLE C,CC,transforms; 1128--enable_warnings 1129 1130--echo # 1131--echo # BUG#19274972: RESULT DIFF SEEN FOR QUERIES WITH 1132--echo # DISTINCT AND ORDER BY 1133--echo # 1134CREATE TABLE t1 ( 1135 col_varchar_10_latin1_key varchar(10), 1136 pk int(11) NOT NULL, 1137 col_varchar_10_latin1 varchar(10), 1138 col_int_key int(11), 1139 PRIMARY KEY (pk), 1140 KEY col_varchar_10_latin1_key (col_varchar_10_latin1_key), 1141 KEY col_int_key (col_int_key) 1142) ENGINE=MyISAM; 1143 1144INSERT INTO t1 VALUES 1145('OAYEP',1,'yeah',183566336), 1146('u',2,'vvgnejnnoj',-638058496), 1147('h',3,'LJKVO',2), 1148('x',4,'l',-1954938880), 1149('JVYHY',5,'at',9), 1150('b',6,'ojcnhnzfih',1995505664), 1151('she',7,'jcnhnzfihl',6), 1152('BTXLX',8,'GONBZ',162267136), 1153('d',9,'nhnzfihlaj',8), 1154('VSOED',10,'q',2), 1155('nzfihlajoz',11,'o',8), 1156('WCJYY',12,'FQNYF',-1901068288), 1157('r' ,13,'f',-220659712), 1158('u',14,'f',6), 1159('DFKKY',15,'ozgqcypkrh',1), 1160('if',16,'it',8), 1161('from',17,'KKFED',-1065615360), 1162('IBMRH',18,'back',5), 1163('pkrhtylkoy',19,'WELBV',2), 1164('b',20,'d',2131558400); 1165 1166CREATE TABLE t2 ( 1167 col_varchar_1024_utf8_key varchar(1024), 1168 pk int(11) NOT NULL, 1169 col_varchar_1024_latin1_key varchar(1024), 1170 col_int_key int(11), 1171 PRIMARY KEY (pk), 1172 KEY col_varchar_1024_utf8_key (col_varchar_1024_utf8_key(333)), 1173 KEY col_varchar_1024_latin1_key (col_varchar_1024_latin1_key(1000)), 1174 KEY col_int_key (col_int_key) 1175) ENGINE=MyISAM; 1176 1177INSERT INTO t2 VALUES 1178('MFDLE',1,'no',1358168064), 1179('v',2,'really',154664960), 1180(repeat('mcrxjxxfpo',100),3,repeat('mcrxjxxfpo',100),1), 1181('o',4,'CEJHM',3), 1182('j',5,'CRDLM',174915584), 1183('m',6,'that\'s',7), 1184('YVMBM',7,'is',4), 1185('h',8,'as',8), 1186('y',9,'not',686096384), 1187('m',10,repeat('mcrxjxxfpo',100),8), 1188(repeat('mcrxjxxfpo',100),11,'v',2), 1189('and', 12,'b',6), 1190('from',13,'OJSUT',9), 1191('you',14,repeat('mcrxjxxfpo',100),1), 1192('mr',15,'ZMJFI',9), 1193('TYZOE',16,'I\'ll',-363069440), 1194('HLKEJ',17,'v',-767492096), 1195('OINER',18,repeat('mcrxjxxfpo',100),-102170624), 1196(repeat('mcrxjxxfpo',100),19,'i',7), 1197('one',20,'CPIUQ',469303296), 1198(repeat('mcrxjxxfpo',100),21,'IGLXO',1140391936), 1199('ERRUY',22,'WKQHJ',1), 1200('q',23,repeat('mcrxjxxfpo',100),1694564352), 1201('CYGKG',24,'o',7), 1202('BIWWF',25,'good',-1532035072); 1203 1204SELECT DISTINCT 1205 table1.col_varchar_1024_latin1_key AS field1, 1206 table1.col_varchar_1024_latin1_key AS field2 1207FROM 1208 t2 AS table1 RIGHT JOIN t1 AS table2 ON table1.pk = table2.col_int_key 1209WHERE 1210 table1.col_int_key NOT BETWEEN 7 AND ( 7 + 1000 ) OR table1.pk >= 7 1211 AND table1.col_varchar_1024_utf8_key < table2.col_varchar_10_latin1_key 1212ORDER BY field1,field2 DESC; 1213 1214DROP TABLE t1,t2; 1215 1216--echo # 1217--echo # BUG#19191377: WL#6737: NOT NULL COLUMN IS BEING PROJECTED 1218--echo # AS NULLABLE IN TEMPORARY TABLES. 1219--echo # 1220CREATE TABLE t1(f1 INT NOT NULL); 1221INSERT INTO t1 VALUES (16777214), (0); 1222SELECT COUNT(*) FROM t1 LEFT JOIN t1 t2 ON 1 WHERE t2.f1 > 1 GROUP BY t2.f1; 1223DROP TABLE t1; 1224 1225--echo # 1226--echo # BUG#20059644: WL#6737: CRASH AT OPERATOR<< IN DICT/DICT0MEM.CC 1227--echo # 1228CREATE TABLE C ( 1229 pk int(11) NOT NULL AUTO_INCREMENT, 1230 col_varchar_key varchar(1) NOT NULL, 1231 col_varchar_nokey varchar(1) NOT NULL, 1232 PRIMARY KEY (pk), 1233 KEY col_varchar_key (col_varchar_key) 1234); 1235INSERT INTO C VALUES (7,'y','y'); 1236 1237CREATE TABLE CC ( 1238 pk int(11) NOT NULL AUTO_INCREMENT, 1239 col_varchar_key varchar(1) NOT NULL, 1240 col_varchar_nokey varchar(1) NOT NULL, 1241 PRIMARY KEY (pk), 1242 KEY col_varchar_key (col_varchar_key) 1243); 1244INSERT INTO CC VALUES (13,'y','y'); 1245 1246SELECT 1247DISTINCT CONCAT( table2 . col_varchar_key , table1 . col_varchar_key ) 1248AS field1 1249FROM 1250( CC AS table1 RIGHT OUTER JOIN C AS table2 ON (table2 . col_varchar_key = 1251table1 . col_varchar_nokey ) ) 1252WHERE 1253( 1254table1 . pk = 13 1255) 1256ORDER BY field1 , field1; 1257 1258DROP TABLE C,CC; 1259--echo # 1260--echo # BUG#19627741: SELECT DISTINCT SUM() RETURNS DUPLICATE ROWS 1261--echo # 1262CREATE TABLE t1 ( 1263a int(11) DEFAULT NULL, 1264b int(11) DEFAULT NULL, 1265c1 int(11) DEFAULT NULL, 1266c2 int(11) DEFAULT NULL, 1267c3 int(11) DEFAULT NULL, 1268c4 int(11) DEFAULT NULL, 1269c5 int(11) DEFAULT NULL, 1270c6 int(11) DEFAULT NULL, 1271c7 int(11) DEFAULT NULL, 1272c8 int(11) DEFAULT NULL, 1273c9 int(11) DEFAULT NULL, 1274c10 int(11) DEFAULT NULL, 1275c11 int(11) DEFAULT NULL, 1276c12 int(11) DEFAULT NULL, 1277c13 int(11) DEFAULT NULL, 1278c14 int(11) DEFAULT NULL, 1279c15 int(11) DEFAULT NULL, 1280c16 int(11) DEFAULT NULL, 1281c17 int(11) DEFAULT NULL, 1282c18 int(11) DEFAULT NULL, 1283c19 int(11) DEFAULT NULL, 1284c20 int(11) DEFAULT NULL, 1285c21 int(11) DEFAULT NULL, 1286c22 int(11) DEFAULT NULL, 1287c23 int(11) DEFAULT NULL, 1288c24 int(11) DEFAULT NULL, 1289c25 int(11) DEFAULT NULL, 1290c26 int(11) DEFAULT NULL, 1291c27 int(11) DEFAULT NULL, 1292c28 int(11) DEFAULT NULL, 1293c29 int(11) DEFAULT NULL, 1294c30 int(11) DEFAULT NULL, 1295c31 int(11) DEFAULT NULL, 1296c32 int(11) DEFAULT NULL, 1297c33 int(11) DEFAULT NULL, 1298c34 int(11) DEFAULT NULL, 1299c35 int(11) DEFAULT NULL 1300); 1301INSERT INTO t1 (a,b) VALUES (1,4),(2,2),(2,2),(4,1),(4,1),(4,1),(4,1); 1302SELECT sum(b) FROM t1 GROUP BY a, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, 1303c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, 1304c26, c27, c28, c29, c30, c31, c32, c33, c34, c35; 1305SELECT DISTINCT sum(b) FROM t1 GROUP BY a, c1, c2, c3, c4, c5, c6, c7, c8, 1306c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, 1307c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35; 1308DROP TABLE t1; 1309 1310--echo # 1311--echo # Bug#20454833 PREFIX INDEX FIELD, ON AN INAPPROPRIATE DATA TYPE 1312--echo # 1313 1314set sql_mode=''; 1315create table t1 (a blob,b int) engine=innodb; 1316create table t2 (b blob) engine=innodb; 1317select t2.b,t1.b,t1.a 1318from t2 inner join t1 on 1 cross join t2 a on 1 1319group by t1.b; 1320set sql_mode=default; 1321drop table t1,t2; 1322 1323--echo # 1324--echo # Bug#20506527 FAILING ASSERTION: !MBMAXLEN || !(PREFIX_LEN % MBMAXLEN) 1325--echo # 1326 1327set names utf8, sql_mode=''; 1328create table t1(a date,b text charset utf8,c linestring not null); 1329insert into t1 values ('2015-01-01','a',linestring(point(1,1),point(2,2))); 1330select distinct nullif(a,b) as c from t1 z order by z.c; 1331set names default, sql_mode=default; 1332drop table t1; 1333 1334--echo # 1335--echo # Bug#20752543 INNODB:FAILING ASSERTION:FLAGS & BUF_PAGE_PRINT_NO_CRASH 1336--echo # 1337SET @old_big_tables=@@big_tables; 1338SET big_tables=on; 1339set @old_limit_optimistic_insert_debug= @@innodb_limit_optimistic_insert_debug; 1340set global innodb_limit_optimistic_insert_debug=2; 1341select 1 as a union all select 1 union all select 2 union select 1 union all 1342select 2; 1343set big_tables= @old_big_tables; 1344set global innodb_limit_optimistic_insert_debug= 1345 @old_limit_optimistic_insert_debug; 1346--echo # 1347--echo # Bug#20454979 CRASH IN ACTUAL_KEY_PARTS 1348--echo # 1349create table t1(a blob); 1350insert into t1 values ('a'); 1351select distinct least(1,count(distinct a)) from t1 group by a; 1352drop table t1; 1353 1354--echo # 1355--echo # Bug#21461026: INCONSISTEND CASING ON STORAGE ENGINE VARIABLE VALUE 1356--echo # 1357SHOW GLOBAL VARIABLES LIKE '%\_storage\_engine'; 1358#============================end && cleanup======================= 1359SET GLOBAL innodb_large_prefix=default; 1360set @@global.internal_tmp_disk_storage_engine= @old_internal_tmp_disk_storage_engine; 1361set big_tables= @old_big_tables; 1362set optimizer_switch= @old_optimizer_switch; 1363--source include/restore_sql_mode_after_turn_off_only_full_group_by.inc 1364--echo # 1365 1366--echo # 1367--echo # Bug #22343910: SELECT DISTINCT NOT RETURNING DISTINCT ROWS IN 5.7 1368--echo # 1369 1370CREATE TABLE test_distinct (c1 VARCHAR(1000), 1371 c2 CHAR(5) DEFAULT 'xxxxx'); 1372INSERT INTO test_distinct VALUES ('a',null), ('a',null); 1373 1374SET global internal_tmp_disk_storage_engine=MYISAM; 1375SELECT DISTINCT c1, c2 FROM test_distinct; 1376SELECT c1, c2 FROM test_distinct GROUP BY c1, c2; 1377 1378SET global internal_tmp_disk_storage_engine=INNODB; 1379SELECT DISTINCT c1, c2 FROM test_distinct; 1380SELECT c1, c2 FROM test_distinct GROUP BY c1, c2; 1381 1382DROP TABLE test_distinct; 1383