~drizzle-trunk/drizzle/development

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