Debian Codegraph @

mysql-test/suite/csv/csv.test

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