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