Debian Codegraph @

mysql-test/suite/archive/archive.test

raw
1 #
2 # Simple test for archive example
3 # Taken FROM the select test
4 #
5 -- source include/have_archive.inc
6
7 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
8 call mtr.add_suppression("Table 't1' is marked as crashed and should be repaired");
9
10 SET default_storage_engine=ARCHIVE;
11 let $MYSQLD_DATADIR= `SELECT @@datadir`;
12
13 CREATE TABLE t1 (
14 Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,
15 Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL
16 ) ENGINE=archive;
17
18 INSERT INTO t1 VALUES (9410,9412);
19
20 select period FROM t1;
21 select * FROM t1;
22 select t1.* FROM t1;
23
24 #
25 # Create test table
26 #
27
28 CREATE TABLE t2 (
29 auto int,
30 fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL,
31 companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL,
32 fld3 char(30) DEFAULT '' NOT NULL,
33 fld4 char(35) DEFAULT '' NOT NULL,
34 fld5 char(35) DEFAULT '' NOT NULL,
35 fld6 char(4) DEFAULT '' NOT NULL
36 ) ENGINE=archive;
37
38 #
39 # Populate table
40 #
41
42 --disable_query_log
43 INSERT INTO t2 VALUES (1,000001,00,'Omaha','teethe','neat','');
44 INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
45 INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
46 INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
47 INSERT INTO t2 VALUES (5,011501,37,'bewilderingly','wallet','balled','');
48 INSERT INTO t2 VALUES (6,011701,37,'astound','parters','persist','W');
49 INSERT INTO t2 VALUES (7,011702,37,'admonishing','eschew','attainments','');
50 INSERT INTO t2 VALUES (8,011703,37,'sumac','quitter','fanatic','');
51 INSERT INTO t2 VALUES (9,012001,37,'flanking','neat','measures','FAS');
52 INSERT INTO t2 VALUES (10,012003,37,'combed','Steinberg','rightfulness','');
53 INSERT INTO t2 VALUES (11,012004,37,'subjective','jarring','capably','');
54 INSERT INTO t2 VALUES (12,012005,37,'scatterbrain','tinily','impulsive','');
55 INSERT INTO t2 VALUES (13,012301,37,'Eulerian','balled','starlet','');
56 INSERT INTO t2 VALUES (14,012302,36,'dubbed','persist','terminators','');
57 INSERT INTO t2 VALUES (15,012303,37,'Kane','attainments','untying','');
58 INSERT INTO t2 VALUES (16,012304,37,'overlay','fanatic','announces','FAS');
59 INSERT INTO t2 VALUES (17,012305,37,'perturb','measures','featherweight','FAS');
60 INSERT INTO t2 VALUES (18,012306,37,'goblins','rightfulness','pessimist','FAS');
61 INSERT INTO t2 VALUES (19,012501,37,'annihilates','capably','daughter','');
62 INSERT INTO t2 VALUES (20,012602,37,'Wotan','impulsive','decliner','FAS');
63 INSERT INTO t2 VALUES (21,012603,37,'snatching','starlet','lawgiver','');
64 INSERT INTO t2 VALUES (22,012604,37,'concludes','terminators','stated','');
65 INSERT INTO t2 VALUES (23,012605,37,'laterally','untying','readable','');
66 INSERT INTO t2 VALUES (24,012606,37,'yelped','announces','attrition','');
67 INSERT INTO t2 VALUES (25,012701,37,'grazing','featherweight','cascade','FAS');
68 INSERT INTO t2 VALUES (26,012702,37,'Baird','pessimist','motors','FAS');
69 INSERT INTO t2 VALUES (27,012703,37,'celery','daughter','interrogate','');
70 INSERT INTO t2 VALUES (28,012704,37,'misunderstander','decliner','pests','W');
71 INSERT INTO t2 VALUES (29,013601,37,'handgun','lawgiver','stairway','');
72 INSERT INTO t2 VALUES (30,013602,37,'foldout','stated','dopers','FAS');
73 INSERT INTO t2 VALUES (31,013603,37,'mystic','readable','testicle','W');
74 INSERT INTO t2 VALUES (32,013604,37,'succumbed','attrition','Parsifal','W');
75 INSERT INTO t2 VALUES (33,013605,37,'Nabisco','cascade','leavings','');
76 INSERT INTO t2 VALUES (34,013606,37,'fingerings','motors','postulation','W');
77 INSERT INTO t2 VALUES (35,013607,37,'aging','interrogate','squeaking','');
78 INSERT INTO t2 VALUES (36,013608,37,'afield','pests','contrasted','');
79 INSERT INTO t2 VALUES (37,013609,37,'ammonium','stairway','leftover','');
80 INSERT INTO t2 VALUES (38,013610,37,'boat','dopers','whiteners','');
81 INSERT INTO t2 VALUES (39,013801,37,'intelligibility','testicle','erases','W');
82 INSERT INTO t2 VALUES (40,013802,37,'Augustine','Parsifal','Punjab','W');
83 INSERT INTO t2 VALUES (41,013803,37,'teethe','leavings','Merritt','');
84 INSERT INTO t2 VALUES (42,013804,37,'dreaded','postulation','Quixotism','');
85 INSERT INTO t2 VALUES (43,013901,37,'scholastics','squeaking','sweetish','FAS');
86 INSERT INTO t2 VALUES (44,016001,37,'audiology','contrasted','dogging','FAS');
87 INSERT INTO t2 VALUES (45,016201,37,'wallet','leftover','scornfully','FAS');
88 INSERT INTO t2 VALUES (46,016202,37,'parters','whiteners','bellow','');
89 INSERT INTO t2 VALUES (47,016301,37,'eschew','erases','bills','');
90 INSERT INTO t2 VALUES (48,016302,37,'quitter','Punjab','cupboard','FAS');
91 INSERT INTO t2 VALUES (49,016303,37,'neat','Merritt','sureties','FAS');
92 INSERT INTO t2 VALUES (50,016304,37,'Steinberg','Quixotism','puddings','');
93 INSERT INTO t2 VALUES (51,018001,37,'jarring','sweetish','tapestry','');
94 INSERT INTO t2 VALUES (52,018002,37,'tinily','dogging','fetters','');
95 INSERT INTO t2 VALUES (53,018003,37,'balled','scornfully','bivalves','');
96 INSERT INTO t2 VALUES (54,018004,37,'persist','bellow','incurring','');
97 INSERT INTO t2 VALUES (55,018005,37,'attainments','bills','Adolph','');
98 INSERT INTO t2 VALUES (56,018007,37,'fanatic','cupboard','pithed','');
99 INSERT INTO t2 VALUES (57,018008,37,'measures','sureties','emergency','');
100 INSERT INTO t2 VALUES (58,018009,37,'rightfulness','puddings','Miles','');
101 INSERT INTO t2 VALUES (59,018010,37,'capably','tapestry','trimmings','');
102 INSERT INTO t2 VALUES (60,018012,37,'impulsive','fetters','tragedies','W');
103 INSERT INTO t2 VALUES (61,018013,37,'starlet','bivalves','skulking','W');
104 INSERT INTO t2 VALUES (62,018014,37,'terminators','incurring','flint','');
105 INSERT INTO t2 VALUES (63,018015,37,'untying','Adolph','flopping','W');
106 INSERT INTO t2 VALUES (64,018016,37,'announces','pithed','relaxing','FAS');
107 INSERT INTO t2 VALUES (65,018017,37,'featherweight','emergency','offload','FAS');
108 INSERT INTO t2 VALUES (66,018018,37,'pessimist','Miles','suites','W');
109 INSERT INTO t2 VALUES (67,018019,37,'daughter','trimmings','lists','FAS');
110 INSERT INTO t2 VALUES (68,018020,37,'decliner','tragedies','animized','FAS');
111 INSERT INTO t2 VALUES (69,018021,37,'lawgiver','skulking','multilayer','W');
112 INSERT INTO t2 VALUES (70,018022,37,'stated','flint','standardizes','FAS');
113 INSERT INTO t2 VALUES (71,018023,37,'readable','flopping','Judas','');
114 INSERT INTO t2 VALUES (72,018024,37,'attrition','relaxing','vacuuming','W');
115 INSERT INTO t2 VALUES (73,018025,37,'cascade','offload','dentally','W');
116 INSERT INTO t2 VALUES (74,018026,37,'motors','suites','humanness','W');
117 INSERT INTO t2 VALUES (75,018027,37,'interrogate','lists','inch','W');
118 INSERT INTO t2 VALUES (76,018028,37,'pests','animized','Weissmuller','W');
119 INSERT INTO t2 VALUES (77,018029,37,'stairway','multilayer','irresponsibly','W');
120 INSERT INTO t2 VALUES (78,018030,37,'dopers','standardizes','luckily','FAS');
121 INSERT INTO t2 VALUES (79,018032,37,'testicle','Judas','culled','W');
122 INSERT INTO t2 VALUES (80,018033,37,'Parsifal','vacuuming','medical','FAS');
123 INSERT INTO t2 VALUES (81,018034,37,'leavings','dentally','bloodbath','FAS');
124 INSERT INTO t2 VALUES (82,018035,37,'postulation','humanness','subschema','W');
125 INSERT INTO t2 VALUES (83,018036,37,'squeaking','inch','animals','W');
126 INSERT INTO t2 VALUES (84,018037,37,'contrasted','Weissmuller','Micronesia','');
127 INSERT INTO t2 VALUES (85,018038,37,'leftover','irresponsibly','repetitions','');
128 INSERT INTO t2 VALUES (86,018039,37,'whiteners','luckily','Antares','');
129 INSERT INTO t2 VALUES (87,018040,37,'erases','culled','ventilate','W');
130 INSERT INTO t2 VALUES (88,018041,37,'Punjab','medical','pityingly','');
131 INSERT INTO t2 VALUES (89,018042,37,'Merritt','bloodbath','interdependent','');
132 INSERT INTO t2 VALUES (90,018043,37,'Quixotism','subschema','Graves','FAS');
133 INSERT INTO t2 VALUES (91,018044,37,'sweetish','animals','neonatal','');
134 INSERT INTO t2 VALUES (92,018045,37,'dogging','Micronesia','scribbled','FAS');
135 INSERT INTO t2 VALUES (93,018046,37,'scornfully','repetitions','chafe','W');
136 INSERT INTO t2 VALUES (94,018048,37,'bellow','Antares','honoring','');
137 INSERT INTO t2 VALUES (95,018049,37,'bills','ventilate','realtor','');
138 INSERT INTO t2 VALUES (96,018050,37,'cupboard','pityingly','elite','');
139 INSERT INTO t2 VALUES (97,018051,37,'sureties','interdependent','funereal','');
140 INSERT INTO t2 VALUES (98,018052,37,'puddings','Graves','abrogating','');
141 INSERT INTO t2 VALUES (99,018053,50,'tapestry','neonatal','sorters','');
142 INSERT INTO t2 VALUES (100,018054,37,'fetters','scribbled','Conley','');
143 INSERT INTO t2 VALUES (101,018055,37,'bivalves','chafe','lectured','');
144 INSERT INTO t2 VALUES (102,018056,37,'incurring','honoring','Abraham','');
145 INSERT INTO t2 VALUES (103,018057,37,'Adolph','realtor','Hawaii','W');
146 INSERT INTO t2 VALUES (104,018058,37,'pithed','elite','cage','');
147 INSERT INTO t2 VALUES (105,018059,36,'emergency','funereal','hushes','');
148 INSERT INTO t2 VALUES (106,018060,37,'Miles','abrogating','Simla','');
149 INSERT INTO t2 VALUES (107,018061,37,'trimmings','sorters','reporters','');
150 INSERT INTO t2 VALUES (108,018101,37,'tragedies','Conley','Dutchman','FAS');
151 INSERT INTO t2 VALUES (109,018102,37,'skulking','lectured','descendants','FAS');
152 INSERT INTO t2 VALUES (110,018103,37,'flint','Abraham','groupings','FAS');
153 INSERT INTO t2 VALUES (111,018104,37,'flopping','Hawaii','dissociate','');
154 INSERT INTO t2 VALUES (112,018201,37,'relaxing','cage','coexist','W');
155 INSERT INTO t2 VALUES (113,018202,37,'offload','hushes','Beebe','');
156 INSERT INTO t2 VALUES (114,018402,37,'suites','Simla','Taoism','');
157 INSERT INTO t2 VALUES (115,018403,37,'lists','reporters','Connally','');
158 INSERT INTO t2 VALUES (116,018404,37,'animized','Dutchman','fetched','FAS');
159 INSERT INTO t2 VALUES (117,018405,37,'multilayer','descendants','checkpoints','FAS');
160 INSERT INTO t2 VALUES (118,018406,37,'standardizes','groupings','rusting','');
161 INSERT INTO t2 VALUES (119,018409,37,'Judas','dissociate','galling','');
162 INSERT INTO t2 VALUES (120,018601,37,'vacuuming','coexist','obliterates','');
163 INSERT INTO t2 VALUES (121,018602,37,'dentally','Beebe','traitor','');
164 INSERT INTO t2 VALUES (122,018603,37,'humanness','Taoism','resumes','FAS');
165 INSERT INTO t2 VALUES (123,018801,37,'inch','Connally','analyzable','FAS');
166 INSERT INTO t2 VALUES (124,018802,37,'Weissmuller','fetched','terminator','FAS');
167 INSERT INTO t2 VALUES (125,018803,37,'irresponsibly','checkpoints','gritty','FAS');
168 INSERT INTO t2 VALUES (126,018804,37,'luckily','rusting','firearm','W');
169 INSERT INTO t2 VALUES (127,018805,37,'culled','galling','minima','');
170 INSERT INTO t2 VALUES (128,018806,37,'medical','obliterates','Selfridge','');
171 INSERT INTO t2 VALUES (129,018807,37,'bloodbath','traitor','disable','');
172 INSERT INTO t2 VALUES (130,018808,37,'subschema','resumes','witchcraft','W');
173 INSERT INTO t2 VALUES (131,018809,37,'animals','analyzable','betroth','W');
174 INSERT INTO t2 VALUES (132,018810,37,'Micronesia','terminator','Manhattanize','');
175 INSERT INTO t2 VALUES (133,018811,37,'repetitions','gritty','imprint','');
176 INSERT INTO t2 VALUES (134,018812,37,'Antares','firearm','peeked','');
177 INSERT INTO t2 VALUES (135,019101,37,'ventilate','minima','swelling','');
178 INSERT INTO t2 VALUES (136,019102,37,'pityingly','Selfridge','interrelationships','W');
179 INSERT INTO t2 VALUES (137,019103,37,'interdependent','disable','riser','');
180 INSERT INTO t2 VALUES (138,019201,37,'Graves','witchcraft','Gandhian','W');
181 INSERT INTO t2 VALUES (139,030501,37,'neonatal','betroth','peacock','A');
182 INSERT INTO t2 VALUES (140,030502,50,'scribbled','Manhattanize','bee','A');
183 INSERT INTO t2 VALUES (141,030503,37,'chafe','imprint','kanji','');
184 INSERT INTO t2 VALUES (142,030504,37,'honoring','peeked','dental','');
185 INSERT INTO t2 VALUES (143,031901,37,'realtor','swelling','scarf','FAS');
186 INSERT INTO t2 VALUES (144,036001,37,'elite','interrelationships','chasm','A');
187 INSERT INTO t2 VALUES (145,036002,37,'funereal','riser','insolence','A');
188 INSERT INTO t2 VALUES (146,036004,37,'abrogating','Gandhian','syndicate','');
189 INSERT INTO t2 VALUES (147,036005,37,'sorters','peacock','alike','');
190 INSERT INTO t2 VALUES (148,038001,37,'Conley','bee','imperial','A');
191 INSERT INTO t2 VALUES (149,038002,37,'lectured','kanji','convulsion','A');
192 INSERT INTO t2 VALUES (150,038003,37,'Abraham','dental','railway','A');
193 INSERT INTO t2 VALUES (151,038004,37,'Hawaii','scarf','validate','A');
194 INSERT INTO t2 VALUES (152,038005,37,'cage','chasm','normalizes','A');
195 INSERT INTO t2 VALUES (153,038006,37,'hushes','insolence','comprehensive','');
196 INSERT INTO t2 VALUES (154,038007,37,'Simla','syndicate','chewing','');
197 INSERT INTO t2 VALUES (155,038008,37,'reporters','alike','denizen','');
198 INSERT INTO t2 VALUES (156,038009,37,'Dutchman','imperial','schemer','');
199 INSERT INTO t2 VALUES (157,038010,37,'descendants','convulsion','chronicle','');
200 INSERT INTO t2 VALUES (158,038011,37,'groupings','railway','Kline','');
201 INSERT INTO t2 VALUES (159,038012,37,'dissociate','validate','Anatole','');
202 INSERT INTO t2 VALUES (160,038013,37,'coexist','normalizes','partridges','');
203 INSERT INTO t2 VALUES (161,038014,37,'Beebe','comprehensive','brunch','');
204 INSERT INTO t2 VALUES (162,038015,37,'Taoism','chewing','recruited','');
205 INSERT INTO t2 VALUES (163,038016,37,'Connally','denizen','dimensions','W');
206 INSERT INTO t2 VALUES (164,038017,37,'fetched','schemer','Chicana','W');
207 INSERT INTO t2 VALUES (165,038018,37,'checkpoints','chronicle','announced','');
208 INSERT INTO t2 VALUES (166,038101,37,'rusting','Kline','praised','FAS');
209 INSERT INTO t2 VALUES (167,038102,37,'galling','Anatole','employing','');
210 INSERT INTO t2 VALUES (168,038103,37,'obliterates','partridges','linear','');
211 INSERT INTO t2 VALUES (169,038104,37,'traitor','brunch','quagmire','');
212 INSERT INTO t2 VALUES (170,038201,37,'resumes','recruited','western','A');
213 INSERT INTO t2 VALUES (171,038202,37,'analyzable','dimensions','relishing','');
214 INSERT INTO t2 VALUES (172,038203,37,'terminator','Chicana','serving','A');
215 INSERT INTO t2 VALUES (173,038204,37,'gritty','announced','scheduling','');
216 INSERT INTO t2 VALUES (174,038205,37,'firearm','praised','lore','');
217 INSERT INTO t2 VALUES (175,038206,37,'minima','employing','eventful','');
218 INSERT INTO t2 VALUES (176,038208,37,'Selfridge','linear','arteriole','A');
219 INSERT INTO t2 VALUES (177,042801,37,'disable','quagmire','disentangle','');
220 INSERT INTO t2 VALUES (178,042802,37,'witchcraft','western','cured','A');
221 INSERT INTO t2 VALUES (179,046101,37,'betroth','relishing','Fenton','W');
222 INSERT INTO t2 VALUES (180,048001,37,'Manhattanize','serving','avoidable','A');
223 INSERT INTO t2 VALUES (181,048002,37,'imprint','scheduling','drains','A');
224 INSERT INTO t2 VALUES (182,048003,37,'peeked','lore','detectably','FAS');
225 INSERT INTO t2 VALUES (183,048004,37,'swelling','eventful','husky','');
226 INSERT INTO t2 VALUES (184,048005,37,'interrelationships','arteriole','impelling','');
227 INSERT INTO t2 VALUES (185,048006,37,'riser','disentangle','undoes','');
228 INSERT INTO t2 VALUES (186,048007,37,'Gandhian','cured','evened','');
229 INSERT INTO t2 VALUES (187,048008,37,'peacock','Fenton','squeezes','');
230 INSERT INTO t2 VALUES (188,048101,37,'bee','avoidable','destroyer','FAS');
231 INSERT INTO t2 VALUES (189,048102,37,'kanji','drains','rudeness','');
232 INSERT INTO t2 VALUES (190,048201,37,'dental','detectably','beaner','FAS');
233 INSERT INTO t2 VALUES (191,048202,37,'scarf','husky','boorish','');
234 INSERT INTO t2 VALUES (192,048203,37,'chasm','impelling','Everhart','');
235 INSERT INTO t2 VALUES (193,048204,37,'insolence','undoes','encompass','A');
236 INSERT INTO t2 VALUES (194,048205,37,'syndicate','evened','mushrooms','');
237 INSERT INTO t2 VALUES (195,048301,37,'alike','squeezes','Alison','A');
238 INSERT INTO t2 VALUES (196,048302,37,'imperial','destroyer','externally','FAS');
239 INSERT INTO t2 VALUES (197,048303,37,'convulsion','rudeness','pellagra','');
240 INSERT INTO t2 VALUES (198,048304,37,'railway','beaner','cult','');
241 INSERT INTO t2 VALUES (199,048305,37,'validate','boorish','creek','A');
242 INSERT INTO t2 VALUES (200,048401,37,'normalizes','Everhart','Huffman','');
243 INSERT INTO t2 VALUES (201,048402,37,'comprehensive','encompass','Majorca','FAS');
244 INSERT INTO t2 VALUES (202,048403,37,'chewing','mushrooms','governing','A');
245 INSERT INTO t2 VALUES (203,048404,37,'denizen','Alison','gadfly','FAS');
246 INSERT INTO t2 VALUES (204,048405,37,'schemer','externally','reassigned','FAS');
247 INSERT INTO t2 VALUES (205,048406,37,'chronicle','pellagra','intentness','W');
248 INSERT INTO t2 VALUES (206,048407,37,'Kline','cult','craziness','');
249 INSERT INTO t2 VALUES (207,048408,37,'Anatole','creek','psychic','');
250 INSERT INTO t2 VALUES (208,048409,37,'partridges','Huffman','squabbled','');
251 INSERT INTO t2 VALUES (209,048410,37,'brunch','Majorca','burlesque','');
252 INSERT INTO t2 VALUES (210,048411,37,'recruited','governing','capped','');
253 INSERT INTO t2 VALUES (211,048412,37,'dimensions','gadfly','extracted','A');
254 INSERT INTO t2 VALUES (212,048413,37,'Chicana','reassigned','DiMaggio','');
255 INSERT INTO t2 VALUES (213,048601,37,'announced','intentness','exclamation','FAS');
256 INSERT INTO t2 VALUES (214,048602,37,'praised','craziness','subdirectory','');
257 INSERT INTO t2 VALUES (215,048603,37,'employing','psychic','fangs','');
258 INSERT INTO t2 VALUES (216,048604,37,'linear','squabbled','buyer','A');
259 INSERT INTO t2 VALUES (217,048801,37,'quagmire','burlesque','pithing','A');
260 INSERT INTO t2 VALUES (218,050901,37,'western','capped','transistorizing','A');
261 INSERT INTO t2 VALUES (219,051201,37,'relishing','extracted','nonbiodegradable','');
262 INSERT INTO t2 VALUES (220,056002,37,'serving','DiMaggio','dislocate','');
263 INSERT INTO t2 VALUES (221,056003,37,'scheduling','exclamation','monochromatic','FAS');
264 INSERT INTO t2 VALUES (222,056004,37,'lore','subdirectory','batting','');
265 INSERT INTO t2 VALUES (223,056102,37,'eventful','fangs','postcondition','A');
266 INSERT INTO t2 VALUES (224,056203,37,'arteriole','buyer','catalog','FAS');
267 INSERT INTO t2 VALUES (225,056204,37,'disentangle','pithing','Remus','');
268 INSERT INTO t2 VALUES (226,058003,37,'cured','transistorizing','devices','A');
269 INSERT INTO t2 VALUES (227,058004,37,'Fenton','nonbiodegradable','bike','A');
270 INSERT INTO t2 VALUES (228,058005,37,'avoidable','dislocate','qualify','');
271 INSERT INTO t2 VALUES (229,058006,37,'drains','monochromatic','detained','');
272 INSERT INTO t2 VALUES (230,058007,37,'detectably','batting','commended','');
273 INSERT INTO t2 VALUES (231,058101,37,'husky','postcondition','civilize','');
274 INSERT INTO t2 VALUES (232,058102,37,'impelling','catalog','Elmhurst','');
275 INSERT INTO t2 VALUES (233,058103,37,'undoes','Remus','anesthetizing','');
276 INSERT INTO t2 VALUES (234,058105,37,'evened','devices','deaf','');
277 INSERT INTO t2 VALUES (235,058111,37,'squeezes','bike','Brigham','');
278 INSERT INTO t2 VALUES (236,058112,37,'destroyer','qualify','title','');
279 INSERT INTO t2 VALUES (237,058113,37,'rudeness','detained','coarse','');
280 INSERT INTO t2 VALUES (238,058114,37,'beaner','commended','combinations','');
281 INSERT INTO t2 VALUES (239,058115,37,'boorish','civilize','grayness','');
282 INSERT INTO t2 VALUES (240,058116,37,'Everhart','Elmhurst','innumerable','FAS');
283 INSERT INTO t2 VALUES (241,058117,37,'encompass','anesthetizing','Caroline','A');
284 INSERT INTO t2 VALUES (242,058118,37,'mushrooms','deaf','fatty','FAS');
285 INSERT INTO t2 VALUES (243,058119,37,'Alison','Brigham','eastbound','');
286 INSERT INTO t2 VALUES (244,058120,37,'externally','title','inexperienced','');
287 INSERT INTO t2 VALUES (245,058121,37,'pellagra','coarse','hoarder','A');
288 INSERT INTO t2 VALUES (246,058122,37,'cult','combinations','scotch','W');
289 INSERT INTO t2 VALUES (247,058123,37,'creek','grayness','passport','A');
290 INSERT INTO t2 VALUES (248,058124,37,'Huffman','innumerable','strategic','FAS');
291 INSERT INTO t2 VALUES (249,058125,37,'Majorca','Caroline','gated','');
292 INSERT INTO t2 VALUES (250,058126,37,'governing','fatty','flog','');
293 INSERT INTO t2 VALUES (251,058127,37,'gadfly','eastbound','Pipestone','');
294 INSERT INTO t2 VALUES (252,058128,37,'reassigned','inexperienced','Dar','');
295 INSERT INTO t2 VALUES (253,058201,37,'intentness','hoarder','Corcoran','');
296 INSERT INTO t2 VALUES (254,058202,37,'craziness','scotch','flyers','A');
297 INSERT INTO t2 VALUES (255,058303,37,'psychic','passport','competitions','W');
298 INSERT INTO t2 VALUES (256,058304,37,'squabbled','strategic','suppliers','FAS');
299 INSERT INTO t2 VALUES (257,058602,37,'burlesque','gated','skips','');
300 INSERT INTO t2 VALUES (258,058603,37,'capped','flog','institutes','');
301 INSERT INTO t2 VALUES (259,058604,37,'extracted','Pipestone','troop','A');
302 INSERT INTO t2 VALUES (260,058605,37,'DiMaggio','Dar','connective','W');
303 INSERT INTO t2 VALUES (261,058606,37,'exclamation','Corcoran','denies','');
304 INSERT INTO t2 VALUES (262,058607,37,'subdirectory','flyers','polka','');
305 INSERT INTO t2 VALUES (263,060401,36,'fangs','competitions','observations','FAS');
306 INSERT INTO t2 VALUES (264,061701,36,'buyer','suppliers','askers','');
307 INSERT INTO t2 VALUES (265,066201,36,'pithing','skips','homeless','FAS');
308 INSERT INTO t2 VALUES (266,066501,36,'transistorizing','institutes','Anna','');
309 INSERT INTO t2 VALUES (267,068001,36,'nonbiodegradable','troop','subdirectories','W');
310 INSERT INTO t2 VALUES (268,068002,36,'dislocate','connective','decaying','FAS');
311 INSERT INTO t2 VALUES (269,068005,36,'monochromatic','denies','outwitting','W');
312 INSERT INTO t2 VALUES (270,068006,36,'batting','polka','Harpy','W');
313 INSERT INTO t2 VALUES (271,068007,36,'postcondition','observations','crazed','');
314 INSERT INTO t2 VALUES (272,068008,36,'catalog','askers','suffocate','');
315 INSERT INTO t2 VALUES (273,068009,36,'Remus','homeless','provers','FAS');
316 INSERT INTO t2 VALUES (274,068010,36,'devices','Anna','technically','');
317 INSERT INTO t2 VALUES (275,068011,36,'bike','subdirectories','Franklinizations','');
318 INSERT INTO t2 VALUES (276,068202,36,'qualify','decaying','considered','');
319 INSERT INTO t2 VALUES (277,068302,36,'detained','outwitting','tinnily','');
320 INSERT INTO t2 VALUES (278,068303,36,'commended','Harpy','uninterruptedly','');
321 INSERT INTO t2 VALUES (279,068401,36,'civilize','crazed','whistled','A');
322 INSERT INTO t2 VALUES (280,068501,36,'Elmhurst','suffocate','automate','');
323 INSERT INTO t2 VALUES (281,068502,36,'anesthetizing','provers','gutting','W');
324 INSERT INTO t2 VALUES (282,068503,36,'deaf','technically','surreptitious','');
325 INSERT INTO t2 VALUES (283,068602,36,'Brigham','Franklinizations','Choctaw','');
326 INSERT INTO t2 VALUES (284,068603,36,'title','considered','cooks','');
327 INSERT INTO t2 VALUES (285,068701,36,'coarse','tinnily','millivolt','FAS');
328 INSERT INTO t2 VALUES (286,068702,36,'combinations','uninterruptedly','counterpoise','');
329 INSERT INTO t2 VALUES (287,068703,36,'grayness','whistled','Gothicism','');
330 INSERT INTO t2 VALUES (288,076001,36,'innumerable','automate','feminine','');
331 INSERT INTO t2 VALUES (289,076002,36,'Caroline','gutting','metaphysically','W');
332 INSERT INTO t2 VALUES (290,076101,36,'fatty','surreptitious','sanding','A');
333 INSERT INTO t2 VALUES (291,076102,36,'eastbound','Choctaw','contributorily','');
334 INSERT INTO t2 VALUES (292,076103,36,'inexperienced','cooks','receivers','FAS');
335 INSERT INTO t2 VALUES (293,076302,36,'hoarder','millivolt','adjourn','');
336 INSERT INTO t2 VALUES (294,076303,36,'scotch','counterpoise','straggled','A');
337 INSERT INTO t2 VALUES (295,076304,36,'passport','Gothicism','druggists','');
338 INSERT INTO t2 VALUES (296,076305,36,'strategic','feminine','thanking','FAS');
339 INSERT INTO t2 VALUES (297,076306,36,'gated','metaphysically','ostrich','');
340 INSERT INTO t2 VALUES (298,076307,36,'flog','sanding','hopelessness','FAS');
341 INSERT INTO t2 VALUES (299,076402,36,'Pipestone','contributorily','Eurydice','');
342 INSERT INTO t2 VALUES (300,076501,36,'Dar','receivers','excitation','W');
343 INSERT INTO t2 VALUES (301,076502,36,'Corcoran','adjourn','presumes','FAS');
344 INSERT INTO t2 VALUES (302,076701,36,'flyers','straggled','imaginable','FAS');
345 INSERT INTO t2 VALUES (303,078001,36,'competitions','druggists','concoct','W');
346 INSERT INTO t2 VALUES (304,078002,36,'suppliers','thanking','peering','W');
347 INSERT INTO t2 VALUES (305,078003,36,'skips','ostrich','Phelps','FAS');
348 INSERT INTO t2 VALUES (306,078004,36,'institutes','hopelessness','ferociousness','FAS');
349 INSERT INTO t2 VALUES (307,078005,36,'troop','Eurydice','sentences','');
350 INSERT INTO t2 VALUES (308,078006,36,'connective','excitation','unlocks','');
351 INSERT INTO t2 VALUES (309,078007,36,'denies','presumes','engrossing','W');
352 INSERT INTO t2 VALUES (310,078008,36,'polka','imaginable','Ruth','');
353 INSERT INTO t2 VALUES (311,078101,36,'observations','concoct','tying','');
354 INSERT INTO t2 VALUES (312,078103,36,'askers','peering','exclaimers','');
355 INSERT INTO t2 VALUES (313,078104,36,'homeless','Phelps','synergy','');
356 INSERT INTO t2 VALUES (314,078105,36,'Anna','ferociousness','Huey','W');
357 INSERT INTO t2 VALUES (315,082101,36,'subdirectories','sentences','merging','');
358 INSERT INTO t2 VALUES (316,083401,36,'decaying','unlocks','judges','A');
359 INSERT INTO t2 VALUES (317,084001,36,'outwitting','engrossing','Shylock','W');
360 INSERT INTO t2 VALUES (318,084002,36,'Harpy','Ruth','Miltonism','');
361 INSERT INTO t2 VALUES (319,086001,36,'crazed','tying','hen','W');
362 INSERT INTO t2 VALUES (320,086102,36,'suffocate','exclaimers','honeybee','FAS');
363 INSERT INTO t2 VALUES (321,086201,36,'provers','synergy','towers','');
364 INSERT INTO t2 VALUES (322,088001,36,'technically','Huey','dilutes','W');
365 INSERT INTO t2 VALUES (323,088002,36,'Franklinizations','merging','numerals','FAS');
366 INSERT INTO t2 VALUES (324,088003,36,'considered','judges','democracy','FAS');
367 INSERT INTO t2 VALUES (325,088004,36,'tinnily','Shylock','Ibero-','');
368 INSERT INTO t2 VALUES (326,088101,36,'uninterruptedly','Miltonism','invalids','');
369 INSERT INTO t2 VALUES (327,088102,36,'whistled','hen','behavior','');
370 INSERT INTO t2 VALUES (328,088103,36,'automate','honeybee','accruing','');
371 INSERT INTO t2 VALUES (329,088104,36,'gutting','towers','relics','A');
372 INSERT INTO t2 VALUES (330,088105,36,'surreptitious','dilutes','rackets','');
373 INSERT INTO t2 VALUES (331,088106,36,'Choctaw','numerals','Fischbein','W');
374 INSERT INTO t2 VALUES (332,088201,36,'cooks','democracy','phony','W');
375 INSERT INTO t2 VALUES (333,088203,36,'millivolt','Ibero-','cross','FAS');
376 INSERT INTO t2 VALUES (334,088204,36,'counterpoise','invalids','cleanup','');
377 INSERT INTO t2 VALUES (335,088302,37,'Gothicism','behavior','conspirator','');
378 INSERT INTO t2 VALUES (336,088303,37,'feminine','accruing','label','FAS');
379 INSERT INTO t2 VALUES (337,088305,37,'metaphysically','relics','university','');
380 INSERT INTO t2 VALUES (338,088402,37,'sanding','rackets','cleansed','FAS');
381 INSERT INTO t2 VALUES (339,088501,36,'contributorily','Fischbein','ballgown','');
382 INSERT INTO t2 VALUES (340,088502,36,'receivers','phony','starlet','');
383 INSERT INTO t2 VALUES (341,088503,36,'adjourn','cross','aqueous','');
384 INSERT INTO t2 VALUES (342,098001,58,'straggled','cleanup','portrayal','A');
385 INSERT INTO t2 VALUES (343,098002,58,'druggists','conspirator','despising','W');
386 INSERT INTO t2 VALUES (344,098003,58,'thanking','label','distort','W');
387 INSERT INTO t2 VALUES (345,098004,58,'ostrich','university','palmed','');
388 INSERT INTO t2 VALUES (346,098005,58,'hopelessness','cleansed','faced','');
389 INSERT INTO t2 VALUES (347,098006,58,'Eurydice','ballgown','silverware','');
390 INSERT INTO t2 VALUES (348,141903,29,'excitation','starlet','assessor','');
391 INSERT INTO t2 VALUES (349,098008,58,'presumes','aqueous','spiders','');
392 INSERT INTO t2 VALUES (350,098009,58,'imaginable','portrayal','artificially','');
393 INSERT INTO t2 VALUES (351,098010,58,'concoct','despising','reminiscence','');
394 INSERT INTO t2 VALUES (352,098011,58,'peering','distort','Mexican','');
395 INSERT INTO t2 VALUES (353,098012,58,'Phelps','palmed','obnoxious','');
396 INSERT INTO t2 VALUES (354,098013,58,'ferociousness','faced','fragile','');
397 INSERT INTO t2 VALUES (355,098014,58,'sentences','silverware','apprehensible','');
398 INSERT INTO t2 VALUES (356,098015,58,'unlocks','assessor','births','');
399 INSERT INTO t2 VALUES (357,098016,58,'engrossing','spiders','garages','');
400 INSERT INTO t2 VALUES (358,098017,58,'Ruth','artificially','panty','');
401 INSERT INTO t2 VALUES (359,098018,58,'tying','reminiscence','anteater','');
402 INSERT INTO t2 VALUES (360,098019,58,'exclaimers','Mexican','displacement','A');
403 INSERT INTO t2 VALUES (361,098020,58,'synergy','obnoxious','drovers','A');
404 INSERT INTO t2 VALUES (362,098021,58,'Huey','fragile','patenting','A');
405 INSERT INTO t2 VALUES (363,098022,58,'merging','apprehensible','far','A');
406 INSERT INTO t2 VALUES (364,098023,58,'judges','births','shrieks','');
407 INSERT INTO t2 VALUES (365,098024,58,'Shylock','garages','aligning','W');
408 INSERT INTO t2 VALUES (366,098025,37,'Miltonism','panty','pragmatism','');
409 INSERT INTO t2 VALUES (367,106001,36,'hen','anteater','fevers','W');
410 INSERT INTO t2 VALUES (368,108001,36,'honeybee','displacement','reexamines','A');
411 INSERT INTO t2 VALUES (369,108002,36,'towers','drovers','occupancies','');
412 INSERT INTO t2 VALUES (370,108003,36,'dilutes','patenting','sweats','FAS');
413 INSERT INTO t2 VALUES (371,108004,36,'numerals','far','modulators','');
414 INSERT INTO t2 VALUES (372,108005,36,'democracy','shrieks','demand','W');
415 INSERT INTO t2 VALUES (373,108007,36,'Ibero-','aligning','Madeira','');
416 INSERT INTO t2 VALUES (374,108008,36,'invalids','pragmatism','Viennese','W');
417 INSERT INTO t2 VALUES (375,108009,36,'behavior','fevers','chillier','W');
418 INSERT INTO t2 VALUES (376,108010,36,'accruing','reexamines','wildcats','FAS');
419 INSERT INTO t2 VALUES (377,108011,36,'relics','occupancies','gentle','');
420 INSERT INTO t2 VALUES (378,108012,36,'rackets','sweats','Angles','W');
421 INSERT INTO t2 VALUES (379,108101,36,'Fischbein','modulators','accuracies','');
422 INSERT INTO t2 VALUES (380,108102,36,'phony','demand','toggle','');
423 INSERT INTO t2 VALUES (381,108103,36,'cross','Madeira','Mendelssohn','W');
424 INSERT INTO t2 VALUES (382,108111,50,'cleanup','Viennese','behaviorally','');
425 INSERT INTO t2 VALUES (383,108105,36,'conspirator','chillier','Rochford','');
426 INSERT INTO t2 VALUES (384,108106,36,'label','wildcats','mirror','W');
427 INSERT INTO t2 VALUES (385,108107,36,'university','gentle','Modula','');
428 INSERT INTO t2 VALUES (386,108108,50,'cleansed','Angles','clobbering','');
429 INSERT INTO t2 VALUES (387,108109,36,'ballgown','accuracies','chronography','');
430 INSERT INTO t2 VALUES (388,108110,36,'starlet','toggle','Eskimoizeds','');
431 INSERT INTO t2 VALUES (389,108201,36,'aqueous','Mendelssohn','British','W');
432 INSERT INTO t2 VALUES (390,108202,36,'portrayal','behaviorally','pitfalls','');
433 INSERT INTO t2 VALUES (391,108203,36,'despising','Rochford','verify','W');
434 INSERT INTO t2 VALUES (392,108204,36,'distort','mirror','scatter','FAS');
435 INSERT INTO t2 VALUES (393,108205,36,'palmed','Modula','Aztecan','');
436 INSERT INTO t2 VALUES (394,108301,36,'faced','clobbering','acuity','W');
437 INSERT INTO t2 VALUES (395,108302,36,'silverware','chronography','sinking','W');
438 INSERT INTO t2 VALUES (396,112101,36,'assessor','Eskimoizeds','beasts','FAS');
439 INSERT INTO t2 VALUES (397,112102,36,'spiders','British','Witt','W');
440 INSERT INTO t2 VALUES (398,113701,36,'artificially','pitfalls','physicists','FAS');
441 INSERT INTO t2 VALUES (399,116001,36,'reminiscence','verify','folksong','A');
442 INSERT INTO t2 VALUES (400,116201,36,'Mexican','scatter','strokes','FAS');
443 INSERT INTO t2 VALUES (401,116301,36,'obnoxious','Aztecan','crowder','');
444 INSERT INTO t2 VALUES (402,116302,36,'fragile','acuity','merry','');
445 INSERT INTO t2 VALUES (403,116601,36,'apprehensible','sinking','cadenced','');
446 INSERT INTO t2 VALUES (404,116602,36,'births','beasts','alimony','A');
447 INSERT INTO t2 VALUES (405,116603,36,'garages','Witt','principled','A');
448 INSERT INTO t2 VALUES (406,116701,36,'panty','physicists','golfing','');
449 INSERT INTO t2 VALUES (407,116702,36,'anteater','folksong','undiscovered','');
450 INSERT INTO t2 VALUES (408,118001,36,'displacement','strokes','irritates','');
451 INSERT INTO t2 VALUES (409,118002,36,'drovers','crowder','patriots','A');
452 INSERT INTO t2 VALUES (410,118003,36,'patenting','merry','rooms','FAS');
453 INSERT INTO t2 VALUES (411,118004,36,'far','cadenced','towering','W');
454 INSERT INTO t2 VALUES (412,118005,36,'shrieks','alimony','displease','');
455 INSERT INTO t2 VALUES (413,118006,36,'aligning','principled','photosensitive','');
456 INSERT INTO t2 VALUES (414,118007,36,'pragmatism','golfing','inking','');
457 INSERT INTO t2 VALUES (415,118008,36,'fevers','undiscovered','gainers','');
458 INSERT INTO t2 VALUES (416,118101,36,'reexamines','irritates','leaning','A');
459 INSERT INTO t2 VALUES (417,118102,36,'occupancies','patriots','hydrant','A');
460 INSERT INTO t2 VALUES (418,118103,36,'sweats','rooms','preserve','');
461 INSERT INTO t2 VALUES (419,118202,36,'modulators','towering','blinded','A');
462 INSERT INTO t2 VALUES (420,118203,36,'demand','displease','interactions','A');
463 INSERT INTO t2 VALUES (421,118204,36,'Madeira','photosensitive','Barry','');
464 INSERT INTO t2 VALUES (422,118302,36,'Viennese','inking','whiteness','A');
465 INSERT INTO t2 VALUES (423,118304,36,'chillier','gainers','pastimes','W');
466 INSERT INTO t2 VALUES (424,118305,36,'wildcats','leaning','Edenization','');
467 INSERT INTO t2 VALUES (425,118306,36,'gentle','hydrant','Muscat','');
468 INSERT INTO t2 VALUES (426,118307,36,'Angles','preserve','assassinated','');
469 INSERT INTO t2 VALUES (427,123101,36,'accuracies','blinded','labeled','');
470 INSERT INTO t2 VALUES (428,123102,36,'toggle','interactions','glacial','A');
471 INSERT INTO t2 VALUES (429,123301,36,'Mendelssohn','Barry','implied','W');
472 INSERT INTO t2 VALUES (430,126001,36,'behaviorally','whiteness','bibliographies','W');
473 INSERT INTO t2 VALUES (431,126002,36,'Rochford','pastimes','Buchanan','');
474 INSERT INTO t2 VALUES (432,126003,36,'mirror','Edenization','forgivably','FAS');
475 INSERT INTO t2 VALUES (433,126101,36,'Modula','Muscat','innuendo','A');
476 INSERT INTO t2 VALUES (434,126301,36,'clobbering','assassinated','den','FAS');
477 INSERT INTO t2 VALUES (435,126302,36,'chronography','labeled','submarines','W');
478 INSERT INTO t2 VALUES (436,126402,36,'Eskimoizeds','glacial','mouthful','A');
479 INSERT INTO t2 VALUES (437,126601,36,'British','implied','expiring','');
480 INSERT INTO t2 VALUES (438,126602,36,'pitfalls','bibliographies','unfulfilled','FAS');
481 INSERT INTO t2 VALUES (439,126702,36,'verify','Buchanan','precession','');
482 INSERT INTO t2 VALUES (440,128001,36,'scatter','forgivably','nullified','');
483 INSERT INTO t2 VALUES (441,128002,36,'Aztecan','innuendo','affects','');
484 INSERT INTO t2 VALUES (442,128003,36,'acuity','den','Cynthia','');
485 INSERT INTO t2 VALUES (443,128004,36,'sinking','submarines','Chablis','A');
486 INSERT INTO t2 VALUES (444,128005,36,'beasts','mouthful','betterments','FAS');
487 INSERT INTO t2 VALUES (445,128007,36,'Witt','expiring','advertising','');
488 INSERT INTO t2 VALUES (446,128008,36,'physicists','unfulfilled','rubies','A');
489 INSERT INTO t2 VALUES (447,128009,36,'folksong','precession','southwest','FAS');
490 INSERT INTO t2 VALUES (448,128010,36,'strokes','nullified','superstitious','A');
491 INSERT INTO t2 VALUES (449,128011,36,'crowder','affects','tabernacle','W');
492 INSERT INTO t2 VALUES (450,128012,36,'merry','Cynthia','silk','A');
493 INSERT INTO t2 VALUES (451,128013,36,'cadenced','Chablis','handsomest','A');
494 INSERT INTO t2 VALUES (452,128014,36,'alimony','betterments','Persian','A');
495 INSERT INTO t2 VALUES (453,128015,36,'principled','advertising','analog','W');
496 INSERT INTO t2 VALUES (454,128016,36,'golfing','rubies','complex','W');
497 INSERT INTO t2 VALUES (455,128017,36,'undiscovered','southwest','Taoist','');
498 INSERT INTO t2 VALUES (456,128018,36,'irritates','superstitious','suspend','');
499 INSERT INTO t2 VALUES (457,128019,36,'patriots','tabernacle','relegated','');
500 INSERT INTO t2 VALUES (458,128020,36,'rooms','silk','awesome','W');
501 INSERT INTO t2 VALUES (459,128021,36,'towering','handsomest','Bruxelles','');
502 INSERT INTO t2 VALUES (460,128022,36,'displease','Persian','imprecisely','A');
503 INSERT INTO t2 VALUES (461,128023,36,'photosensitive','analog','televise','');
504 INSERT INTO t2 VALUES (462,128101,36,'inking','complex','braking','');
505 INSERT INTO t2 VALUES (463,128102,36,'gainers','Taoist','true','FAS');
506 INSERT INTO t2 VALUES (464,128103,36,'leaning','suspend','disappointing','FAS');
507 INSERT INTO t2 VALUES (465,128104,36,'hydrant','relegated','navally','W');
508 INSERT INTO t2 VALUES (466,128106,36,'preserve','awesome','circus','');
509 INSERT INTO t2 VALUES (467,128107,36,'blinded','Bruxelles','beetles','');
510 INSERT INTO t2 VALUES (468,128108,36,'interactions','imprecisely','trumps','');
511 INSERT INTO t2 VALUES (469,128202,36,'Barry','televise','fourscore','W');
512 INSERT INTO t2 VALUES (470,128203,36,'whiteness','braking','Blackfoots','');
513 INSERT INTO t2 VALUES (471,128301,36,'pastimes','true','Grady','');
514 INSERT INTO t2 VALUES (472,128302,36,'Edenization','disappointing','quiets','FAS');
515 INSERT INTO t2 VALUES (473,128303,36,'Muscat','navally','floundered','FAS');
516 INSERT INTO t2 VALUES (474,128304,36,'assassinated','circus','profundity','W');
517 INSERT INTO t2 VALUES (475,128305,36,'labeled','beetles','Garrisonian','W');
518 INSERT INTO t2 VALUES (476,128307,36,'glacial','trumps','Strauss','');
519 INSERT INTO t2 VALUES (477,128401,36,'implied','fourscore','cemented','FAS');
520 INSERT INTO t2 VALUES (478,128502,36,'bibliographies','Blackfoots','contrition','A');
521 INSERT INTO t2 VALUES (479,128503,36,'Buchanan','Grady','mutations','');
522 INSERT INTO t2 VALUES (480,128504,36,'forgivably','quiets','exhibits','W');
523 INSERT INTO t2 VALUES (481,128505,36,'innuendo','floundered','tits','');
524 INSERT INTO t2 VALUES (482,128601,36,'den','profundity','mate','A');
525 INSERT INTO t2 VALUES (483,128603,36,'submarines','Garrisonian','arches','');
526 INSERT INTO t2 VALUES (484,128604,36,'mouthful','Strauss','Moll','');
527 INSERT INTO t2 VALUES (485,128702,36,'expiring','cemented','ropers','');
528 INSERT INTO t2 VALUES (486,128703,36,'unfulfilled','contrition','bombast','');
529 INSERT INTO t2 VALUES (487,128704,36,'precession','mutations','difficultly','A');
530 INSERT INTO t2 VALUES (488,138001,36,'nullified','exhibits','adsorption','');
531 INSERT INTO t2 VALUES (489,138002,36,'affects','tits','definiteness','FAS');
532 INSERT INTO t2 VALUES (490,138003,36,'Cynthia','mate','cultivation','A');
533 INSERT INTO t2 VALUES (491,138004,36,'Chablis','arches','heals','A');
534 INSERT INTO t2 VALUES (492,138005,36,'betterments','Moll','Heusen','W');
535 INSERT INTO t2 VALUES (493,138006,36,'advertising','ropers','target','FAS');
536 INSERT INTO t2 VALUES (494,138007,36,'rubies','bombast','cited','A');
537 INSERT INTO t2 VALUES (495,138008,36,'southwest','difficultly','congresswoman','W');
538 INSERT INTO t2 VALUES (496,138009,36,'superstitious','adsorption','Katherine','');
539 INSERT INTO t2 VALUES (497,138102,36,'tabernacle','definiteness','titter','A');
540 INSERT INTO t2 VALUES (498,138103,36,'silk','cultivation','aspire','A');
541 INSERT INTO t2 VALUES (499,138104,36,'handsomest','heals','Mardis','');
542 INSERT INTO t2 VALUES (500,138105,36,'Persian','Heusen','Nadia','W');
543 INSERT INTO t2 VALUES (501,138201,36,'analog','target','estimating','FAS');
544 INSERT INTO t2 VALUES (502,138302,36,'complex','cited','stuck','A');
545 INSERT INTO t2 VALUES (503,138303,36,'Taoist','congresswoman','fifteenth','A');
546 INSERT INTO t2 VALUES (504,138304,36,'suspend','Katherine','Colombo','');
547 INSERT INTO t2 VALUES (505,138401,29,'relegated','titter','survey','A');
548 INSERT INTO t2 VALUES (506,140102,29,'awesome','aspire','staffing','');
549 INSERT INTO t2 VALUES (507,140103,29,'Bruxelles','Mardis','obtain','');
550 INSERT INTO t2 VALUES (508,140104,29,'imprecisely','Nadia','loaded','');
551 INSERT INTO t2 VALUES (509,140105,29,'televise','estimating','slaughtered','');
552 INSERT INTO t2 VALUES (510,140201,29,'braking','stuck','lights','A');
553 INSERT INTO t2 VALUES (511,140701,29,'true','fifteenth','circumference','');
554 INSERT INTO t2 VALUES (512,141501,29,'disappointing','Colombo','dull','A');
555 INSERT INTO t2 VALUES (513,141502,29,'navally','survey','weekly','A');
556 INSERT INTO t2 VALUES (514,141901,29,'circus','staffing','wetness','');
557 INSERT INTO t2 VALUES (515,141902,29,'beetles','obtain','visualized','');
558 INSERT INTO t2 VALUES (516,142101,29,'trumps','loaded','Tannenbaum','');
559 INSERT INTO t2 VALUES (517,142102,29,'fourscore','slaughtered','moribund','');
560 INSERT INTO t2 VALUES (518,142103,29,'Blackfoots','lights','demultiplex','');
561 INSERT INTO t2 VALUES (519,142701,29,'Grady','circumference','lockings','');
562 INSERT INTO t2 VALUES (520,143001,29,'quiets','dull','thugs','FAS');
563 INSERT INTO t2 VALUES (521,143501,29,'floundered','weekly','unnerves','');
564 INSERT INTO t2 VALUES (522,143502,29,'profundity','wetness','abut','');
565 INSERT INTO t2 VALUES (523,148001,29,'Garrisonian','visualized','Chippewa','A');
566 INSERT INTO t2 VALUES (524,148002,29,'Strauss','Tannenbaum','stratifications','A');
567 INSERT INTO t2 VALUES (525,148003,29,'cemented','moribund','signaled','');
568 INSERT INTO t2 VALUES (526,148004,29,'contrition','demultiplex','Italianizes','A');
569 INSERT INTO t2 VALUES (527,148005,29,'mutations','lockings','algorithmic','A');
570 INSERT INTO t2 VALUES (528,148006,29,'exhibits','thugs','paranoid','FAS');
571 INSERT INTO t2 VALUES (529,148007,29,'tits','unnerves','camping','A');
572 INSERT INTO t2 VALUES (530,148009,29,'mate','abut','signifying','A');
573 INSERT INTO t2 VALUES (531,148010,29,'arches','Chippewa','Patrice','W');
574 INSERT INTO t2 VALUES (532,148011,29,'Moll','stratifications','search','A');
575 INSERT INTO t2 VALUES (533,148012,29,'ropers','signaled','Angeles','A');
576 INSERT INTO t2 VALUES (534,148013,29,'bombast','Italianizes','semblance','');
577 INSERT INTO t2 VALUES (535,148023,36,'difficultly','algorithmic','taxed','');
578 INSERT INTO t2 VALUES (536,148015,29,'adsorption','paranoid','Beatrice','');
579 INSERT INTO t2 VALUES (537,148016,29,'definiteness','camping','retrace','');
580 INSERT INTO t2 VALUES (538,148017,29,'cultivation','signifying','lockout','');
581 INSERT INTO t2 VALUES (539,148018,29,'heals','Patrice','grammatic','');
582 INSERT INTO t2 VALUES (540,148019,29,'Heusen','search','helmsman','');
583 INSERT INTO t2 VALUES (541,148020,29,'target','Angeles','uniform','W');
584 INSERT INTO t2 VALUES (542,148021,29,'cited','semblance','hamming','');
585 INSERT INTO t2 VALUES (543,148022,29,'congresswoman','taxed','disobedience','');
586 INSERT INTO t2 VALUES (544,148101,29,'Katherine','Beatrice','captivated','A');
587 INSERT INTO t2 VALUES (545,148102,29,'titter','retrace','transferals','A');
588 INSERT INTO t2 VALUES (546,148201,29,'aspire','lockout','cartographer','A');
589 INSERT INTO t2 VALUES (547,148401,29,'Mardis','grammatic','aims','FAS');
590 INSERT INTO t2 VALUES (548,148402,29,'Nadia','helmsman','Pakistani','');
591 INSERT INTO t2 VALUES (549,148501,29,'estimating','uniform','burglarized','FAS');
592 INSERT INTO t2 VALUES (550,148502,29,'stuck','hamming','saucepans','A');
593 INSERT INTO t2 VALUES (551,148503,29,'fifteenth','disobedience','lacerating','A');
594 INSERT INTO t2 VALUES (552,148504,29,'Colombo','captivated','corny','');
595 INSERT INTO t2 VALUES (553,148601,29,'survey','transferals','megabytes','FAS');
596 INSERT INTO t2 VALUES (554,148602,29,'staffing','cartographer','chancellor','');
597 INSERT INTO t2 VALUES (555,150701,29,'obtain','aims','bulk','A');
598 INSERT INTO t2 VALUES (556,152101,29,'loaded','Pakistani','commits','A');
599 INSERT INTO t2 VALUES (557,152102,29,'slaughtered','burglarized','meson','W');
600 INSERT INTO t2 VALUES (558,155202,36,'lights','saucepans','deputies','');
601 INSERT INTO t2 VALUES (559,155203,29,'circumference','lacerating','northeaster','A');
602 INSERT INTO t2 VALUES (560,155204,29,'dull','corny','dipole','');
603 INSERT INTO t2 VALUES (561,155205,29,'weekly','megabytes','machining','0');
604 INSERT INTO t2 VALUES (562,156001,29,'wetness','chancellor','therefore','');
605 INSERT INTO t2 VALUES (563,156002,29,'visualized','bulk','Telefunken','');
606 INSERT INTO t2 VALUES (564,156102,29,'Tannenbaum','commits','salvaging','');
607 INSERT INTO t2 VALUES (565,156301,29,'moribund','meson','Corinthianizes','A');
608 INSERT INTO t2 VALUES (566,156302,29,'demultiplex','deputies','restlessly','A');
609 INSERT INTO t2 VALUES (567,156303,29,'lockings','northeaster','bromides','');
610 INSERT INTO t2 VALUES (568,156304,29,'thugs','dipole','generalized','A');
611 INSERT INTO t2 VALUES (569,156305,29,'unnerves','machining','mishaps','');
612 INSERT INTO t2 VALUES (570,156306,29,'abut','therefore','quelling','');
613 INSERT INTO t2 VALUES (571,156501,29,'Chippewa','Telefunken','spiritual','A');
614 INSERT INTO t2 VALUES (572,158001,29,'stratifications','salvaging','beguiles','FAS');
615 INSERT INTO t2 VALUES (573,158002,29,'signaled','Corinthianizes','Trobriand','FAS');
616 INSERT INTO t2 VALUES (574,158101,29,'Italianizes','restlessly','fleeing','A');
617 INSERT INTO t2 VALUES (575,158102,29,'algorithmic','bromides','Armour','A');
618 INSERT INTO t2 VALUES (576,158103,29,'paranoid','generalized','chin','A');
619 INSERT INTO t2 VALUES (577,158201,29,'camping','mishaps','provers','A');
620 INSERT INTO t2 VALUES (578,158202,29,'signifying','quelling','aeronautic','A');
621 INSERT INTO t2 VALUES (579,158203,29,'Patrice','spiritual','voltage','W');
622 INSERT INTO t2 VALUES (580,158204,29,'search','beguiles','sash','');
623 INSERT INTO t2 VALUES (581,158301,29,'Angeles','Trobriand','anaerobic','A');
624 INSERT INTO t2 VALUES (582,158302,29,'semblance','fleeing','simultaneous','A');
625 INSERT INTO t2 VALUES (583,158303,29,'taxed','Armour','accumulating','A');
626 INSERT INTO t2 VALUES (584,158304,29,'Beatrice','chin','Medusan','A');
627 INSERT INTO t2 VALUES (585,158305,29,'retrace','provers','shouted','A');
628 INSERT INTO t2 VALUES (586,158306,29,'lockout','aeronautic','freakish','');
629 INSERT INTO t2 VALUES (587,158501,29,'grammatic','voltage','index','FAS');
630 INSERT INTO t2 VALUES (588,160301,29,'helmsman','sash','commercially','');
631 INSERT INTO t2 VALUES (589,166101,50,'uniform','anaerobic','mistiness','A');
632 INSERT INTO t2 VALUES (590,166102,50,'hamming','simultaneous','endpoint','');
633 INSERT INTO t2 VALUES (591,168001,29,'disobedience','accumulating','straight','A');
634 INSERT INTO t2 VALUES (592,168002,29,'captivated','Medusan','flurried','');
635 INSERT INTO t2 VALUES (593,168003,29,'transferals','shouted','denotative','A');
636 INSERT INTO t2 VALUES (594,168101,29,'cartographer','freakish','coming','FAS');
637 INSERT INTO t2 VALUES (595,168102,29,'aims','index','commencements','FAS');
638 INSERT INTO t2 VALUES (596,168103,29,'Pakistani','commercially','gentleman','');
639 INSERT INTO t2 VALUES (597,168104,29,'burglarized','mistiness','gifted','');
640 INSERT INTO t2 VALUES (598,168202,29,'saucepans','endpoint','Shanghais','');
641 INSERT INTO t2 VALUES (599,168301,29,'lacerating','straight','sportswriting','A');
642 INSERT INTO t2 VALUES (600,168502,29,'corny','flurried','sloping','A');
643 INSERT INTO t2 VALUES (601,168503,29,'megabytes','denotative','navies','');
644 INSERT INTO t2 VALUES (602,168601,29,'chancellor','coming','leaflet','A');
645 INSERT INTO t2 VALUES (603,173001,40,'bulk','commencements','shooter','');
646 INSERT INTO t2 VALUES (604,173701,40,'commits','gentleman','Joplin','FAS');
647 INSERT INTO t2 VALUES (605,173702,40,'meson','gifted','babies','');
648 INSERT INTO t2 VALUES (606,176001,40,'deputies','Shanghais','subdivision','FAS');
649 INSERT INTO t2 VALUES (607,176101,40,'northeaster','sportswriting','burstiness','W');
650 INSERT INTO t2 VALUES (608,176201,40,'dipole','sloping','belted','FAS');
651 INSERT INTO t2 VALUES (609,176401,40,'machining','navies','assails','FAS');
652 INSERT INTO t2 VALUES (610,176501,40,'therefore','leaflet','admiring','W');
653 INSERT INTO t2 VALUES (611,176601,40,'Telefunken','shooter','swaying','0');
654 INSERT INTO t2 VALUES (612,176602,40,'salvaging','Joplin','Goldstine','FAS');
655 INSERT INTO t2 VALUES (613,176603,40,'Corinthianizes','babies','fitting','');
656 INSERT INTO t2 VALUES (614,178001,40,'restlessly','subdivision','Norwalk','W');
657 INSERT INTO t2 VALUES (615,178002,40,'bromides','burstiness','weakening','W');
658 INSERT INTO t2 VALUES (616,178003,40,'generalized','belted','analogy','FAS');
659 INSERT INTO t2 VALUES (617,178004,40,'mishaps','assails','deludes','');
660 INSERT INTO t2 VALUES (618,178005,40,'quelling','admiring','cokes','');
661 INSERT INTO t2 VALUES (619,178006,40,'spiritual','swaying','Clayton','');
662 INSERT INTO t2 VALUES (620,178007,40,'beguiles','Goldstine','exhausts','');
663 INSERT INTO t2 VALUES (621,178008,40,'Trobriand','fitting','causality','');
664 INSERT INTO t2 VALUES (622,178101,40,'fleeing','Norwalk','sating','FAS');
665 INSERT INTO t2 VALUES (623,178102,40,'Armour','weakening','icon','');
666 INSERT INTO t2 VALUES (624,178103,40,'chin','analogy','throttles','');
667 INSERT INTO t2 VALUES (625,178201,40,'provers','deludes','communicants','FAS');
668 INSERT INTO t2 VALUES (626,178202,40,'aeronautic','cokes','dehydrate','FAS');
669 INSERT INTO t2 VALUES (627,178301,40,'voltage','Clayton','priceless','FAS');
670 INSERT INTO t2 VALUES (628,178302,40,'sash','exhausts','publicly','');
671 INSERT INTO t2 VALUES (629,178401,40,'anaerobic','causality','incidentals','FAS');
672 INSERT INTO t2 VALUES (630,178402,40,'simultaneous','sating','commonplace','');
673 INSERT INTO t2 VALUES (631,178403,40,'accumulating','icon','mumbles','');
674 INSERT INTO t2 VALUES (632,178404,40,'Medusan','throttles','furthermore','W');
675 INSERT INTO t2 VALUES (633,178501,40,'shouted','communicants','cautioned','W');
676 INSERT INTO t2 VALUES (634,186002,37,'freakish','dehydrate','parametrized','A');
677 INSERT INTO t2 VALUES (635,186102,37,'index','priceless','registration','A');
678 INSERT INTO t2 VALUES (636,186201,40,'commercially','publicly','sadly','FAS');
679 INSERT INTO t2 VALUES (637,186202,40,'mistiness','incidentals','positioning','');
680 INSERT INTO t2 VALUES (638,186203,40,'endpoint','commonplace','babysitting','');
681 INSERT INTO t2 VALUES (639,186302,37,'straight','mumbles','eternal','A');
682 INSERT INTO t2 VALUES (640,188007,37,'flurried','furthermore','hoarder','');
683 INSERT INTO t2 VALUES (641,188008,37,'denotative','cautioned','congregates','');
684 INSERT INTO t2 VALUES (642,188009,37,'coming','parametrized','rains','');
685 INSERT INTO t2 VALUES (643,188010,37,'commencements','registration','workers','W');
686 INSERT INTO t2 VALUES (644,188011,37,'gentleman','sadly','sags','A');
687 INSERT INTO t2 VALUES (645,188012,37,'gifted','positioning','unplug','W');
688 INSERT INTO t2 VALUES (646,188013,37,'Shanghais','babysitting','garage','A');
689 INSERT INTO t2 VALUES (647,188014,37,'sportswriting','eternal','boulder','A');
690 INSERT INTO t2 VALUES (648,188015,37,'sloping','hoarder','hollowly','A');
691 INSERT INTO t2 VALUES (649,188016,37,'navies','congregates','specifics','');
692 INSERT INTO t2 VALUES (650,188017,37,'leaflet','rains','Teresa','');
693 INSERT INTO t2 VALUES (651,188102,37,'shooter','workers','Winsett','');
694 INSERT INTO t2 VALUES (652,188103,37,'Joplin','sags','convenient','A');
695 INSERT INTO t2 VALUES (653,188202,37,'babies','unplug','buckboards','FAS');
696 INSERT INTO t2 VALUES (654,188301,40,'subdivision','garage','amenities','');
697 INSERT INTO t2 VALUES (655,188302,40,'burstiness','boulder','resplendent','FAS');
698 INSERT INTO t2 VALUES (656,188303,40,'belted','hollowly','priding','FAS');
699 INSERT INTO t2 VALUES (657,188401,37,'assails','specifics','configurations','');
700 INSERT INTO t2 VALUES (658,188402,37,'admiring','Teresa','untidiness','A');
701 INSERT INTO t2 VALUES (659,188503,37,'swaying','Winsett','Brice','W');
702 INSERT INTO t2 VALUES (660,188504,37,'Goldstine','convenient','sews','FAS');
703 INSERT INTO t2 VALUES (661,188505,37,'fitting','buckboards','participated','');
704 INSERT INTO t2 VALUES (662,190701,37,'Norwalk','amenities','Simon','FAS');
705 INSERT INTO t2 VALUES (663,190703,50,'weakening','resplendent','certificates','');
706 INSERT INTO t2 VALUES (664,191701,37,'analogy','priding','Fitzpatrick','');
707 INSERT INTO t2 VALUES (665,191702,37,'deludes','configurations','Evanston','A');
708 INSERT INTO t2 VALUES (666,191703,37,'cokes','untidiness','misted','');
709 INSERT INTO t2 VALUES (667,196001,37,'Clayton','Brice','textures','A');
710 INSERT INTO t2 VALUES (668,196002,37,'exhausts','sews','save','');
711 INSERT INTO t2 VALUES (669,196003,37,'causality','participated','count','');
712 INSERT INTO t2 VALUES (670,196101,37,'sating','Simon','rightful','A');
713 INSERT INTO t2 VALUES (671,196103,37,'icon','certificates','chaperone','');
714 INSERT INTO t2 VALUES (672,196104,37,'throttles','Fitzpatrick','Lizzy','A');
715 INSERT INTO t2 VALUES (673,196201,37,'communicants','Evanston','clenched','A');
716 INSERT INTO t2 VALUES (674,196202,37,'dehydrate','misted','effortlessly','');
717 INSERT INTO t2 VALUES (675,196203,37,'priceless','textures','accessed','');
718 INSERT INTO t2 VALUES (676,198001,37,'publicly','save','beaters','A');
719 INSERT INTO t2 VALUES (677,198003,37,'incidentals','count','Hornblower','FAS');
720 INSERT INTO t2 VALUES (678,198004,37,'commonplace','rightful','vests','A');
721 INSERT INTO t2 VALUES (679,198005,37,'mumbles','chaperone','indulgences','FAS');
722 INSERT INTO t2 VALUES (680,198006,37,'furthermore','Lizzy','infallibly','A');
723 INSERT INTO t2 VALUES (681,198007,37,'cautioned','clenched','unwilling','FAS');
724 INSERT INTO t2 VALUES (682,198008,37,'parametrized','effortlessly','excrete','FAS');
725 INSERT INTO t2 VALUES (683,198009,37,'registration','accessed','spools','A');
726 INSERT INTO t2 VALUES (684,198010,37,'sadly','beaters','crunches','FAS');
727 INSERT INTO t2 VALUES (685,198011,37,'positioning','Hornblower','overestimating','FAS');
728 INSERT INTO t2 VALUES (686,198012,37,'babysitting','vests','ineffective','');
729 INSERT INTO t2 VALUES (687,198013,37,'eternal','indulgences','humiliation','A');
730 INSERT INTO t2 VALUES (688,198014,37,'hoarder','infallibly','sophomore','');
731 INSERT INTO t2 VALUES (689,198015,37,'congregates','unwilling','star','');
732 INSERT INTO t2 VALUES (690,198017,37,'rains','excrete','rifles','');
733 INSERT INTO t2 VALUES (691,198018,37,'workers','spools','dialysis','');
734 INSERT INTO t2 VALUES (692,198019,37,'sags','crunches','arriving','');
735 INSERT INTO t2 VALUES (693,198020,37,'unplug','overestimating','indulge','');
736 INSERT INTO t2 VALUES (694,198021,37,'garage','ineffective','clockers','');
737 INSERT INTO t2 VALUES (695,198022,37,'boulder','humiliation','languages','');
738 INSERT INTO t2 VALUES (696,198023,50,'hollowly','sophomore','Antarctica','A');
739 INSERT INTO t2 VALUES (697,198024,37,'specifics','star','percentage','');
740 INSERT INTO t2 VALUES (698,198101,37,'Teresa','rifles','ceiling','A');
741 INSERT INTO t2 VALUES (699,198103,37,'Winsett','dialysis','specification','');
742 INSERT INTO t2 VALUES (700,198105,37,'convenient','arriving','regimented','A');
743 INSERT INTO t2 VALUES (701,198106,37,'buckboards','indulge','ciphers','');
744 INSERT INTO t2 VALUES (702,198201,37,'amenities','clockers','pictures','A');
745 INSERT INTO t2 VALUES (703,198204,37,'resplendent','languages','serpents','A');
746 INSERT INTO t2 VALUES (704,198301,53,'priding','Antarctica','allot','A');
747 INSERT INTO t2 VALUES (705,198302,53,'configurations','percentage','realized','A');
748 INSERT INTO t2 VALUES (706,198303,53,'untidiness','ceiling','mayoral','A');
749 INSERT INTO t2 VALUES (707,198304,53,'Brice','specification','opaquely','A');
750 INSERT INTO t2 VALUES (708,198401,37,'sews','regimented','hostess','FAS');
751 INSERT INTO t2 VALUES (709,198402,37,'participated','ciphers','fiftieth','');
752 INSERT INTO t2 VALUES (710,198403,37,'Simon','pictures','incorrectly','');
753 INSERT INTO t2 VALUES (711,202101,37,'certificates','serpents','decomposition','FAS');
754 INSERT INTO t2 VALUES (712,202301,37,'Fitzpatrick','allot','stranglings','');
755 INSERT INTO t2 VALUES (713,202302,37,'Evanston','realized','mixture','FAS');
756 INSERT INTO t2 VALUES (714,202303,37,'misted','mayoral','electroencephalography','FAS');
757 INSERT INTO t2 VALUES (715,202304,37,'textures','opaquely','similarities','FAS');
758 INSERT INTO t2 VALUES (716,202305,37,'save','hostess','charges','W');
759 INSERT INTO t2 VALUES (717,202601,37,'count','fiftieth','freest','FAS');
760 INSERT INTO t2 VALUES (718,202602,37,'rightful','incorrectly','Greenberg','FAS');
761 INSERT INTO t2 VALUES (719,202605,37,'chaperone','decomposition','tinting','');
762 INSERT INTO t2 VALUES (720,202606,37,'Lizzy','stranglings','expelled','W');
763 INSERT INTO t2 VALUES (721,202607,37,'clenched','mixture','warm','');
764 INSERT INTO t2 VALUES (722,202901,37,'effortlessly','electroencephalography','smoothed','');
765 INSERT INTO t2 VALUES (723,202902,37,'accessed','similarities','deductions','FAS');
766 INSERT INTO t2 VALUES (724,202903,37,'beaters','charges','Romano','W');
767 INSERT INTO t2 VALUES (725,202904,37,'Hornblower','freest','bitterroot','');
768 INSERT INTO t2 VALUES (726,202907,37,'vests','Greenberg','corset','');
769 INSERT INTO t2 VALUES (727,202908,37,'indulgences','tinting','securing','');
770 INSERT INTO t2 VALUES (728,203101,37,'infallibly','expelled','environing','FAS');
771 INSERT INTO t2 VALUES (729,203103,37,'unwilling','warm','cute','');
772 INSERT INTO t2 VALUES (730,203104,37,'excrete','smoothed','Crays','');
773 INSERT INTO t2 VALUES (731,203105,37,'spools','deductions','heiress','FAS');
774 INSERT INTO t2 VALUES (732,203401,37,'crunches','Romano','inform','FAS');
775 INSERT INTO t2 VALUES (733,203402,37,'overestimating','bitterroot','avenge','');
776 INSERT INTO t2 VALUES (734,203404,37,'ineffective','corset','universals','');
777 INSERT INTO t2 VALUES (735,203901,37,'humiliation','securing','Kinsey','W');
778 INSERT INTO t2 VALUES (736,203902,37,'sophomore','environing','ravines','FAS');
779 INSERT INTO t2 VALUES (737,203903,37,'star','cute','bestseller','');
780 INSERT INTO t2 VALUES (738,203906,37,'rifles','Crays','equilibrium','');
781 INSERT INTO t2 VALUES (739,203907,37,'dialysis','heiress','extents','0');
782 INSERT INTO t2 VALUES (740,203908,37,'arriving','inform','relatively','');
783 INSERT INTO t2 VALUES (741,203909,37,'indulge','avenge','pressure','FAS');
784 INSERT INTO t2 VALUES (742,206101,37,'clockers','universals','critiques','FAS');
785 INSERT INTO t2 VALUES (743,206201,37,'languages','Kinsey','befouled','');
786 INSERT INTO t2 VALUES (744,206202,37,'Antarctica','ravines','rightfully','FAS');
787 INSERT INTO t2 VALUES (745,206203,37,'percentage','bestseller','mechanizing','FAS');
788 INSERT INTO t2 VALUES (746,206206,37,'ceiling','equilibrium','Latinizes','');
789 INSERT INTO t2 VALUES (747,206207,37,'specification','extents','timesharing','');
790 INSERT INTO t2 VALUES (748,206208,37,'regimented','relatively','Aden','');
791 INSERT INTO t2 VALUES (749,208001,37,'ciphers','pressure','embassies','');
792 INSERT INTO t2 VALUES (750,208002,37,'pictures','critiques','males','FAS');
793 INSERT INTO t2 VALUES (751,208003,37,'serpents','befouled','shapelessly','FAS');
794 INSERT INTO t2 VALUES (752,208004,37,'allot','rightfully','genres','FAS');
795 INSERT INTO t2 VALUES (753,208008,37,'realized','mechanizing','mastering','');
796 INSERT INTO t2 VALUES (754,208009,37,'mayoral','Latinizes','Newtonian','');
797 INSERT INTO t2 VALUES (755,208010,37,'opaquely','timesharing','finishers','FAS');
798 INSERT INTO t2 VALUES (756,208011,37,'hostess','Aden','abates','');
799 INSERT INTO t2 VALUES (757,208101,37,'fiftieth','embassies','teem','');
800 INSERT INTO t2 VALUES (758,208102,37,'incorrectly','males','kiting','FAS');
801 INSERT INTO t2 VALUES (759,208103,37,'decomposition','shapelessly','stodgy','FAS');
802 INSERT INTO t2 VALUES (760,208104,37,'stranglings','genres','scalps','FAS');
803 INSERT INTO t2 VALUES (761,208105,37,'mixture','mastering','feed','FAS');
804 INSERT INTO t2 VALUES (762,208110,37,'electroencephalography','Newtonian','guitars','');
805 INSERT INTO t2 VALUES (763,208111,37,'similarities','finishers','airships','');
806 INSERT INTO t2 VALUES (764,208112,37,'charges','abates','store','');
807 INSERT INTO t2 VALUES (765,208113,37,'freest','teem','denounces','');
808 INSERT INTO t2 VALUES (766,208201,37,'Greenberg','kiting','Pyle','FAS');
809 INSERT INTO t2 VALUES (767,208203,37,'tinting','stodgy','Saxony','');
810 INSERT INTO t2 VALUES (768,208301,37,'expelled','scalps','serializations','FAS');
811 INSERT INTO t2 VALUES (769,208302,37,'warm','feed','Peruvian','FAS');
812 INSERT INTO t2 VALUES (770,208305,37,'smoothed','guitars','taxonomically','FAS');
813 INSERT INTO t2 VALUES (771,208401,37,'deductions','airships','kingdom','A');
814 INSERT INTO t2 VALUES (772,208402,37,'Romano','store','stint','A');
815 INSERT INTO t2 VALUES (773,208403,37,'bitterroot','denounces','Sault','A');
816 INSERT INTO t2 VALUES (774,208404,37,'corset','Pyle','faithful','');
817 INSERT INTO t2 VALUES (775,208501,37,'securing','Saxony','Ganymede','FAS');
818 INSERT INTO t2 VALUES (776,208502,37,'environing','serializations','tidiness','FAS');
819 INSERT INTO t2 VALUES (777,208503,37,'cute','Peruvian','gainful','FAS');
820 INSERT INTO t2 VALUES (778,208504,37,'Crays','taxonomically','contrary','FAS');
821 INSERT INTO t2 VALUES (779,208505,37,'heiress','kingdom','Tipperary','FAS');
822 INSERT INTO t2 VALUES (780,210101,37,'inform','stint','tropics','W');
823 INSERT INTO t2 VALUES (781,210102,37,'avenge','Sault','theorizers','');
824 INSERT INTO t2 VALUES (782,210103,37,'universals','faithful','renew','0');
825 INSERT INTO t2 VALUES (783,210104,37,'Kinsey','Ganymede','already','');
826 INSERT INTO t2 VALUES (784,210105,37,'ravines','tidiness','terminal','');
827 INSERT INTO t2 VALUES (785,210106,37,'bestseller','gainful','Hegelian','');
828 INSERT INTO t2 VALUES (786,210107,37,'equilibrium','contrary','hypothesizer','');
829 INSERT INTO t2 VALUES (787,210401,37,'extents','Tipperary','warningly','FAS');
830 INSERT INTO t2 VALUES (788,213201,37,'relatively','tropics','journalizing','FAS');
831 INSERT INTO t2 VALUES (789,213203,37,'pressure','theorizers','nested','');
832 INSERT INTO t2 VALUES (790,213204,37,'critiques','renew','Lars','');
833 INSERT INTO t2 VALUES (791,213205,37,'befouled','already','saplings','');
834 INSERT INTO t2 VALUES (792,213206,37,'rightfully','terminal','foothill','');
835 INSERT INTO t2 VALUES (793,213207,37,'mechanizing','Hegelian','labeled','');
836 INSERT INTO t2 VALUES (794,216101,37,'Latinizes','hypothesizer','imperiously','FAS');
837 INSERT INTO t2 VALUES (795,216103,37,'timesharing','warningly','reporters','FAS');
838 INSERT INTO t2 VALUES (796,218001,37,'Aden','journalizing','furnishings','FAS');
839 INSERT INTO t2 VALUES (797,218002,37,'embassies','nested','precipitable','FAS');
840 INSERT INTO t2 VALUES (798,218003,37,'males','Lars','discounts','FAS');
841 INSERT INTO t2 VALUES (799,218004,37,'shapelessly','saplings','excises','FAS');
842 INSERT INTO t2 VALUES (800,143503,50,'genres','foothill','Stalin','');
843 INSERT INTO t2 VALUES (801,218006,37,'mastering','labeled','despot','FAS');
844 INSERT INTO t2 VALUES (802,218007,37,'Newtonian','imperiously','ripeness','FAS');
845 INSERT INTO t2 VALUES (803,218008,37,'finishers','reporters','Arabia','');
846 INSERT INTO t2 VALUES (804,218009,37,'abates','furnishings','unruly','');
847 INSERT INTO t2 VALUES (805,218010,37,'teem','precipitable','mournfulness','');
848 INSERT INTO t2 VALUES (806,218011,37,'kiting','discounts','boom','FAS');
849 INSERT INTO t2 VALUES (807,218020,37,'stodgy','excises','slaughter','A');
850 INSERT INTO t2 VALUES (808,218021,50,'scalps','Stalin','Sabine','');
851 INSERT INTO t2 VALUES (809,218022,37,'feed','despot','handy','FAS');
852 INSERT INTO t2 VALUES (810,218023,37,'guitars','ripeness','rural','');
853 INSERT INTO t2 VALUES (811,218024,37,'airships','Arabia','organizer','');
854 INSERT INTO t2 VALUES (812,218101,37,'store','unruly','shipyard','FAS');
855 INSERT INTO t2 VALUES (813,218102,37,'denounces','mournfulness','civics','FAS');
856 INSERT INTO t2 VALUES (814,218103,37,'Pyle','boom','inaccuracy','FAS');
857 INSERT INTO t2 VALUES (815,218201,37,'Saxony','slaughter','rules','FAS');
858 INSERT INTO t2 VALUES (816,218202,37,'serializations','Sabine','juveniles','FAS');
859 INSERT INTO t2 VALUES (817,218203,37,'Peruvian','handy','comprised','W');
860 INSERT INTO t2 VALUES (818,218204,37,'taxonomically','rural','investigations','');
861 INSERT INTO t2 VALUES (819,218205,37,'kingdom','organizer','stabilizes','A');
862 INSERT INTO t2 VALUES (820,218301,37,'stint','shipyard','seminaries','FAS');
863 INSERT INTO t2 VALUES (821,218302,37,'Sault','civics','Hunter','A');
864 INSERT INTO t2 VALUES (822,218401,37,'faithful','inaccuracy','sporty','FAS');
865 INSERT INTO t2 VALUES (823,218402,37,'Ganymede','rules','test','FAS');
866 INSERT INTO t2 VALUES (824,218403,37,'tidiness','juveniles','weasels','');
867 INSERT INTO t2 VALUES (825,218404,37,'gainful','comprised','CERN','');
868 INSERT INTO t2 VALUES (826,218407,37,'contrary','investigations','tempering','');
869 INSERT INTO t2 VALUES (827,218408,37,'Tipperary','stabilizes','afore','FAS');
870 INSERT INTO t2 VALUES (828,218409,37,'tropics','seminaries','Galatean','');
871 INSERT INTO t2 VALUES (829,218410,37,'theorizers','Hunter','techniques','W');
872 INSERT INTO t2 VALUES (830,226001,37,'renew','sporty','error','');
873 INSERT INTO t2 VALUES (831,226002,37,'already','test','veranda','');
874 INSERT INTO t2 VALUES (832,226003,37,'terminal','weasels','severely','');
875 INSERT INTO t2 VALUES (833,226004,37,'Hegelian','CERN','Cassites','FAS');
876 INSERT INTO t2 VALUES (834,226005,37,'hypothesizer','tempering','forthcoming','');
877 INSERT INTO t2 VALUES (835,226006,37,'warningly','afore','guides','');
878 INSERT INTO t2 VALUES (836,226007,37,'journalizing','Galatean','vanish','FAS');
879 INSERT INTO t2 VALUES (837,226008,37,'nested','techniques','lied','A');
880 INSERT INTO t2 VALUES (838,226203,37,'Lars','error','sawtooth','FAS');
881 INSERT INTO t2 VALUES (839,226204,37,'saplings','veranda','fated','FAS');
882 INSERT INTO t2 VALUES (840,226205,37,'foothill','severely','gradually','');
883 INSERT INTO t2 VALUES (841,226206,37,'labeled','Cassites','widens','');
884 INSERT INTO t2 VALUES (842,226207,37,'imperiously','forthcoming','preclude','');
885 INSERT INTO t2 VALUES (843,226208,37,'reporters','guides','Jobrel','');
886 INSERT INTO t2 VALUES (844,226209,37,'furnishings','vanish','hooker','');
887 INSERT INTO t2 VALUES (845,226210,37,'precipitable','lied','rainstorm','');
888 INSERT INTO t2 VALUES (846,226211,37,'discounts','sawtooth','disconnects','');
889 INSERT INTO t2 VALUES (847,228001,37,'excises','fated','cruelty','');
890 INSERT INTO t2 VALUES (848,228004,37,'Stalin','gradually','exponentials','A');
891 INSERT INTO t2 VALUES (849,228005,37,'despot','widens','affective','A');
892 INSERT INTO t2 VALUES (850,228006,37,'ripeness','preclude','arteries','');
893 INSERT INTO t2 VALUES (851,228007,37,'Arabia','Jobrel','Crosby','FAS');
894 INSERT INTO t2 VALUES (852,228008,37,'unruly','hooker','acquaint','');
895 INSERT INTO t2 VALUES (853,228009,37,'mournfulness','rainstorm','evenhandedly','');
896 INSERT INTO t2 VALUES (854,228101,37,'boom','disconnects','percentage','');
897 INSERT INTO t2 VALUES (855,228108,37,'slaughter','cruelty','disobedience','');
898 INSERT INTO t2 VALUES (856,228109,37,'Sabine','exponentials','humility','');
899 INSERT INTO t2 VALUES (857,228110,37,'handy','affective','gleaning','A');
900 INSERT INTO t2 VALUES (858,228111,37,'rural','arteries','petted','A');
901 INSERT INTO t2 VALUES (859,228112,37,'organizer','Crosby','bloater','A');
902 INSERT INTO t2 VALUES (860,228113,37,'shipyard','acquaint','minion','A');
903 INSERT INTO t2 VALUES (861,228114,37,'civics','evenhandedly','marginal','A');
904 INSERT INTO t2 VALUES (862,228115,37,'inaccuracy','percentage','apiary','A');
905 INSERT INTO t2 VALUES (863,228116,37,'rules','disobedience','measures','');
906 INSERT INTO t2 VALUES (864,228117,37,'juveniles','humility','precaution','');
907 INSERT INTO t2 VALUES (865,228118,37,'comprised','gleaning','repelled','');
908 INSERT INTO t2 VALUES (866,228119,37,'investigations','petted','primary','FAS');
909 INSERT INTO t2 VALUES (867,228120,37,'stabilizes','bloater','coverings','');
910 INSERT INTO t2 VALUES (868,228121,37,'seminaries','minion','Artemia','A');
911 INSERT INTO t2 VALUES (869,228122,37,'Hunter','marginal','navigate','');
912 INSERT INTO t2 VALUES (870,228201,37,'sporty','apiary','spatial','');
913 INSERT INTO t2 VALUES (871,228206,37,'test','measures','Gurkha','');
914 INSERT INTO t2 VALUES (872,228207,37,'weasels','precaution','meanwhile','A');
915 INSERT INTO t2 VALUES (873,228208,37,'CERN','repelled','Melinda','A');
916 INSERT INTO t2 VALUES (874,228209,37,'tempering','primary','Butterfield','');
917 INSERT INTO t2 VALUES (875,228210,37,'afore','coverings','Aldrich','A');
918 INSERT INTO t2 VALUES (876,228211,37,'Galatean','Artemia','previewing','A');
919 INSERT INTO t2 VALUES (877,228212,37,'techniques','navigate','glut','A');
920 INSERT INTO t2 VALUES (878,228213,37,'error','spatial','unaffected','');
921 INSERT INTO t2 VALUES (879,228214,37,'veranda','Gurkha','inmate','');
922 INSERT INTO t2 VALUES (880,228301,37,'severely','meanwhile','mineral','');
923 INSERT INTO t2 VALUES (881,228305,37,'Cassites','Melinda','impending','A');
924 INSERT INTO t2 VALUES (882,228306,37,'forthcoming','Butterfield','meditation','A');
925 INSERT INTO t2 VALUES (883,228307,37,'guides','Aldrich','ideas','');
926 INSERT INTO t2 VALUES (884,228308,37,'vanish','previewing','miniaturizes','W');
927 INSERT INTO t2 VALUES (885,228309,37,'lied','glut','lewdly','');
928 INSERT INTO t2 VALUES (886,228310,37,'sawtooth','unaffected','title','');
929 INSERT INTO t2 VALUES (887,228311,37,'fated','inmate','youthfulness','');
930 INSERT INTO t2 VALUES (888,228312,37,'gradually','mineral','creak','FAS');
931 INSERT INTO t2 VALUES (889,228313,37,'widens','impending','Chippewa','');
932 INSERT INTO t2 VALUES (890,228314,37,'preclude','meditation','clamored','');
933 INSERT INTO t2 VALUES (891,228401,65,'Jobrel','ideas','freezes','');
934 INSERT INTO t2 VALUES (892,228402,65,'hooker','miniaturizes','forgivably','FAS');
935 INSERT INTO t2 VALUES (893,228403,65,'rainstorm','lewdly','reduce','FAS');
936 INSERT INTO t2 VALUES (894,228404,65,'disconnects','title','McGovern','W');
937 INSERT INTO t2 VALUES (895,228405,65,'cruelty','youthfulness','Nazis','W');
938 INSERT INTO t2 VALUES (896,228406,65,'exponentials','creak','epistle','W');
939 INSERT INTO t2 VALUES (897,228407,65,'affective','Chippewa','socializes','W');
940 INSERT INTO t2 VALUES (898,228408,65,'arteries','clamored','conceptions','');
941 INSERT INTO t2 VALUES (899,228409,65,'Crosby','freezes','Kevin','');
942 INSERT INTO t2 VALUES (900,228410,65,'acquaint','forgivably','uncovering','');
943 INSERT INTO t2 VALUES (901,230301,37,'evenhandedly','reduce','chews','FAS');
944 INSERT INTO t2 VALUES (902,230302,37,'percentage','McGovern','appendixes','FAS');
945 INSERT INTO t2 VALUES (903,230303,37,'disobedience','Nazis','raining','');
946 INSERT INTO t2 VALUES (904,018062,37,'humility','epistle','infest','');
947 INSERT INTO t2 VALUES (905,230501,37,'gleaning','socializes','compartment','');
948 INSERT INTO t2 VALUES (906,230502,37,'petted','conceptions','minting','');
949 INSERT INTO t2 VALUES (907,230503,37,'bloater','Kevin','ducks','');
950 INSERT INTO t2 VALUES (908,230504,37,'minion','uncovering','roped','A');
951 INSERT INTO t2 VALUES (909,230505,37,'marginal','chews','waltz','');
952 INSERT INTO t2 VALUES (910,230506,37,'apiary','appendixes','Lillian','');
953 INSERT INTO t2 VALUES (911,230507,37,'measures','raining','repressions','A');
954 INSERT INTO t2 VALUES (912,230508,37,'precaution','infest','chillingly','');
955 INSERT INTO t2 VALUES (913,230509,37,'repelled','compartment','noncritical','');
956 INSERT INTO t2 VALUES (914,230901,37,'primary','minting','lithograph','');
957 INSERT INTO t2 VALUES (915,230902,37,'coverings','ducks','spongers','');
958 INSERT INTO t2 VALUES (916,230903,37,'Artemia','roped','parenthood','');
959 INSERT INTO t2 VALUES (917,230904,37,'navigate','waltz','posed','');
960 INSERT INTO t2 VALUES (918,230905,37,'spatial','Lillian','instruments','');
961 INSERT INTO t2 VALUES (919,230906,37,'Gurkha','repressions','filial','');
962 INSERT INTO t2 VALUES (920,230907,37,'meanwhile','chillingly','fixedly','');
963 INSERT INTO t2 VALUES (921,230908,37,'Melinda','noncritical','relives','');
964 INSERT INTO t2 VALUES (922,230909,37,'Butterfield','lithograph','Pandora','');
965 INSERT INTO t2 VALUES (923,230910,37,'Aldrich','spongers','watering','A');
966 INSERT INTO t2 VALUES (924,230911,37,'previewing','parenthood','ungrateful','');
967 INSERT INTO t2 VALUES (925,230912,37,'glut','posed','secures','');
968 INSERT INTO t2 VALUES (926,230913,37,'unaffected','instruments','chastisers','');
969 INSERT INTO t2 VALUES (927,230914,37,'inmate','filial','icon','');
970 INSERT INTO t2 VALUES (928,231304,37,'mineral','fixedly','reuniting','A');
971 INSERT INTO t2 VALUES (929,231305,37,'impending','relives','imagining','A');
972 INSERT INTO t2 VALUES (930,231306,37,'meditation','Pandora','abiding','A');
973 INSERT INTO t2 VALUES (931,231307,37,'ideas','watering','omnisciently','');
974 INSERT INTO t2 VALUES (932,231308,37,'miniaturizes','ungrateful','Britannic','');
975 INSERT INTO t2 VALUES (933,231309,37,'lewdly','secures','scholastics','A');
976 INSERT INTO t2 VALUES (934,231310,37,'title','chastisers','mechanics','A');
977 INSERT INTO t2 VALUES (935,231311,37,'youthfulness','icon','humidly','A');
978 INSERT INTO t2 VALUES (936,231312,37,'creak','reuniting','masterpiece','');
979 INSERT INTO t2 VALUES (937,231313,37,'Chippewa','imagining','however','');
980 INSERT INTO t2 VALUES (938,231314,37,'clamored','abiding','Mendelian','');
981 INSERT INTO t2 VALUES (939,231315,37,'freezes','omnisciently','jarred','');
982 INSERT INTO t2 VALUES (940,232102,37,'forgivably','Britannic','scolds','');
983 INSERT INTO t2 VALUES (941,232103,37,'reduce','scholastics','infatuate','');
984 INSERT INTO t2 VALUES (942,232104,37,'McGovern','mechanics','willed','A');
985 INSERT INTO t2 VALUES (943,232105,37,'Nazis','humidly','joyfully','');
986 INSERT INTO t2 VALUES (944,232106,37,'epistle','masterpiece','Microsoft','');
987 INSERT INTO t2 VALUES (945,232107,37,'socializes','however','fibrosities','');
988 INSERT INTO t2 VALUES (946,232108,37,'conceptions','Mendelian','Baltimorean','');
989 INSERT INTO t2 VALUES (947,232601,37,'Kevin','jarred','equestrian','');
990 INSERT INTO t2 VALUES (948,232602,37,'uncovering','scolds','Goodrich','');
991 INSERT INTO t2 VALUES (949,232603,37,'chews','infatuate','apish','A');
992 INSERT INTO t2 VALUES (950,232605,37,'appendixes','willed','Adlerian','');
993 INSERT INTO t2 VALUES (5950,1232605,37,'appendixes','willed','Adlerian','');
994 INSERT INTO t2 VALUES (5951,1232606,37,'appendixes','willed','Adlerian','');
995 INSERT INTO t2 VALUES (5952,1232607,37,'appendixes','willed','Adlerian','');
996 INSERT INTO t2 VALUES (5953,1232608,37,'appendixes','willed','Adlerian','');
997 INSERT INTO t2 VALUES (5954,1232609,37,'appendixes','willed','Adlerian','');
998 INSERT INTO t2 VALUES (951,232606,37,'raining','joyfully','Tropez','');
999 INSERT INTO t2 VALUES (952,232607,37,'infest','Microsoft','nouns','');
1000 INSERT INTO t2 VALUES (953,232608,37,'compartment','fibrosities','distracting','');
1001 INSERT INTO t2 VALUES (954,232609,37,'minting','Baltimorean','mutton','');
1002 INSERT INTO t2 VALUES (955,236104,37,'ducks','equestrian','bridgeable','A');
1003 INSERT INTO t2 VALUES (956,236105,37,'roped','Goodrich','stickers','A');
1004 INSERT INTO t2 VALUES (957,236106,37,'waltz','apish','transcontinental','A');
1005 INSERT INTO t2 VALUES (958,236107,37,'Lillian','Adlerian','amateurish','');
1006 INSERT INTO t2 VALUES (959,236108,37,'repressions','Tropez','Gandhian','');
1007 INSERT INTO t2 VALUES (960,236109,37,'chillingly','nouns','stratified','');
1008 INSERT INTO t2 VALUES (961,236110,37,'noncritical','distracting','chamberlains','');
1009 INSERT INTO t2 VALUES (962,236111,37,'lithograph','mutton','creditably','');
1010 INSERT INTO t2 VALUES (963,236112,37,'spongers','bridgeable','philosophic','');
1011 INSERT INTO t2 VALUES (964,236113,37,'parenthood','stickers','ores','');
1012 INSERT INTO t2 VALUES (965,238005,37,'posed','transcontinental','Carleton','');
1013 INSERT INTO t2 VALUES (966,238006,37,'instruments','amateurish','tape','A');
1014 INSERT INTO t2 VALUES (967,238007,37,'filial','Gandhian','afloat','A');
1015 INSERT INTO t2 VALUES (968,238008,37,'fixedly','stratified','goodness','A');
1016 INSERT INTO t2 VALUES (969,238009,37,'relives','chamberlains','welcoming','');
1017 INSERT INTO t2 VALUES (970,238010,37,'Pandora','creditably','Pinsky','FAS');
1018 INSERT INTO t2 VALUES (971,238011,37,'watering','philosophic','halting','');
1019 INSERT INTO t2 VALUES (972,238012,37,'ungrateful','ores','bibliography','');
1020 INSERT INTO t2 VALUES (973,238013,37,'secures','Carleton','decoding','');
1021 INSERT INTO t2 VALUES (974,240401,41,'chastisers','tape','variance','A');
1022 INSERT INTO t2 VALUES (975,240402,41,'icon','afloat','allowed','A');
1023 INSERT INTO t2 VALUES (976,240901,41,'reuniting','goodness','dire','A');
1024 INSERT INTO t2 VALUES (977,240902,41,'imagining','welcoming','dub','A');
1025 INSERT INTO t2 VALUES (978,241801,41,'abiding','Pinsky','poisoning','');
1026 INSERT INTO t2 VALUES (979,242101,41,'omnisciently','halting','Iraqis','A');
1027 INSERT INTO t2 VALUES (980,242102,41,'Britannic','bibliography','heaving','');
1028 INSERT INTO t2 VALUES (981,242201,41,'scholastics','decoding','population','A');
1029 INSERT INTO t2 VALUES (982,242202,41,'mechanics','variance','bomb','A');
1030 INSERT INTO t2 VALUES (983,242501,41,'humidly','allowed','Majorca','A');
1031 INSERT INTO t2 VALUES (984,242502,41,'masterpiece','dire','Gershwins','');
1032 INSERT INTO t2 VALUES (985,246201,41,'however','dub','explorers','');
1033 INSERT INTO t2 VALUES (986,246202,41,'Mendelian','poisoning','libretto','A');
1034 INSERT INTO t2 VALUES (987,246203,41,'jarred','Iraqis','occurred','');
1035 INSERT INTO t2 VALUES (988,246204,41,'scolds','heaving','Lagos','');
1036 INSERT INTO t2 VALUES (989,246205,41,'infatuate','population','rats','');
1037 INSERT INTO t2 VALUES (990,246301,41,'willed','bomb','bankruptcies','A');
1038 INSERT INTO t2 VALUES (991,246302,41,'joyfully','Majorca','crying','');
1039 INSERT INTO t2 VALUES (992,248001,41,'Microsoft','Gershwins','unexpected','');
1040 INSERT INTO t2 VALUES (993,248002,41,'fibrosities','explorers','accessed','A');
1041 INSERT INTO t2 VALUES (994,248003,41,'Baltimorean','libretto','colorful','A');
1042 INSERT INTO t2 VALUES (995,248004,41,'equestrian','occurred','versatility','A');
1043 INSERT INTO t2 VALUES (996,248005,41,'Goodrich','Lagos','cosy','');
1044 INSERT INTO t2 VALUES (997,248006,41,'apish','rats','Darius','A');
1045 INSERT INTO t2 VALUES (998,248007,41,'Adlerian','bankruptcies','mastering','A');
1046 INSERT INTO t2 VALUES (999,248008,41,'Tropez','crying','Asiaticizations','A');
1047 INSERT INTO t2 VALUES (1000,248009,41,'nouns','unexpected','offerers','A');
1048 INSERT INTO t2 VALUES (1001,248010,41,'distracting','accessed','uncles','A');
1049 INSERT INTO t2 VALUES (1002,248011,41,'mutton','colorful','sleepwalk','');
1050 INSERT INTO t2 VALUES (1003,248012,41,'bridgeable','versatility','Ernestine','');
1051 INSERT INTO t2 VALUES (1004,248013,41,'stickers','cosy','checksumming','');
1052 INSERT INTO t2 VALUES (1005,248014,41,'transcontinental','Darius','stopped','');
1053 INSERT INTO t2 VALUES (1006,248015,41,'amateurish','mastering','sicker','');
1054 INSERT INTO t2 VALUES (1007,248016,41,'Gandhian','Asiaticizations','Italianization','');
1055 INSERT INTO t2 VALUES (1008,248017,41,'stratified','offerers','alphabetic','');
1056 INSERT INTO t2 VALUES (1009,248018,41,'chamberlains','uncles','pharmaceutic','');
1057 INSERT INTO t2 VALUES (1010,248019,41,'creditably','sleepwalk','creator','');
1058 INSERT INTO t2 VALUES (1011,248020,41,'philosophic','Ernestine','chess','');
1059 INSERT INTO t2 VALUES (1012,248021,41,'ores','checksumming','charcoal','');
1060 INSERT INTO t2 VALUES (1013,248101,41,'Carleton','stopped','Epiphany','A');
1061 INSERT INTO t2 VALUES (1014,248102,41,'tape','sicker','bulldozes','A');
1062 INSERT INTO t2 VALUES (1015,248201,41,'afloat','Italianization','Pygmalion','A');
1063 INSERT INTO t2 VALUES (1016,248202,41,'goodness','alphabetic','caressing','A');
1064 INSERT INTO t2 VALUES (1017,248203,41,'welcoming','pharmaceutic','Palestine','A');
1065 INSERT INTO t2 VALUES (1018,248204,41,'Pinsky','creator','regimented','A');
1066 INSERT INTO t2 VALUES (1019,248205,41,'halting','chess','scars','A');
1067 INSERT INTO t2 VALUES (1020,248206,41,'bibliography','charcoal','realest','A');
1068 INSERT INTO t2 VALUES (1021,248207,41,'decoding','Epiphany','diffusing','A');
1069 INSERT INTO t2 VALUES (1022,248208,41,'variance','bulldozes','clubroom','A');
1070 INSERT INTO t2 VALUES (1023,248209,41,'allowed','Pygmalion','Blythe','A');
1071 INSERT INTO t2 VALUES (1024,248210,41,'dire','caressing','ahead','');
1072 INSERT INTO t2 VALUES (1025,248211,50,'dub','Palestine','reviver','');
1073 INSERT INTO t2 VALUES (1026,250501,34,'poisoning','regimented','retransmitting','A');
1074 INSERT INTO t2 VALUES (1027,250502,34,'Iraqis','scars','landslide','');
1075 INSERT INTO t2 VALUES (1028,250503,34,'heaving','realest','Eiffel','');
1076 INSERT INTO t2 VALUES (1029,250504,34,'population','diffusing','absentee','');
1077 INSERT INTO t2 VALUES (1030,250505,34,'bomb','clubroom','aye','');
1078 INSERT INTO t2 VALUES (1031,250601,34,'Majorca','Blythe','forked','A');
1079 INSERT INTO t2 VALUES (1032,250602,34,'Gershwins','ahead','Peruvianizes','');
1080 INSERT INTO t2 VALUES (1033,250603,34,'explorers','reviver','clerked','');
1081 INSERT INTO t2 VALUES (1034,250604,34,'libretto','retransmitting','tutor','');
1082 INSERT INTO t2 VALUES (1035,250605,34,'occurred','landslide','boulevard','');
1083 INSERT INTO t2 VALUES (1036,251001,34,'Lagos','Eiffel','shuttered','');
1084 INSERT INTO t2 VALUES (1037,251002,34,'rats','absentee','quotes','A');
1085 INSERT INTO t2 VALUES (1038,251003,34,'bankruptcies','aye','Caltech','');
1086 INSERT INTO t2 VALUES (1039,251004,34,'crying','forked','Mossberg','');
1087 INSERT INTO t2 VALUES (1040,251005,34,'unexpected','Peruvianizes','kept','');
1088 INSERT INTO t2 VALUES (1041,251301,34,'accessed','clerked','roundly','');
1089 INSERT INTO t2 VALUES (1042,251302,34,'colorful','tutor','features','A');
1090 INSERT INTO t2 VALUES (1043,251303,34,'versatility','boulevard','imaginable','A');
1091 INSERT INTO t2 VALUES (1044,251304,34,'cosy','shuttered','controller','');
1092 INSERT INTO t2 VALUES (1045,251305,34,'Darius','quotes','racial','');
1093 INSERT INTO t2 VALUES (1046,251401,34,'mastering','Caltech','uprisings','A');
1094 INSERT INTO t2 VALUES (1047,251402,34,'Asiaticizations','Mossberg','narrowed','A');
1095 INSERT INTO t2 VALUES (1048,251403,34,'offerers','kept','cannot','A');
1096 INSERT INTO t2 VALUES (1049,251404,34,'uncles','roundly','vest','');
1097 INSERT INTO t2 VALUES (1050,251405,34,'sleepwalk','features','famine','');
1098 INSERT INTO t2 VALUES (1051,251406,34,'Ernestine','imaginable','sugars','');
1099 INSERT INTO t2 VALUES (1052,251801,34,'checksumming','controller','exterminated','A');
1100 INSERT INTO t2 VALUES (1053,251802,34,'stopped','racial','belays','');
1101 INSERT INTO t2 VALUES (1054,252101,34,'sicker','uprisings','Hodges','A');
1102 INSERT INTO t2 VALUES (1055,252102,34,'Italianization','narrowed','translatable','');
1103 INSERT INTO t2 VALUES (1056,252301,34,'alphabetic','cannot','duality','A');
1104 INSERT INTO t2 VALUES (1057,252302,34,'pharmaceutic','vest','recording','A');
1105 INSERT INTO t2 VALUES (1058,252303,34,'creator','famine','rouses','A');
1106 INSERT INTO t2 VALUES (1059,252304,34,'chess','sugars','poison','');
1107 INSERT INTO t2 VALUES (1060,252305,34,'charcoal','exterminated','attitude','');
1108 INSERT INTO t2 VALUES (1061,252306,34,'Epiphany','belays','dusted','');
1109 INSERT INTO t2 VALUES (1062,252307,34,'bulldozes','Hodges','encompasses','');
1110 INSERT INTO t2 VALUES (1063,252308,34,'Pygmalion','translatable','presentation','');
1111 INSERT INTO t2 VALUES (1064,252309,34,'caressing','duality','Kantian','');
1112 INSERT INTO t2 VALUES (1065,256001,34,'Palestine','recording','imprecision','A');
1113 INSERT INTO t2 VALUES (1066,256002,34,'regimented','rouses','saving','');
1114 INSERT INTO t2 VALUES (1067,256003,34,'scars','poison','maternal','');
1115 INSERT INTO t2 VALUES (1068,256004,34,'realest','attitude','hewed','');
1116 INSERT INTO t2 VALUES (1069,256005,34,'diffusing','dusted','kerosene','');
1117 INSERT INTO t2 VALUES (1070,258001,34,'clubroom','encompasses','Cubans','');
1118 INSERT INTO t2 VALUES (1071,258002,34,'Blythe','presentation','photographers','');
1119 INSERT INTO t2 VALUES (1072,258003,34,'ahead','Kantian','nymph','A');
1120 INSERT INTO t2 VALUES (1073,258004,34,'reviver','imprecision','bedlam','A');
1121 INSERT INTO t2 VALUES (1074,258005,34,'retransmitting','saving','north','A');
1122 INSERT INTO t2 VALUES (1075,258006,34,'landslide','maternal','Schoenberg','A');
1123 INSERT INTO t2 VALUES (1076,258007,34,'Eiffel','hewed','botany','A');
1124 INSERT INTO t2 VALUES (1077,258008,34,'absentee','kerosene','curs','');
1125 INSERT INTO t2 VALUES (1078,258009,34,'aye','Cubans','solidification','');
1126 INSERT INTO t2 VALUES (1079,258010,34,'forked','photographers','inheritresses','');
1127 INSERT INTO t2 VALUES (1080,258011,34,'Peruvianizes','nymph','stiller','');
1128 INSERT INTO t2 VALUES (1081,258101,68,'clerked','bedlam','t1','A');
1129 INSERT INTO t2 VALUES (1082,258102,68,'tutor','north','suite','A');
1130 INSERT INTO t2 VALUES (1083,258103,34,'boulevard','Schoenberg','ransomer','');
1131 INSERT INTO t2 VALUES (1084,258104,68,'shuttered','botany','Willy','');
1132 INSERT INTO t2 VALUES (1085,258105,68,'quotes','curs','Rena','A');
1133 INSERT INTO t2 VALUES (1086,258106,68,'Caltech','solidification','Seattle','A');
1134 INSERT INTO t2 VALUES (1087,258107,68,'Mossberg','inheritresses','relaxes','A');
1135 INSERT INTO t2 VALUES (1088,258108,68,'kept','stiller','exclaim','');
1136 INSERT INTO t2 VALUES (1089,258109,68,'roundly','t1','implicated','A');
1137 INSERT INTO t2 VALUES (1090,258110,68,'features','suite','distinguish','');
1138 INSERT INTO t2 VALUES (1091,258111,68,'imaginable','ransomer','assayed','');
1139 INSERT INTO t2 VALUES (1092,258112,68,'controller','Willy','homeowner','');
1140 INSERT INTO t2 VALUES (1093,258113,68,'racial','Rena','and','');
1141 INSERT INTO t2 VALUES (1094,258201,34,'uprisings','Seattle','stealth','');
1142 INSERT INTO t2 VALUES (1095,258202,34,'narrowed','relaxes','coinciding','A');
1143 INSERT INTO t2 VALUES (1096,258203,34,'cannot','exclaim','founder','A');
1144 INSERT INTO t2 VALUES (1097,258204,34,'vest','implicated','environing','');
1145 INSERT INTO t2 VALUES (1098,258205,34,'famine','distinguish','jewelry','');
1146 INSERT INTO t2 VALUES (1099,258301,34,'sugars','assayed','lemons','A');
1147 INSERT INTO t2 VALUES (1100,258401,34,'exterminated','homeowner','brokenness','A');
1148 INSERT INTO t2 VALUES (1101,258402,34,'belays','and','bedpost','A');
1149 INSERT INTO t2 VALUES (1102,258403,34,'Hodges','stealth','assurers','A');
1150 INSERT INTO t2 VALUES (1103,258404,34,'translatable','coinciding','annoyers','');
1151 INSERT INTO t2 VALUES (1104,258405,34,'duality','founder','affixed','');
1152 INSERT INTO t2 VALUES (1105,258406,34,'recording','environing','warbling','');
1153 INSERT INTO t2 VALUES (1106,258407,34,'rouses','jewelry','seriously','');
1154 INSERT INTO t2 VALUES (1107,228123,37,'poison','lemons','boasted','');
1155 INSERT INTO t2 VALUES (1108,250606,34,'attitude','brokenness','Chantilly','');
1156 INSERT INTO t2 VALUES (1109,208405,37,'dusted','bedpost','Iranizes','');
1157 INSERT INTO t2 VALUES (1110,212101,37,'encompasses','assurers','violinist','');
1158 INSERT INTO t2 VALUES (1111,218206,37,'presentation','annoyers','extramarital','');
1159 INSERT INTO t2 VALUES (1112,150401,37,'Kantian','affixed','spates','');
1160 INSERT INTO t2 VALUES (1113,248212,41,'imprecision','warbling','cloakroom','');
1161 INSERT INTO t2 VALUES (1114,128026,00,'saving','seriously','gazer','');
1162 INSERT INTO t2 VALUES (1115,128024,00,'maternal','boasted','hand','');
1163 INSERT INTO t2 VALUES (1116,128027,00,'hewed','Chantilly','tucked','');
1164 INSERT INTO t2 VALUES (1117,128025,00,'kerosene','Iranizes','gems','');
1165 INSERT INTO t2 VALUES (1118,128109,00,'Cubans','violinist','clinker','');
1166 INSERT INTO t2 VALUES (1119,128705,00,'photographers','extramarital','refiner','');
1167 INSERT INTO t2 VALUES (1120,126303,00,'nymph','spates','callus','');
1168 INSERT INTO t2 VALUES (1121,128308,00,'bedlam','cloakroom','leopards','');
1169 INSERT INTO t2 VALUES (1122,128204,00,'north','gazer','comfortingly','');
1170 INSERT INTO t2 VALUES (1123,128205,00,'Schoenberg','hand','generically','');
1171 INSERT INTO t2 VALUES (1124,128206,00,'botany','tucked','getters','');
1172 INSERT INTO t2 VALUES (1125,128207,00,'curs','gems','sexually','');
1173 INSERT INTO t2 VALUES (1126,118205,00,'solidification','clinker','spear','');
1174 INSERT INTO t2 VALUES (1127,116801,00,'inheritresses','refiner','serums','');
1175 INSERT INTO t2 VALUES (1128,116803,00,'stiller','callus','Italianization','');
1176 INSERT INTO t2 VALUES (1129,116804,00,'t1','leopards','attendants','');
1177 INSERT INTO t2 VALUES (1130,116802,00,'suite','comfortingly','spies','');
1178 INSERT INTO t2 VALUES (1131,128605,00,'ransomer','generically','Anthony','');
1179 INSERT INTO t2 VALUES (1132,118308,00,'Willy','getters','planar','');
1180 INSERT INTO t2 VALUES (1133,113702,00,'Rena','sexually','cupped','');
1181 INSERT INTO t2 VALUES (1134,113703,00,'Seattle','spear','cleanser','');
1182 INSERT INTO t2 VALUES (1135,112103,00,'relaxes','serums','commuters','');
1183 INSERT INTO t2 VALUES (1136,118009,00,'exclaim','Italianization','honeysuckle','');
1184 INSERT INTO t2 VALUES (5136,1118009,00,'exclaim','Italianization','honeysuckle','');
1185 INSERT INTO t2 VALUES (1137,138011,00,'implicated','attendants','orphanage','');
1186 INSERT INTO t2 VALUES (1138,138010,00,'distinguish','spies','skies','');
1187 INSERT INTO t2 VALUES (1139,138012,00,'assayed','Anthony','crushers','');
1188 INSERT INTO t2 VALUES (1140,068304,00,'homeowner','planar','Puritan','');
1189 INSERT INTO t2 VALUES (1141,078009,00,'and','cupped','squeezer','');
1190 INSERT INTO t2 VALUES (1142,108013,00,'stealth','cleanser','bruises','');
1191 INSERT INTO t2 VALUES (1143,084004,00,'coinciding','commuters','bonfire','');
1192 INSERT INTO t2 VALUES (1144,083402,00,'founder','honeysuckle','Colombo','');
1193 INSERT INTO t2 VALUES (1145,084003,00,'environing','orphanage','nondecreasing','');
1194 INSERT INTO t2 VALUES (1146,088504,00,'jewelry','skies','innocents','');
1195 INSERT INTO t2 VALUES (1147,088005,00,'lemons','crushers','masked','');
1196 INSERT INTO t2 VALUES (1148,088007,00,'brokenness','Puritan','file','');
1197 INSERT INTO t2 VALUES (1149,088006,00,'bedpost','squeezer','brush','');
1198 INSERT INTO t2 VALUES (1150,148025,00,'assurers','bruises','mutilate','');
1199 INSERT INTO t2 VALUES (1151,148024,00,'annoyers','bonfire','mommy','');
1200 INSERT INTO t2 VALUES (1152,138305,00,'affixed','Colombo','bulkheads','');
1201 INSERT INTO t2 VALUES (1153,138306,00,'warbling','nondecreasing','undeclared','');
1202 INSERT INTO t2 VALUES (1154,152701,00,'seriously','innocents','displacements','');
1203 INSERT INTO t2 VALUES (1155,148505,00,'boasted','masked','nieces','');
1204 INSERT INTO t2 VALUES (1156,158003,00,'Chantilly','file','coeducation','');
1205 INSERT INTO t2 VALUES (1157,156201,00,'Iranizes','brush','brassy','');
1206 INSERT INTO t2 VALUES (1158,156202,00,'violinist','mutilate','authenticator','');
1207 INSERT INTO t2 VALUES (1159,158307,00,'extramarital','mommy','Washoe','');
1208 INSERT INTO t2 VALUES (1160,158402,00,'spates','bulkheads','penny','');
1209 INSERT INTO t2 VALUES (1161,158401,00,'cloakroom','undeclared','Flagler','');
1210 INSERT INTO t2 VALUES (1162,068013,00,'gazer','displacements','stoned','');
1211 INSERT INTO t2 VALUES (1163,068012,00,'hand','nieces','cranes','');
1212 INSERT INTO t2 VALUES (1164,068203,00,'tucked','coeducation','masterful','');
1213 INSERT INTO t2 VALUES (1165,088205,00,'gems','brassy','biracial','');
1214 INSERT INTO t2 VALUES (1166,068704,00,'clinker','authenticator','steamships','');
1215 INSERT INTO t2 VALUES (1167,068604,00,'refiner','Washoe','windmills','');
1216 INSERT INTO t2 VALUES (1168,158502,00,'callus','penny','exploit','');
1217 INSERT INTO t2 VALUES (1169,123103,00,'leopards','Flagler','riverfront','');
1218 INSERT INTO t2 VALUES (1170,148026,00,'comfortingly','stoned','sisterly','');
1219 INSERT INTO t2 VALUES (1171,123302,00,'generically','cranes','sharpshoot','');
1220 INSERT INTO t2 VALUES (1172,076503,00,'getters','masterful','mittens','');
1221 INSERT INTO t2 VALUES (1173,126304,00,'sexually','biracial','interdependency','');
1222 INSERT INTO t2 VALUES (1174,068306,00,'spear','steamships','policy','');
1223 INSERT INTO t2 VALUES (1175,143504,00,'serums','windmills','unleashing','');
1224 INSERT INTO t2 VALUES (1176,160201,00,'Italianization','exploit','pretenders','');
1225 INSERT INTO t2 VALUES (1177,148028,00,'attendants','riverfront','overstatements','');
1226 INSERT INTO t2 VALUES (1178,148027,00,'spies','sisterly','birthed','');
1227 INSERT INTO t2 VALUES (1179,143505,00,'Anthony','sharpshoot','opportunism','');
1228 INSERT INTO t2 VALUES (1180,108014,00,'planar','mittens','showroom','');
1229 INSERT INTO t2 VALUES (1181,076104,00,'cupped','interdependency','compromisingly','');
1230 INSERT INTO t2 VALUES (1182,078106,00,'cleanser','policy','Medicare','');
1231 INSERT INTO t2 VALUES (1183,126102,00,'commuters','unleashing','corresponds','');
1232 INSERT INTO t2 VALUES (1184,128029,00,'honeysuckle','pretenders','hardware','');
1233 INSERT INTO t2 VALUES (1185,128028,00,'orphanage','overstatements','implant','');
1234 INSERT INTO t2 VALUES (1186,018410,00,'skies','birthed','Alicia','');
1235 INSERT INTO t2 VALUES (1187,128110,00,'crushers','opportunism','requesting','');
1236 INSERT INTO t2 VALUES (1188,148506,00,'Puritan','showroom','produced','');
1237 INSERT INTO t2 VALUES (1189,123303,00,'squeezer','compromisingly','criticizes','');
1238 INSERT INTO t2 VALUES (1190,123304,00,'bruises','Medicare','backer','');
1239 INSERT INTO t2 VALUES (1191,068504,00,'bonfire','corresponds','positively','');
1240 INSERT INTO t2 VALUES (1192,068305,00,'Colombo','hardware','colicky','');
1241 INSERT INTO t2 VALUES (1193,000000,00,'nondecreasing','implant','thrillingly','');
1242 --enable_query_log
1243
1244 #
1245 # Search with a key
1246 #
1247
1248 select t2.fld3 FROM t2 where companynr = 58 and fld3 like "%imaginable%";
1249 select fld3 FROM t2 where fld3 like "%cultivation" ;
1250
1251 #
1252 # Search with a key using sorting and limit the same time
1253 #
1254
1255 select t2.fld3,companynr FROM t2 where companynr = 57+1 order by fld3;
1256 select fld3,companynr FROM t2 where companynr = 58 order by fld3;
1257
1258 select fld3 FROM t2 order by fld3 desc limit 10;
1259 select fld3 FROM t2 order by fld3 desc limit 5;
1260 select fld3 FROM t2 order by fld3 desc limit 5,5;
1261
1262 #
1263 # Search with a key having a constant with each unique key.
1264 # The table is read directly with read-next on fld3
1265 #
1266
1267 select t2.fld3 FROM t2 where fld3 = 'honeysuckle';
1268 select t2.fld3 FROM t2 where fld3 LIKE 'honeysuckl_';
1269 select t2.fld3 FROM t2 where fld3 LIKE 'hon_ysuckl_';
1270 select t2.fld3 FROM t2 where fld3 LIKE 'honeysuckle%';
1271 select t2.fld3 FROM t2 where fld3 LIKE 'h%le';
1272
1273 select t2.fld3 FROM t2 where fld3 LIKE 'honeysuckle_';
1274 select t2.fld3 FROM t2 where fld3 LIKE 'don_t_find_me_please%';
1275
1276 #
1277 # Test sorting with a used key (there is no need for sorting)
1278 #
1279
1280 select t2.fld3 FROM t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;
1281 select fld1,fld3 FROM t2 where fld3="Colombo" or fld3 = "nondecreasing" order by fld3;
1282
1283 #
1284 # Search with a key with LIKE constant
1285 # If the like starts with a certain letter key will be used.
1286 #
1287
1288 select fld1,fld3 FROM t2 where companynr = 37 and fld3 like 'f%';
1289 select fld3 FROM t2 where fld3 like "L%" and fld3 = "ok";
1290 select fld3 FROM t2 where (fld3 like "C%" and fld3 = "Chantilly");
1291 select fld1,fld3 FROM t2 where fld1 like "25050%";
1292 select fld1,fld3 FROM t2 where fld1 like "25050_";
1293
1294
1295 #
1296 # Test rename of table
1297 #
1298 CREATE TABLE t3 engine=archive select * FROM t2;
1299 select * FROM t3 where fld3='bonfire';
1300 select count(*) FROM t3;
1301 # Clean up path in error message
1302 --replace_result $MYSQL_TEST_DIR . /var/master-data/ /
1303 rename table t3 to t4;
1304 select * FROM t4 where fld3='bonfire';
1305 select count(*) FROM t4;
1306
1307 # End of 4.1 tests
1308
1309 #
1310 # Test for insert after select
1311 #
1312 INSERT INTO t2 VALUES (1,000001,00,'Omaha','teethe','neat','');
1313 INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
1314 INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
1315 INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
1316 SELECT * FROM t2;
1317 OPTIMIZE TABLE t2;
1318 SELECT * FROM t2;
1319 INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
1320 INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
1321 INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
1322 OPTIMIZE TABLE t2;
1323 SELECT * FROM t2;
1324 REPAIR TABLE t2;
1325 SELECT * FROM t2;
1326
1327 #
1328 # Test bulk inserts
1329 INSERT INTO t2 VALUES (1,000001,00,'Omaha','teethe','neat','') , (2,011401,37,'breaking','dreaded','Steinberg','W') , (3,011402,37,'Romans','scholastics','jarring','') , (4,011403,37,'intercepted','audiology','tinily','');
1330 SELECT * FROM t2;
1331
1332 #
1333 # For bug #12836
1334 # Delete was allowing all rows to be removed
1335 --error 1031
1336 DELETE FROM t2;
1337 SELECT * FROM t2;
1338 INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
1339 INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
1340 INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
1341 SELECT * FROM t2;
1342 --error 1031
1343 TRUNCATE TABLE t2;
1344 SELECT * FROM t2;
1345
1346 # Adding support for CHECK table
1347 CHECK TABLE t2;
1348 SELECT * FROM t2;
1349
1350
1351 # Test INSERT DELAYED and wait until the table has one more record
1352 SELECT COUNT(auto) FROM t2;
1353 INSERT DELAYED INTO t2 VALUES (99999,011403,37,'the','delayed','insert','');
1354
1355 # Insert another record since in Archive delayed values are only
1356 # guaranteed to materialize based on either:
1357 # 1) A new row showing up from a normal insert
1358 # 2) A flush table has occurred.
1359 INSERT INTO t2 VALUES (100000,000001,00,'after','delayed','insert','');
1360
1361 # Wait for the delayed insert to appear
1362 while (`SELECT COUNT(auto)!=1215 FROM t2`)
1363 {
1364 sleep 0.1;
1365 }
1366 SELECT COUNT(auto) FROM t2;
1367
1368 # Adding test for ALTER TABLE
1369 ALTER TABLE t2 DROP COLUMN fld6;
1370 SHOW CREATE TABLE t2;
1371 SELECT * FROM t2 WHERE auto != 100000;
1372
1373
1374 # Adding tests for autoincrement
1375 # First the simple stuff
1376
1377 CREATE TABLE `t5` (
1378 `a` int(11) NOT NULL auto_increment,
1379 b char(12),
1380 PRIMARY KEY (`a`)
1381 ) DEFAULT CHARSET=latin1;
1382
1383 INSERT INTO t5 VALUES (NULL, "foo");
1384 INSERT INTO t5 VALUES (NULL, "foo");
1385 INSERT INTO t5 VALUES (NULL, "foo");
1386 INSERT INTO t5 VALUES (NULL, "foo");
1387 INSERT INTO t5 VALUES (NULL, "foo");
1388 INSERT INTO t5 VALUES (32, "foo");
1389 --error 1022
1390 INSERT INTO t5 VALUES (23, "foo");
1391 INSERT INTO t5 VALUES (NULL, "foo");
1392 INSERT INTO t5 VALUES (NULL, "foo");
1393 --error 1022
1394 INSERT INTO t5 VALUES (3, "foo");
1395 INSERT INTO t5 VALUES (NULL, "foo");
1396 SELECT * FROM t5;
1397
1398 SELECT * FROM t5 WHERE a=3;
1399
1400 DROP TABLE t5;
1401
1402 CREATE TABLE `t5` (
1403 `a` int(11) NOT NULL auto_increment,
1404 b char(12),
1405 KEY (`a`)
1406 ) DEFAULT CHARSET=latin1 AUTO_INCREMENT=5;
1407
1408 INSERT INTO t5 VALUES (NULL, "foo");
1409 INSERT INTO t5 VALUES (NULL, "foo");
1410 INSERT INTO t5 VALUES (NULL, "foo");
1411 INSERT INTO t5 VALUES (NULL, "foo");
1412 INSERT INTO t5 VALUES (NULL, "foo");
1413 INSERT INTO t5 VALUES (32, "foo");
1414 INSERT INTO t5 VALUES (23, "foo");
1415 INSERT INTO t5 VALUES (NULL, "foo");
1416 INSERT INTO t5 VALUES (NULL, "foo");
1417 INSERT INTO t5 VALUES (3, "foo");
1418 INSERT INTO t5 VALUES (NULL, "foo");
1419 SELECT * FROM t5;
1420 OPTIMIZE TABLE t5;
1421 SELECT * FROM t5;
1422
1423 SELECT * FROM t5 WHERE a=32;
1424 SELECT * FROM t5 WHERE a=3;
1425
1426 DROP TABLE t5;
1427
1428 CREATE TABLE `t5` (
1429 `a` int(11) NOT NULL auto_increment,
1430 b blob(12),
1431 KEY (`a`)
1432 ) DEFAULT CHARSET=latin1;
1433
1434 INSERT INTO t5 VALUES (NULL, "foo");
1435 INSERT INTO t5 VALUES (NULL, "We the people");
1436 INSERT INTO t5 VALUES (NULL, "in order to form a more pefect union");
1437 INSERT INTO t5 VALUES (NULL, "establish justice");
1438 INSERT INTO t5 VALUES (NULL, "foo grok ");
1439 INSERT INTO t5 VALUES (32, "ensure domestic tranquility");
1440 INSERT INTO t5 VALUES (23, "provide for the common defense");
1441 INSERT INTO t5 VALUES (NULL, "fo fooo");
1442 INSERT INTO t5 VALUES (NULL, "foo just naother bit of text");
1443 INSERT INTO t5 VALUES (3, "foo this is mine to think about");
1444 INSERT INTO t5 VALUES (NULL, "promote the general welfare");
1445 SELECT * FROM t5;
1446 SELECT b FROM t5;
1447 SELECT b FROM t5 WHERE a =3;
1448 explain
1449 SELECT b FROM t5 WHERE a IN (32, 23, 5);
1450 SELECT b FROM t5 WHERE a IN (32, 23, 5);
1451
1452 #More blob tests
1453
1454 DROP TABLE t5;
1455
1456 CREATE TABLE `t5` (
1457 `a` int(11) NOT NULL auto_increment,
1458 b blob(12),
1459 c blob(12),
1460 KEY (`a`)
1461 ) DEFAULT CHARSET=latin1;
1462
1463 INSERT INTO t5 VALUES (NULL, "foo", "grok this!");
1464 INSERT INTO t5 VALUES (NULL, "We the people", NULL);
1465 INSERT INTO t5 VALUES (NULL, "in order to form a more peefect union", "secure the blessing of liberty");
1466 INSERT INTO t5 VALUES (NULL, "establish justice", "to ourselves and");
1467 INSERT INTO t5 VALUES (32, "ensure domestic tranquility", NULL);
1468 INSERT INTO t5 VALUES (23, "provide for the common defense", "posterity");
1469 INSERT INTO t5 VALUES (NULL, "promote the general welfare", "do ordain");
1470 SELECT * FROM t5;
1471 SELECT b FROM t5;
1472 SELECT b FROM t5 WHERE a =3;
1473 SELECT b FROM t5 WHERE a IN (32, 23, 5);
1474 SELECT c FROM t5;
1475 SELECT c FROM t5 WHERE a =3;
1476 SELECT c FROM t5 WHERE a IN (32, 23, 5);
1477
1478 # Adding this in case someone tries to add fast ALTER TABLE and doesn't tes
1479 # it.
1480 # Some additional tests for new, faster ALTER TABLE. Note that most of the
1481 # whole ALTER TABLE code is being tested all around the test suite already.
1482 #
1483
1484 DROP TABLE t1;
1485 CREATE TABLE t1 (v varchar(32)) ;
1486 insert into t1 values ('def'),('abc'),('hij'),('3r4f');
1487 select * from t1;
1488 # Fast alter, no copy performed
1489 ALTER TABLE t1 change v v2 varchar(32);
1490 select * from t1;
1491 # Fast alter, no copy performed
1492 ALTER TABLE t1 change v2 v varchar(64);
1493 select * from t1;
1494 # Regular ALTER TABLE
1495 ALTER TABLE t1 add i int auto_increment not null primary key first;
1496 select * from t1;
1497
1498 # Testing cleared row key
1499 DROP TABLE t5;
1500
1501 CREATE TABLE `t5` (
1502 `a` int(11) NOT NULL auto_increment,
1503 b varchar(250),
1504 c varchar(800),
1505 KEY (`a`)
1506 ) DEFAULT CHARSET=latin1;
1507
1508 INSERT INTO t5 VALUES (NULL, "foo", "grok this!");
1509 INSERT INTO t5 VALUES (NULL, "We the people", NULL);
1510 INSERT INTO t5 VALUES (NULL, "in order to form a more peefect union", "secure the blessing of liberty");
1511 INSERT INTO t5 VALUES (NULL, "establish justice", "to ourselves and");
1512 INSERT INTO t5 VALUES (32, "ensure domestic tranquility", NULL);
1513 INSERT INTO t5 VALUES (23, "provide for the common defense", "posterity");
1514 INSERT INTO t5 VALUES (NULL, "promote the general welfare", "do ordain");
1515 INSERT IGNORE INTO t5 VALUES (NULL, "abcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabcdeghijklmnopqrstuvwxyzabc", "do ordain");
1516
1517 SELECT * FROM t5;
1518
1519 CREATE TABLE `t6` (
1520 `a` int(11) NOT NULL auto_increment,
1521 b blob(12),
1522 c int,
1523 KEY (`a`)
1524 ) DEFAULT CHARSET=latin1;
1525 SELECT * FROM t6;
1526 INSERT INTO t6 VALUES (NULL, "foo", NULL);
1527 INSERT INTO t6 VALUES (NULL, "We the people", 5);
1528 INSERT INTO t6 VALUES (NULL, "in order to form a more pefect union", 9);
1529 INSERT INTO t6 VALUES (NULL, "establish justice", NULL);
1530 INSERT INTO t6 VALUES (NULL, NULL, NULL);
1531 INSERT INTO t6 VALUES (32, "ensure domestic tranquility", NULL);
1532 INSERT INTO t6 VALUES (23, "provide for the common defense", 30);
1533 INSERT INTO t6 VALUES (NULL, "fo fooo", 70);
1534 INSERT INTO t6 VALUES (NULL, NULL, 98);
1535 INSERT INTO t6 VALUES (NULL, "promote the general welfare", 50);
1536 SELECT * FROM t6;
1537 SELECT * FROM t6 ORDER BY a;
1538 SELECT * FROM t6 ORDER BY a DESC;
1539
1540 SHOW CREATE TABLE t6;
1541
1542
1543 #
1544 # Cleanup, test is over
1545 #
1546
1547
1548 --disable_warnings
1549 DROP TABLE t1, t2, t4, t5, t6;
1550 --enable_warnings
1551
1552 #
1553 # BUG#26138 - REPAIR TABLE with option USE_FRM erases all records in ARCHIVE
1554 # table
1555 #
1556 create table t1 (i int) engine=archive;
1557 insert into t1 values (1);
1558 repair table t1 use_frm;
1559 select * from t1;
1560 drop table t1;
1561
1562 #
1563 # BUG#29207 - archive table reported as corrupt by check table
1564 #
1565 create table t1(a longblob) engine=archive;
1566 insert into t1 set a='';
1567 insert into t1 set a='a';
1568 check table t1 extended;
1569 drop table t1;
1570
1571 #
1572 # BUG#31036 - Using order by with archive table crashes server
1573 #
1574
1575 CREATE TABLE t1(a VARCHAR(510)) ENGINE = ARCHIVE;
1576
1577 let $bug31036=41;
1578 --disable_query_log
1579 begin;
1580 while($bug31036)
1581 {
1582 INSERT INTO t1(a) VALUES (REPEAT('a', 510));
1583 dec $bug31036;
1584 }
1585 commit;
1586 --enable_query_log
1587 INSERT INTO t1(a) VALUES ('');
1588
1589 --disable_result_log
1590 SELECT * FROM t1 ORDER BY a;
1591 --enable_result_log
1592
1593 DROP TABLE t1;
1594
1595 #
1596 # BUG#31833 - ORDER BY leads to wrong result when ARCHIVE, BLOB and table
1597 # cache is full
1598 #
1599 CREATE TABLE t1(a INT NOT NULL AUTO_INCREMENT, b BLOB, KEY(a)) ENGINE=archive;
1600 INSERT INTO t1 VALUES (NULL, NULL),(NULL, NULL);
1601 FLUSH TABLE t1;
1602 SELECT * FROM t1 ORDER BY a;
1603 DROP TABLE t1;
1604
1605 #
1606 # BUG#29203 - archive tables have weird values in show table status
1607 #
1608 CREATE TABLE t1(a INT, b BLOB) ENGINE=archive;
1609 SELECT DATA_LENGTH, AVG_ROW_LENGTH FROM
1610 INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test';
1611 INSERT INTO t1 VALUES(1, 'sampleblob1'),(2, 'sampleblob2');
1612 # Compression length depends on zip library
1613 --replace_result 583 584 585 584 291 292
1614 SELECT DATA_LENGTH, AVG_ROW_LENGTH FROM
1615 INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test';
1616 DROP TABLE t1;
1617
1618 #
1619 # BUG#46961 - archive engine loses rows during self joining select!
1620 #
1621 SET @save_join_buffer_size= @@join_buffer_size;
1622 SET @@join_buffer_size= 8192;
1623 CREATE TABLE t1(a CHAR(255)) ENGINE=archive;
1624 INSERT INTO t1 VALUES('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'),
1625 ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'),
1626 ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
1627 SELECT COUNT(t1.a) FROM t1, t1 a, t1 b, t1 c, t1 d, t1 e;
1628 DROP TABLE t1;
1629 SET @@join_buffer_size= @save_join_buffer_size;
1630
1631 --echo End of 5.1 tests
1632
1633 #
1634 # BUG#40677 - Archive tables joined on primary return no result
1635 #
1636 CREATE TABLE t1(id INT NOT NULL AUTO_INCREMENT, name VARCHAR(128) NOT NULL, PRIMARY KEY(id)) ENGINE=archive;
1637 INSERT INTO t1 VALUES(NULL,'a'),(NULL,'a');
1638 CREATE TABLE t2(id INT NOT NULL AUTO_INCREMENT, name VARCHAR(128) NOT NULL, PRIMARY KEY(id)) ENGINE=archive;
1639 INSERT INTO t2 VALUES(NULL,'b'),(NULL,'b');
1640 SELECT t1.id, t2.id, t1.name, t2.name FROM t1,t2 WHERE t1.id = t2.id;
1641 DROP TABLE t1,t2;
1642
1643 #
1644 # BUG#47012 archive tables are not upgradeable, and server crashes on any access
1645 #
1646 copy_file std_data/bug47012.frm $MYSQLD_DATADIR/test/t1.frm;
1647 copy_file std_data/bug47012.ARZ $MYSQLD_DATADIR/test/t1.ARZ;
1648 copy_file std_data/bug47012.ARM $MYSQLD_DATADIR/test/t1.ARM;
1649
1650 SHOW CREATE TABLE t1;
1651
1652 SELECT * FROM t1;
1653
1654 INSERT INTO t1 (col1, col2) VALUES (1, "value");
1655
1656 REPAIR TABLE t1;
1657 DROP TABLE t1;
1658
1659 --echo #
1660 --echo # Ensure that TRUNCATE fails for non-empty archive tables.
1661 --echo #
1662 CREATE TABLE t1 (a INT) ENGINE=ARCHIVE;
1663 INSERT INTO t1 VALUES (1);
1664 --error ER_ILLEGAL_HA
1665 TRUNCATE TABLE t1;
1666 DROP TABLE t1;
1667
1668
1669 --echo #
1670 --echo # BUG#46565 - repair of partition fail for archive engine
1671 --echo #
1672 --echo # Installing corrupted table files for t1.
1673 # bug46565 was created, filled and damaged as following:
1674 # CREATE TABLE bug46565(a INT) ENGINE=archive;
1675 # INSERT INTO bug46565 VALUES(1);
1676 # FLUSH TABLE bug46565;
1677 # INSERT INTO bug46565 VALUES(2),(3);
1678 # FLUSH TABLE bug46565;
1679 # dd if=bug46565.ARZ of=std_data/bug46565.ARZ bs=1 count=8670
1680 copy_file std_data/bug46565.frm $MYSQLD_DATADIR/test/t1.frm;
1681 copy_file std_data/bug46565.ARZ $MYSQLD_DATADIR/test/t1.ARZ;
1682 --error ER_CRASHED_ON_USAGE
1683 SELECT * FROM t1;
1684 REPAIR TABLE t1;
1685 --error ER_CRASHED_ON_USAGE
1686 SELECT * FROM t1;
1687 REPAIR TABLE t1 EXTENDED;
1688 SELECT * FROM t1;
1689 DROP TABLE t1;
1690
1691
1692 --echo #
1693 --echo # BUG#57162 - valgrind errors, random data when returning
1694 --echo # ordered data from archive tables
1695 --echo #
1696 SET sort_buffer_size=32804;
1697 CREATE TABLE t1(a INT, b CHAR(255), c CHAR(255), d CHAR(255),
1698 e CHAR(255), f INT) ENGINE=ARCHIVE DEFAULT CHARSET utf8;
1699 INSERT INTO t1 VALUES(-1,'b','c','d','e',1);
1700 INSERT INTO t1 SELECT * FROM t1;
1701 INSERT INTO t1 SELECT * FROM t1;
1702 INSERT INTO t1 SELECT t1.* FROM t1,t1 t2,t1 t3,t1 t4,t1 t5,t1 t6;
1703 SELECT * FROM t1 ORDER BY f LIMIT 1;
1704 DROP TABLE t1;
1705 SET sort_buffer_size=DEFAULT;
1706
1707 --echo #
1708 --echo # BUG#11756687 - 48633: ARCHIVE TABLES ARE NOT UPGRADEABLE
1709 --echo #
1710 copy_file std_data/bug48633.frm $MYSQLD_DATADIR/test/t1.frm;
1711 copy_file std_data/bug48633.ARZ $MYSQLD_DATADIR/test/t1.ARZ;
1712 copy_file std_data/bug48633.ARM $MYSQLD_DATADIR/test/t1.ARM;
1713 SHOW CREATE TABLE t1;
1714 # Test first table scan
1715 SELECT * FROM t1;
1716 # Test second table scan
1717 SELECT * FROM t1;
1718 # Test table close
1719 FLUSH TABLE t1;
1720 SELECT * FROM t1;
1721 # Test check
1722 CHECK TABLE t1;
1723 SELECT * FROM t1;
1724 # Test insert
1725 INSERT INTO t1 VALUES(3, 'text', 'varchar', 'blob1', 'blob2');
1726 SELECT * FROM t1;
1727 # Test table close after insert
1728 FLUSH TABLE t1;
1729 SELECT * FROM t1;
1730 # Test repair
1731 REPAIR TABLE t1;
1732 SELECT * FROM t1;
1733 # Test check table after upgrade
1734 CHECK TABLE t1;
1735 DROP TABLE t1;
1736
1737 --echo #
1738 --echo # BUG#11758979 - 51252: ARCHIVE TABLES STILL FAIL UNDER STRESS
1739 --echo # TESTS: CRASH, CORRUPTION, 4G MEMOR
1740 --echo # (to be executed with valgrind)
1741 CREATE TABLE t1(a BLOB, b VARCHAR(200)) ENGINE=ARCHIVE;
1742 INSERT INTO t1 VALUES(NULL, '');
1743 FLUSH TABLE t1;
1744 --echo # we need this select to workaround BUG#11764364
1745 SELECT * FROM t1;
1746 CHECKSUM TABLE t1 EXTENDED;
1747 FLUSH TABLE t1;
1748 OPTIMIZE TABLE t1;
1749 DROP TABLE t1;
1750
1751 --echo #
1752 --echo # Bug#13907676: HA_ARCHIVE::INFO
1753 --echo #
1754 CREATE TABLE t1 (a INT) ENGINE=ARCHIVE;
1755 CREATE TABLE t2 SELECT * FROM t1;
1756 SELECT * FROM t2;
1757 DROP TABLE t1, t2;
1758
1759 --echo #
1760 --echo # BUG#917689 Using wrong archive table causes crash
1761 --echo #
1762 create table t1 (a int, b char(50)) engine=archive charset=latin1;
1763 select * from t1; # open the table to create the frm
1764 flush tables; # and close the table again
1765 --remove_file $MYSQLD_DATADIR/test/t1.ARZ
1766 copy_file std_data/t917689.ARZ $MYSQLD_DATADIR/test/t1.ARZ;
1767 --error ER_CRASHED_ON_USAGE
1768 select * from t1;
1769 show warnings;
1770 drop table t1;
1771
1772 --echo #
1773 --echo # temporary archive
1774 --echo #
1775 create temporary table t1 (a int) engine=archive;
1776 insert t1 values (1),(2),(3);
1777 select * from t1;
1778 show create table t1;
1779 alter table t1 add column b varchar(10);
1780 select * from t1;
1781 show create table t1;
1782 drop table t1;
1783
1784 --echo #
1785 --echo # End of 10.0 tests
1786 --echo #
1787
1788 --echo #
1789 --echo # MDEV-27396 DESC index attribute remains in Archive table definition, despite being apparently ignored
1790 --echo #
1791 --error ER_CANT_CREATE_TABLE
1792 create table t (t int auto_increment, key (t desc)) engine=archive;
1793
1794 --echo #
1795 --echo # End of 10.8 tests
1796 --echo #