2
# Find string "NOTE NOTE NOTE" in order to find some 'unsure' tests
10
drop table if exists t1,t2,t3,t4,t11;
11
# The following may be left from older tests
12
drop table if exists t1_1,t1_2,t9_1,t9_2,t1aa,t2aa;
13
drop view if exists v1;
17
Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,
18
Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL
21
INSERT INTO t1 VALUES (9410,9412);
23
select period from t1;
32
auto int not null auto_increment,
33
fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL,
34
companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL,
35
fld3 char(30) DEFAULT '' NOT NULL,
36
fld4 char(35) DEFAULT '' NOT NULL,
37
fld5 char(35) DEFAULT '' NOT NULL,
38
fld6 char(4) DEFAULT '' NOT NULL,
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','');
1254
select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%";
1255
select fld3 from t2 where fld3 like "%cultivation" ;
1258
# Search with a key using sorting and limit the same time
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;
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;
1269
# Search with a key having a constant with each unique key.
1270
# The table is read directly with read-next on fld3
1273
select t2.fld3 from t2 where fld3 = 'honeysuckle';
1274
select t2.fld3 from t2 where fld3 LIKE 'honeysuckl_';
1275
select t2.fld3 from t2 where fld3 LIKE 'hon_ysuckl_';
1276
select t2.fld3 from t2 where fld3 LIKE 'honeysuckle%';
1277
select t2.fld3 from t2 where fld3 LIKE 'h%le';
1279
select t2.fld3 from t2 where fld3 LIKE 'honeysuckle_';
1280
select t2.fld3 from t2 where fld3 LIKE 'don_t_find_me_please%';
1283
# Test using INDEX and IGNORE INDEX
1286
explain select t2.fld3 from t2 where fld3 = 'honeysuckle';
1288
explain select fld3 from t2 ignore index (fld3) where fld3 = 'honeysuckle';
1289
explain select fld3 from t2 use index (fld1) where fld3 = 'honeysuckle';
1291
explain select fld3 from t2 use index (fld3) where fld3 = 'honeysuckle';
1292
explain select fld3 from t2 use index (fld1,fld3) where fld3 = 'honeysuckle';
1296
# The next should give an error
1300
explain select fld3 from t2 ignore index (fld3,not_used);
1302
explain select fld3 from t2 use index (not_used);
1305
# Test sorting with a used key (there is no need for sorting)
1308
select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;
1309
explain select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;
1310
select fld1,fld3 from t2 where fld3="Colombo" or fld3 = "nondecreasing" order by fld3;
1313
# Search with a key having a constant with many occurrences
1314
# The table is read directly with read-next having fld3 to get the
1318
select fld1,fld3 from t2 where companynr = 37 and fld3 = 'appendixes';
1321
# Search with bunched 'or's.
1322
# If one can limit the key to a certain interval only the possible
1323
# alternatives will be gone through
1326
select fld1 from t2 where fld1=250501 or fld1="250502";
1327
explain select fld1 from t2 where fld1=250501 or fld1="250502";
1328
select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 and fld1 <= 250601 or fld1 between 250501 and 250502;
1329
explain select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 and fld1 <= 250601 or fld1 between 250501 and 250502;
1332
# Search with a key with LIKE constant
1333
# If the like starts with a certain letter key will be used.
1336
select fld1,fld3 from t2 where companynr = 37 and fld3 like 'f%';
1337
select fld3 from t2 where fld3 like "L%" and fld3 = "ok";
1338
select fld3 from t2 where (fld3 like "C%" and fld3 = "Chantilly");
1339
select fld1,fld3 from t2 where fld1 like "25050%";
1340
select fld1,fld3 from t2 where fld1 like "25050_";
1343
# Search using distinct. An automatic grouping will be done over all the fields,
1344
# if only distinct is used. In any other case a temporary table will always
1345
# be created. If only the field used for sorting is from the main register,
1346
# it will be sorted first before the distinct table is created.
1349
select distinct companynr from t2;
1350
select distinct companynr from t2 order by companynr;
1351
select distinct companynr from t2 order by companynr desc;
1352
select distinct t2.fld3,period from t2,t1 where companynr=37 and fld3 like "O%";
1354
select distinct fld3 from t2 where companynr = 34 order by fld3;
1355
select distinct fld3 from t2 limit 10;
1356
select distinct fld3 from t2 having fld3 like "A%" limit 10;
1357
select distinct substring(fld3,1,3) from t2 where fld3 like "A%";
1358
select distinct substring(fld3,1,3) as a from t2 having a like "A%" order by a limit 10;
1359
select distinct substring(fld3,1,3) from t2 where fld3 like "A%" limit 10;
1360
select distinct substring(fld3,1,3) as a from t2 having a like "A%" limit 10;
1365
period int not null,
1366
name char(32) not null,
1367
companynr int not null,
1369
price2 double(11,0),
1375
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1001,"Iranizes",37,5987435,234724);
1376
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1002,"violinist",37,28357832,8723648);
1377
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1003,"extramarital",37,39654943,235872);
1378
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1004,"spates",78,726498,72987523);
1379
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1005,"cloakroom",78,98439034,823742);
1380
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1006,"gazer",101,834598,27348324);
1381
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1007,"hand",154,983543950,29837423);
1382
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1008,"tucked",311,234298,3275892);
1383
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1009,"gems",447,2374834,9872392);
1384
INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1010,"clinker",512,786542,76234234);
1387
create temporary table tmp engine = myisam select * from t3;
1389
insert into t3 select * from tmp;
1390
insert into tmp select * from t3;
1391
insert into t3 select * from tmp;
1392
insert into tmp select * from t3;
1393
insert into t3 select * from tmp;
1394
insert into tmp select * from t3;
1395
insert into t3 select * from tmp;
1396
insert into tmp select * from t3;
1397
insert into t3 select * from tmp;
1398
insert into tmp select * from t3;
1399
insert into t3 select * from tmp;
1400
insert into tmp select * from t3;
1401
insert into t3 select * from tmp;
1402
insert into tmp select * from t3;
1403
insert into t3 select * from tmp;
1404
insert into tmp select * from t3;
1405
insert into t3 select * from tmp;
1406
#insert into tmp select * from t3;
1407
#insert into t3 select * from tmp;
1409
alter table t3 add t2nr int not null auto_increment primary key first;
1415
SET SQL_BIG_TABLES=1;
1416
select distinct concat(fld3," ",fld3) as namn from t2,t3 where t2.fld1=t3.t2nr order by namn limit 10;
1417
SET SQL_BIG_TABLES=0;
1418
select distinct concat(fld3," ",fld3) from t2,t3 where t2.fld1=t3.t2nr order by fld3 limit 10;
1419
select distinct fld5 from t2 limit 10;
1422
# Force use of remove_dupp
1425
select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;
1426
SET SQL_BIG_TABLES=1; # Force use of MyISAM
1427
select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;
1428
SET SQL_BIG_TABLES=0;
1429
select distinct fld3,repeat("a",length(fld3)),count(*) from t2 group by companynr,fld3 limit 100,10;
1432
# A big order by that should trigger a merge in filesort
1435
select distinct companynr,rtrim(space(512+companynr)) from t3 order by 1,2;
1438
# Search with distinct and order by with many table.
1441
select distinct fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by fld3;
1444
# Here the last fld3 is optimized away from the order by
1447
explain select t3.t2nr,fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by t3.t2nr,fld3;
1450
# Some test with ORDER BY and limit
1453
explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period;
1454
explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period limit 10;
1455
explain select * from t3 as t1,t3 where t1.period=t3.period order by t1.period limit 10;
1458
# Search with a constant table.
1461
select period from t1;
1462
select period from t1 where period=1900;
1463
select fld3,period from t1,t2 where fld1 = 011401 order by period;
1466
# Search with a constant table and several keyparts. (Rows are read only once
1467
# in the beginning of the search)
1470
select fld3,period from t2,t3 where t2.fld1 = 011401 and t2.fld1=t3.t2nr and t3.period=1001;
1472
explain select fld3,period from t2,t3 where t2.fld1 = 011401 and t3.t2nr=t2.fld1 and 1001 = t3.period;
1475
# Search with a constant table and several rows from another table
1478
select fld3,period from t2,t1 where companynr*10 = 37*10;
1481
# Search with a table reference and without a key.
1482
# t3 will be the main table.
1485
select fld3,period,price,price2 from t2,t3 where t2.fld1=t3.t2nr and period >= 1001 and period <= 1002 and t2.companynr = 37 order by fld3,period, price;
1488
# Search with an interval on a table with full key on reference table.
1489
# Here t2 will be the main table and only records matching the
1490
# t2nr will be checked.
1493
select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t2.fld1=t3.t2nr and period = 1001 and t2.companynr = 37;
1496
# We need another table for join stuff..
1500
companynr tinyint(2) unsigned zerofill NOT NULL default '00',
1501
companyname char(30) NOT NULL default '',
1502
PRIMARY KEY (companynr),
1503
UNIQUE KEY companyname(companyname)
1504
) ENGINE=MyISAM MAX_ROWS=50 PACK_KEYS=1 COMMENT='companynames';
1507
INSERT INTO t4 (companynr, companyname) VALUES (29,'company 1');
1508
INSERT INTO t4 (companynr, companyname) VALUES (34,'company 2');
1509
INSERT INTO t4 (companynr, companyname) VALUES (36,'company 3');
1510
INSERT INTO t4 (companynr, companyname) VALUES (37,'company 4');
1511
INSERT INTO t4 (companynr, companyname) VALUES (40,'company 5');
1512
INSERT INTO t4 (companynr, companyname) VALUES (41,'company 6');
1513
INSERT INTO t4 (companynr, companyname) VALUES (53,'company 7');
1514
INSERT INTO t4 (companynr, companyname) VALUES (58,'company 8');
1515
INSERT INTO t4 (companynr, companyname) VALUES (65,'company 9');
1516
INSERT INTO t4 (companynr, companyname) VALUES (68,'company 10');
1517
INSERT INTO t4 (companynr, companyname) VALUES (50,'company 11');
1518
INSERT INTO t4 (companynr, companyname) VALUES (00,'Unknown');
1522
# Test of stright join to force a full join.
1525
select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;
1527
select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;
1530
# Full join (same alias)
1533
select * from t1,t1 t12;
1534
select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >= 250501 and t22.fld1 <= 250505;
1537
# Test of left join.
1539
insert into t2 (fld1, companynr) values (999999,99);
1541
select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;
1542
select count(*) from t2 left join t4 using (companynr) where t4.companynr is not null;
1543
explain select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;
1544
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr is null;
1546
select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;
1547
select count(*) from t2 left join t4 using (companynr) where companynr is not null;
1548
explain select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;
1549
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr is null;
1550
delete from t2 where fld1=999999;
1553
# Test left join optimization
1555
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0;
1556
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0;
1557
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 and t4.companynr > 0;
1559
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0;
1560
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0;
1561
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 and companynr > 0;
1562
# Following can't be optimized
1563
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr is null;
1564
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0 or t4.companynr > 0;
1565
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where ifnull(t2.companynr,1)>0;
1567
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr is null;
1568
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0 or companynr > 0;
1569
explain select companynr,companyname from t4 left join t2 using (companynr) where ifnull(companynr,1)>0;
1575
select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;
1576
explain select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;
1579
# Search using 'or' with the same referens group.
1580
# An interval search will be done first with the first table and after that
1581
# the other table is referenced with a key with a 'test if key in use' for
1585
select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and period = 1008 or t2.fld1 = 38008 and t2.fld1 =t3.t2nr and period = 1008;
1587
select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t2.fld1=t3.t2nr and period>=1008 and period<=1009;
1589
select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t3.t2nr = 38208 or t3.t2nr = 38008) and t2.fld1=t3.t2nr and period>=1008 and period<=1009;
1592
# Test of many parenthesis levels
1595
select period from t1 where (((period > 0) or period < 10000 or (period = 1900)) and (period=1900 and period <= 1901) or (period=1903 and (period=1903)) and period>=1902) or ((period=1904 or period=1905) or (period=1906 or period>1907)) or (period=1908 and period = 1909);
1596
select period from t1 where ((period > 0 and period < 1) or (((period > 0 and period < 100) and (period > 10)) or (period > 10)) or (period > 0 and (period > 5 or period > 6)));
1598
select a.fld1 from t2 as a,t2 b where ((a.fld1 = 250501 and a.fld1=b.fld1) or a.fld1=250502 or a.fld1=250503 or (a.fld1=250505 and a.fld1<=b.fld1 and b.fld1>=a.fld1)) and a.fld1=b.fld1;
1600
select fld1 from t2 where fld1 in (250502,98005,98006,250503,250605,250606) and fld1 >=250502 and fld1 not in (250605,250606);
1602
select fld1 from t2 where fld1 between 250502 and 250504;
1604
select fld3 from t2 where (((fld3 like "_%L%" ) or (fld3 like "%ok%")) and ( fld3 like "L%" or fld3 like "G%")) and fld3 like "L%" ;
1607
# Group on one table.
1608
# optimizer: sort table by group and send rows.
1611
select count(*) from t1;
1612
select companynr,count(*),sum(fld1) from t2 group by companynr;
1613
select companynr,count(*) from t2 group by companynr order by companynr desc limit 5;
1614
select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";
1615
explain extended select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";
1616
select companynr,count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 group by companynr limit 3;
1617
select companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10;
1618
select /*! SQL_SMALL_RESULT */ companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10;
1619
select companynr,count(price),sum(price),min(price),max(price),avg(price) from t3 group by companynr ;
1620
select distinct mod(companynr,10) from t4 group by companynr;
1621
select distinct 1 from t4 group by companynr;
1622
select count(distinct fld1) from t2;
1623
select companynr,count(distinct fld1) from t2 group by companynr;
1624
select companynr,count(*) from t2 group by companynr;
1625
select companynr,count(distinct concat(fld1,repeat(65,1000))) from t2 group by companynr;
1626
select companynr,count(distinct concat(fld1,repeat(65,200))) from t2 group by companynr;
1627
select companynr,count(distinct floor(fld1/100)) from t2 group by companynr;
1628
select companynr,count(distinct concat(repeat(65,1000),floor(fld1/100))) from t2 group by companynr;
1631
# group with where on a key field
1634
select sum(fld1),fld3 from t2 where fld3="Romans" group by fld1 limit 10;
1635
select name,count(*) from t3 where name='cloakroom' group by name;
1636
select name,count(*) from t3 where name='cloakroom' and price>10 group by name;
1637
select count(*) from t3 where name='cloakroom' and price2=823742;
1638
select name,count(*) from t3 where name='cloakroom' and price2=823742 group by name;
1639
select name,count(*) from t3 where name >= "extramarital" and price <= 39654943 group by name;
1640
select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name;
1643
# Group with extra not group fields.
1646
select companynr|0,companyname from t4 group by 1;
1647
select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by t2.companynr order by companyname;
1648
select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name;
1651
# Calculation with group functions
1654
select sum(Period)/count(*) from t1;
1655
select companynr,count(price) as "count",sum(price) as "sum" ,abs(sum(price)/count(price)-avg(price)) as "diff",(0+count(price))*companynr as func from t3 group by companynr;
1656
select companynr,sum(price)/count(price) as avg from t3 group by companynr having avg > 70000000 order by avg;
1659
# Group with order on not first table
1660
# optimizer: sort table by group and write group records to tmp table.
1661
# sort tmp_table and send rows.
1664
select companynr,count(*) from t2 group by companynr order by 2 desc;
1665
select companynr,count(*) from t2 where companynr > 40 group by companynr order by 2 desc;
1666
select t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.companynr = 37 and t2.fld1 = t3.t2nr group by fld1,t2.fld4;
1669
# group by with many tables
1670
# optimizer: create tmp table with group-by uniq index.
1671
# write with update to tmp table.
1672
# sort tmp table according to order (or group if no order)
1676
select t3.companynr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 group by companynr,fld3;
1677
select t2.companynr,count(*),min(fld3),max(fld3),sum(price),avg(price) from t2,t3 where t3.companynr >= 30 and t3.companynr <= 58 and t3.t2nr = t2.fld1 and 1+1=2 group by t2.companynr;
1680
# group with many tables and long group on many tables. group on formula
1681
# optimizer: create tmp table with neaded fields
1682
# sort tmp table by group and calculate sums to new table
1683
# if different order by than group, sort tmp table
1687
select t3.companynr+0,t3.t2nr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 37 group by 1,t3.t2nr,fld3,fld3,fld3,fld3,fld3 order by fld1;
1690
# WHERE const folding
1691
# optimize: If there is a "field = const" part in the where, change all
1692
# instances of field in the and level to const.
1693
# All instances of const = const are checked once and removed.
1697
# Where -> t3.t2nr = 98005 and t2.fld1 = 98005
1700
select sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 and t3.t2nr = 38008 and t2.fld1 = 38008 or t2.fld1= t3.t2nr and t3.t2nr = 38008 and t2.fld1 = 38008;
1702
select t2.fld1,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 and t3.t2nr = 38008 and t2.fld1 = 38008 or t2.fld1 = t3.t2nr and t3.t2nr = 38008 and t2.fld1 = 38008 or t3.t2nr = t2.fld1 and t2.fld1 = 38008 group by t2.fld1;
1704
explain select fld3 from t2 where 1>2 or 2>3;
1705
explain select fld3 from t2 where fld1=fld1;
1711
select companynr,fld1 from t2 HAVING fld1=250501 or fld1=250502;
1712
select companynr,fld1 from t2 WHERE fld1>=250501 HAVING fld1<=250502;
1713
select companynr,count(*) as count,sum(fld1) as sum from t2 group by companynr having count > 40 and sum/count >= 120000;
1714
select companynr from t2 group by companynr having count(*) > 40 and sum(fld1)/count(*) >= 120000 ;
1715
select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by companyname having t2.companynr >= 40;
1718
# MIN(), MAX() and COUNT() optimizing
1721
select count(*) from t2;
1722
select count(*) from t2 where fld1 < 098024;
1723
# PS does correct pre-zero here. MySQL can't do it as it returns a number.
1724
--disable_ps_protocol
1725
select min(fld1) from t2 where fld1>= 098024;
1726
--enable_ps_protocol
1727
select max(fld1) from t2 where fld1>= 098024;
1728
select count(*) from t3 where price2=76234234;
1729
select count(*) from t3 where companynr=512 and price2=76234234;
1730
explain select min(fld1),max(fld1),count(*) from t2;
1731
# PS does correct pre-zero here. MySQL can't do it as it returns a number.
1732
--disable_ps_protocol
1733
select min(fld1),max(fld1),count(*) from t2;
1734
--enable_ps_protocol
1735
select min(t2nr),max(t2nr) from t3 where t2nr=2115 and price2=823742;
1736
select count(*),min(t2nr),max(t2nr) from t3 where name='spates' and companynr=78;
1737
select t2nr,count(*) from t3 where name='gems' group by t2nr limit 20;
1738
select max(t2nr) from t3 where price=983543950;
1744
select t1.period from t3 = t1 limit 1;
1745
select t1.period from t1 as t1 limit 1;
1746
select t1.period as "Nuvarande period" from t1 as t1 limit 1;
1747
select period as ok_period from t1 limit 1;
1748
select period as ok_period from t1 group by ok_period limit 1;
1749
select 1+1 as summa from t1 group by summa limit 1;
1750
select period as "Nuvarande period" from t1 group by "Nuvarande period" limit 1;
1753
# Some simple show commands
1757
show tables from test like "s%";
1758
show tables from test like "t?";
1759
# We mask out the Privileges column because it differs with embedded server
1760
--replace_column 8 #
1761
show full columns from t2;
1762
--replace_column 8 #
1763
show full columns from t2 from test like 'f%';
1764
--replace_column 8 #
1765
show full columns from t2 from test like 's%';
1768
drop table t4, t3, t2, t1;
1775
DO benchmark(100,1+1),1,1;
1778
# Bug #6449: do default;
1781
--error ER_PARSE_ERROR
1783
--error ER_BAD_FIELD_ERROR
1787
# random in WHERE clause
1791
id mediumint(8) unsigned NOT NULL auto_increment,
1792
pseudo varchar(35) NOT NULL default '',
1794
UNIQUE KEY pseudo (pseudo)
1796
INSERT INTO t1 (pseudo) VALUES ('test');
1797
INSERT INTO t1 (pseudo) VALUES ('test1');
1798
SELECT 1 as rnd1 from t1 where rand() > 2;
1802
# Test of bug with SUM(CASE...)
1805
CREATE TABLE t1 (gvid int(10) unsigned default NULL, hmid int(10) unsigned default NULL, volid int(10) unsigned default NULL, mmid int(10) unsigned default NULL, hdid int(10) unsigned default NULL, fsid int(10) unsigned default NULL, ctid int(10) unsigned default NULL, dtid int(10) unsigned default NULL, cost int(10) unsigned default NULL, performance int(10) unsigned default NULL, serialnumber bigint(20) unsigned default NULL, monitored tinyint(3) unsigned default '1', removed tinyint(3) unsigned default '0', target tinyint(3) unsigned default '0', dt_modified timestamp NOT NULL, name varchar(255) binary default NULL, description varchar(255) default NULL, UNIQUE KEY hmid (hmid,volid)) ENGINE=MyISAM;
1806
INSERT INTO t1 VALUES (200001,2,1,1,100,1,1,1,0,0,0,1,0,1,20020425060057,'\\\\ARKIVIO-TESTPDC\\E$',''),(200002,2,2,1,101,1,1,1,0,0,0,1,0,1,20020425060057,'\\\\ARKIVIO-TESTPDC\\C$',''),(200003,1,3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,20020425060427,'c:',NULL);
1807
CREATE TABLE t2 ( hmid int(10) unsigned default NULL, volid int(10) unsigned default NULL, sampletid smallint(5) unsigned default NULL, sampletime datetime default NULL, samplevalue bigint(20) unsigned default NULL, KEY idx1 (hmid,volid,sampletid,sampletime)) ENGINE=MyISAM;
1808
INSERT INTO t2 VALUES (1,3,10,'2002-06-01 08:00:00',35),(1,3,1010,'2002-06-01 12:00:01',35);
1809
# Disable PS becasue we get more warnings from PS than from normal execution
1810
--disable_ps_protocol
1811
SELECT a.gvid, (SUM(CASE b.sampletid WHEN 140 THEN b.samplevalue ELSE 0 END)) as the_success,(SUM(CASE b.sampletid WHEN 141 THEN b.samplevalue ELSE 0 END)) as the_fail,(SUM(CASE b.sampletid WHEN 142 THEN b.samplevalue ELSE 0 END)) as the_size,(SUM(CASE b.sampletid WHEN 143 THEN b.samplevalue ELSE 0 END)) as the_time FROM t1 a, t2 b WHERE a.hmid = b.hmid AND a.volid = b.volid AND b.sampletime >= 'wrong-date-value' AND b.sampletime < 'wrong-date-value' AND b.sampletid IN (140, 141, 142, 143) GROUP BY a.gvid;
1812
--enable_ps_protocol
1813
# Testing the same select with NULL's instead of invalid datetime values
1814
SELECT a.gvid, (SUM(CASE b.sampletid WHEN 140 THEN b.samplevalue ELSE 0 END)) as the_success,(SUM(CASE b.sampletid WHEN 141 THEN b.samplevalue ELSE 0 END)) as the_fail,(SUM(CASE b.sampletid WHEN 142 THEN b.samplevalue ELSE 0 END)) as the_size,(SUM(CASE b.sampletid WHEN 143 THEN b.samplevalue ELSE 0 END)) as the_time FROM t1 a, t2 b WHERE a.hmid = b.hmid AND a.volid = b.volid AND b.sampletime >= NULL AND b.sampletime < NULL AND b.sampletid IN (140, 141, 142, 143) GROUP BY a.gvid;
1818
# Test of bigint comparision
1821
create table t1 ( A_Id bigint(20) NOT NULL default '0', A_UpdateBy char(10) NOT NULL default '', A_UpdateDate bigint(20) NOT NULL default '0', A_UpdateSerial int(11) NOT NULL default '0', other_types bigint(20) NOT NULL default '0', wss_type bigint(20) NOT NULL default '0');
1822
INSERT INTO t1 VALUES (102935998719055004,'brade',1029359987,2,102935229116544068,102935229216544093);
1823
select wss_type from t1 where wss_type ='102935229216544106';
1824
select wss_type from t1 where wss_type ='102935229216544105';
1825
select wss_type from t1 where wss_type ='102935229216544104';
1826
select wss_type from t1 where wss_type ='102935229216544093';
1827
select wss_type from t1 where wss_type =102935229216544093;
1829
select 1+2,"aaaa",3.13*2.0 into @a,@b,@c;
1835
# Test of removing redundant braces in the FROM part
1836
# (We test each construct with the braced join to the left and right;
1837
# the latter case used to cause a syntax errors.)
1840
create table t1 (a int not null auto_increment primary key);
1841
insert into t1 values ();
1842
insert into t1 values ();
1843
insert into t1 values ();
1845
select * from (t1 as t2 left join t1 as t3 using (a)), t1;
1846
select * from t1, (t1 as t2 left join t1 as t3 using (a));
1848
select * from (t1 as t2 left join t1 as t3 using (a)) straight_join t1;
1849
select * from t1 straight_join (t1 as t2 left join t1 as t3 using (a));
1851
select * from (t1 as t2 left join t1 as t3 using (a)) inner join t1 on t1.a>1;
1852
select * from t1 inner join (t1 as t2 left join t1 as t3 using (a)) on t1.a>1;
1854
select * from (t1 as t2 left join t1 as t3 using (a)) inner join t1 using ( a );
1855
select * from t1 inner join (t1 as t2 left join t1 as t3 using (a)) using ( a );
1856
# left [outer] join on
1857
select * from (t1 as t2 left join t1 as t3 using (a)) left outer join t1 on t1.a>1;
1858
select * from t1 left outer join (t1 as t2 left join t1 as t3 using (a)) on t1.a>1;
1860
select * from (t1 as t2 left join t1 as t3 using (a)) left join t1 using ( a );
1861
select * from t1 left join (t1 as t2 left join t1 as t3 using (a)) using ( a );
1863
select * from (t1 as t2 left join t1 as t3 using (a)) natural left join t1;
1864
select * from t1 natural left join (t1 as t2 left join t1 as t3 using (a));
1866
select * from (t1 as t2 left join t1 as t3 using (a)) right join t1 on t1.a>1;
1867
select * from t1 right join (t1 as t2 left join t1 as t3 using (a)) on t1.a>1;
1868
# right [outer] joing using
1869
select * from (t1 as t2 left join t1 as t3 using (a)) right outer join t1 using ( a );
1870
select * from t1 right outer join (t1 as t2 left join t1 as t3 using (a)) using ( a );
1871
# natural right join
1872
select * from (t1 as t2 left join t1 as t3 using (a)) natural right join t1;
1873
select * from t1 natural right join (t1 as t2 left join t1 as t3 using (a));
1875
select * from t1 natural join (t1 as t2 left join t1 as t3 using (a));
1876
select * from (t1 as t2 left join t1 as t3 using (a)) natural join t1;
1879
CREATE TABLE t1 ( aa char(2), id int(11) NOT NULL auto_increment, t2_id int(11) NOT NULL default '0', PRIMARY KEY (id), KEY replace_id (t2_id)) ENGINE=MyISAM;
1880
INSERT INTO t1 VALUES ("1",8264,2506),("2",8299,2517),("3",8301,2518),("4",8302,2519),("5",8303,2520),("6",8304,2521),("7",8305,2522);
1881
CREATE TABLE t2 ( id int(11) NOT NULL auto_increment, PRIMARY KEY (id)) ENGINE=MyISAM;
1882
INSERT INTO t2 VALUES (2517), (2518), (2519), (2520), (2521), (2522);
1883
select * from t1, t2 WHERE t1.t2_id = t2.id and t1.t2_id > 0 order by t1.id LIMIT 0, 5;
1887
# outer join, impossible on condition, where, and usable key for range
1889
create table t1 (id1 int NOT NULL);
1890
create table t2 (id2 int NOT NULL);
1891
create table t3 (id3 int NOT NULL);
1892
create table t4 (id4 int NOT NULL, id44 int NOT NULL, KEY (id4));
1894
insert into t1 values (1);
1895
insert into t1 values (2);
1896
insert into t2 values (1);
1897
insert into t4 values (1,1);
1899
explain select * from t1 left join t2 on id1 = id2 left join t3 on id1 = id3
1900
left join t4 on id3 = id4 where id2 = 1 or id4 = 1;
1901
select * from t1 left join t2 on id1 = id2 left join t3 on id1 = id3
1902
left join t4 on id3 = id4 where id2 = 1 or id4 = 1;
1904
drop table t1,t2,t3,t4;
1909
create table t1(s varchar(10) not null);
1910
create table t2(s varchar(10) not null primary key);
1911
create table t3(s varchar(10) not null primary key);
1912
insert into t1 values ('one\t'), ('two\t');
1913
insert into t2 values ('one\r'), ('two\t');
1914
insert into t3 values ('one '), ('two\t');
1915
select * from t1 where s = 'one';
1916
select * from t2 where s = 'one';
1917
select * from t3 where s = 'one';
1918
select * from t1,t2 where t1.s = t2.s;
1919
select * from t2,t3 where t2.s = t3.s;
1920
drop table t1, t2, t3;
1924
# Both queries should produce identical plans and results.
1926
create table t1 (a integer, b integer, index(a), index(b));
1927
create table t2 (c integer, d integer, index(c), index(d));
1928
insert into t1 values (1,2), (2,2), (3,2), (4,2);
1929
insert into t2 values (1,3), (2,3), (3,4), (4,4);
1930
explain select * from t1 left join t2 on a=c where d in (4);
1931
select * from t1 left join t2 on a=c where d in (4);
1932
explain select * from t1 left join t2 on a=c where d = 4;
1933
select * from t1 left join t2 on a=c where d = 4;
1937
# Covering index is mentioned in EXPLAIN output for const tables (bug #5333)
1941
i int(11) NOT NULL default '0',
1942
c char(10) NOT NULL default '',
1947
INSERT INTO t1 VALUES (1,'a');
1948
INSERT INTO t1 VALUES (2,'b');
1949
INSERT INTO t1 VALUES (3,'c');
1951
EXPLAIN SELECT i FROM t1 WHERE i=1;
1956
# Test case for bug 7520: a wrong cost of the index for a BLOB field
1959
CREATE TABLE t1 ( a BLOB, INDEX (a(20)) );
1960
CREATE TABLE t2 ( a BLOB, INDEX (a(20)) );
1962
INSERT INTO t1 VALUES ('one'),('two'),('three'),('four'),('five');
1963
INSERT INTO t2 VALUES ('one'),('two'),('three'),('four'),('five');
1965
EXPLAIN SELECT * FROM t1 LEFT JOIN t2 USE INDEX (a) ON t1.a=t2.a;
1966
EXPLAIN SELECT * FROM t1 LEFT JOIN t2 FORCE INDEX (a) ON t1.a=t2.a;
1971
# Test case for bug 7098: substitution of a constant for a string field
1974
CREATE TABLE t1 ( city char(30) );
1975
INSERT INTO t1 VALUES ('London');
1976
INSERT INTO t1 VALUES ('Paris');
1978
SELECT * FROM t1 WHERE city='London';
1979
SELECT * FROM t1 WHERE city='london';
1980
EXPLAIN SELECT * FROM t1 WHERE city='London' AND city='london';
1981
SELECT * FROM t1 WHERE city='London' AND city='london';
1982
EXPLAIN SELECT * FROM t1 WHERE city LIKE '%london%' AND city='London';
1983
SELECT * FROM t1 WHERE city LIKE '%london%' AND city='London';
1988
# Bug#7425 inconsistent sort order on unsigned columns result of substraction
1991
create table t1 (a int(11) unsigned, b int(11) unsigned);
1992
insert into t1 values (1,0), (1,1), (1,2);
1993
select a-b from t1 order by 1;
1994
select a-b , (a-b < 0) from t1 order by 1;
1995
select a-b as d, (a-b >= 0), b from t1 group by b having d >= 0;
1996
select cast((a - b) as unsigned) from t1 order by 1;
2001
# Bug#8733 server accepts malformed query (multiply mentioned distinct)
2003
create table t1 (a int(11));
2004
select all all * from t1;
2005
select distinct distinct * from t1;
2007
select all distinct * from t1;
2009
select distinct all * from t1;
2013
# Test for BUG#10095
2016
kunde_intern_id int(10) unsigned NOT NULL default '0',
2017
kunde_id int(10) unsigned NOT NULL default '0',
2018
FK_firma_id int(10) unsigned NOT NULL default '0',
2019
aktuell enum('Ja','Nein') NOT NULL default 'Ja',
2020
vorname varchar(128) NOT NULL default '',
2021
nachname varchar(128) NOT NULL default '',
2022
geloescht enum('Ja','Nein') NOT NULL default 'Nein',
2023
firma varchar(128) NOT NULL default ''
2026
INSERT INTO t1 VALUES
2027
(3964,3051,1,'Ja','Vorname1','1Nachname','Nein','Print Schau XXXX'),
2028
(3965,3051111,1,'Ja','Vorname1111','1111Nachname','Nein','Print Schau XXXX');
2031
SELECT kunde_id ,FK_firma_id ,aktuell, vorname, nachname, geloescht FROM t1
2035
( '' != '' AND firma LIKE CONCAT('%', '', '%'))
2037
(vorname LIKE CONCAT('%', 'Vorname1', '%') AND
2038
nachname LIKE CONCAT('%', '1Nachname', '%') AND
2039
'Vorname1' != '' AND 'xxxx' != '')
2043
aktuell = 'Ja' AND geloescht = 'Nein' AND FK_firma_id = 2
2048
SELECT kunde_id ,FK_firma_id ,aktuell, vorname, nachname,
2053
aktuell = 'Ja' AND geloescht = 'Nein' AND FK_firma_id = 2
2057
( '' != '' AND firma LIKE CONCAT('%', '', '%') )
2059
( vorname LIKE CONCAT('%', 'Vorname1', '%') AND
2060
nachname LIKE CONCAT('%', '1Nachname', '%') AND 'Vorname1' != '' AND
2066
SELECT COUNT(*) FROM t1 WHERE
2067
( 0 OR (vorname LIKE '%Vorname1%' AND nachname LIKE '%1Nachname%' AND 1))
2068
AND FK_firma_id = 2;
2074
# Test for Bug#8009, SELECT failed on bigint unsigned when using HEX
2077
CREATE TABLE t1 (b BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY (b));
2078
INSERT INTO t1 VALUES (0x8000000000000000);
2079
SELECT b FROM t1 WHERE b=0x8000000000000000;
2083
# IN with outer join condition (BUG#9393)
2085
CREATE TABLE `t1` ( `gid` int(11) default NULL, `uid` int(11) default NULL);
2087
CREATE TABLE `t2` ( `ident` int(11) default NULL, `level` char(16) default NULL);
2088
INSERT INTO `t2` VALUES (0,'READ');
2090
CREATE TABLE `t3` ( `id` int(11) default NULL, `name` char(16) default NULL);
2091
INSERT INTO `t3` VALUES (1,'fs');
2093
select * from t3 left join t1 on t3.id = t1.uid, t2 where t2.ident in (0, t1.gid, t3.id, 0);
2095
drop table t1,t2,t3;
2097
# Test for BUG#11700
2099
acct_id int(11) NOT NULL default '0',
2100
profile_id smallint(6) default NULL,
2101
UNIQUE KEY t1$acct_id (acct_id),
2102
KEY t1$profile_id (profile_id)
2104
INSERT INTO t1 VALUES (132,17),(133,18);
2107
profile_id smallint(6) default NULL,
2108
queue_id int(11) default NULL,
2109
seq int(11) default NULL,
2110
KEY t2$queue_id (queue_id)
2112
INSERT INTO t2 VALUES (17,31,4),(17,30,3),(17,36,2),(17,37,1);
2115
id int(11) NOT NULL default '0',
2116
qtype int(11) default NULL,
2117
seq int(11) default NULL,
2118
warn_lvl int(11) default NULL,
2119
crit_lvl int(11) default NULL,
2120
rr1 tinyint(4) NOT NULL default '0',
2121
rr2 int(11) default NULL,
2122
default_queue tinyint(4) NOT NULL default '0',
2123
KEY t3$qtype (qtype),
2127
INSERT INTO t3 VALUES (30,1,29,NULL,NULL,0,NULL,0),(31,1,28,NULL,NULL,0,NULL,0),
2128
(36,1,34,NULL,NULL,0,NULL,0),(37,1,35,NULL,NULL,0,121,0);
2130
SELECT COUNT(*) FROM t1 a STRAIGHT_JOIN t2 pq STRAIGHT_JOIN t3 q
2132
(pq.profile_id = a.profile_id) AND (a.acct_id = 132) AND
2133
(pq.queue_id = q.id) AND (q.rr1 <> 1);
2135
drop table t1,t2,t3;
2138
# Bug #11482 Wrongly applied optimization was erroneously rejecting valid
2140
create table t1 (f1 int);
2141
insert into t1 values (1),(NULL);
2142
create table t2 (f2 int, f3 int, f4 int);
2143
create index idx1 on t2 (f4);
2144
insert into t2 values (1,2,3),(2,4,6);
2145
select A.f2 from t1 left join t2 A on A.f2 = f1 where A.f3=(select min(f3)
2146
from t2 C where A.f4 = C.f4) or A.f3 IS NULL;
2150
# Bug #11521 Negative integer keys incorrectly substituted for 0 during
2153
create table t2 (a tinyint unsigned);
2154
create index t2i on t2(a);
2155
insert into t2 values (0), (254), (255);
2156
explain select * from t2 where a > -1;
2157
select * from t2 where a > -1;
2161
# Bug #11745: SELECT ... FROM DUAL with WHERE condition
2164
CREATE TABLE t1 (a int, b int, c int);
2166
SELECT 50, 3, 3 FROM DUAL
2168
(SELECT * FROM t1 WHERE a = 50 AND b = 3);
2171
SELECT 50, 3, 3 FROM DUAL
2173
(SELECT * FROM t1 WHERE a = 50 AND b = 3);
2174
select found_rows();
2176
select count(*) from t1;
2177
select found_rows();
2178
select count(*) from t1 limit 2,3;
2179
select found_rows();
2180
select SQL_CALC_FOUND_ROWS count(*) from t1 limit 2,3;
2181
select found_rows();
2186
# Bug 7672 Unknown column error in order clause
2188
CREATE TABLE t1 (a INT, b INT);
2189
(SELECT a, b AS c FROM t1) ORDER BY c+1;
2190
(SELECT a, b AS c FROM t1) ORDER BY b+1;
2191
SELECT a, b AS c FROM t1 ORDER BY c+1;
2192
SELECT a, b AS c FROM t1 ORDER BY b+1;
2196
# Bug #13356 assertion failed in resolve_const_item()
2198
create table t1(f1 int, f2 int);
2199
create table t2(f3 int);
2200
select f1 from t1,t2 where f1=f2 and (f1,f2) = ((1,1));
2201
select f1 from t1,t2 where f1=f2 and (f1,NULL) = ((1,1));
2202
select f1 from t1,t2 where f1=f2 and (f1,f2) = ((1,NULL));
2203
insert into t1 values(1,1),(2,null);
2204
insert into t2 values(2);
2205
select * from t1,t2 where f1=f3 and (f1,f2) = (2,null);
2206
select * from t1,t2 where f1=f3 and (f1,f2) <=> (2,null);
2212
create table t1 (f1 int not null auto_increment primary key, f2 varchar(10));
2213
create table t11 like t1;
2214
insert into t1 values(1,""),(2,"");
2215
--replace_column 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X
2216
show table status like 't1%';
2217
select 123 as a from t1 where f1 is null;
2221
# Bug #3874 (function in GROUP and LEFT JOIN)
2224
CREATE TABLE t1 ( a INT NOT NULL, b INT NOT NULL, UNIQUE idx (a,b) );
2225
INSERT INTO t1 VALUES (1,1),(1,2),(1,3),(1,4);
2226
CREATE TABLE t2 ( a INT NOT NULL, b INT NOT NULL, e INT );
2227
INSERT INTO t2 VALUES ( 1,10,1), (1,10,2), (1,11,1), (1,11,2), (1,2,1), (1,2,2),(1,2,3);
2228
SELECT t2.a, t2.b, IF(t1.b IS NULL,'',e) AS c, COUNT(*) AS d FROM t2 LEFT JOIN
2229
t1 ON t2.a = t1.a AND t2.b = t1.b GROUP BY a, b, c;
2230
SELECT t2.a, t2.b, IF(t1.b IS NULL,'',e) AS c, COUNT(*) AS d FROM t2 LEFT JOIN
2231
t1 ON t2.a = t1.a AND t2.b = t1.b GROUP BY t1.a, t1.b, c;
2232
SELECT t2.a, t2.b, IF(t1.b IS NULL,'',e) AS c, COUNT(*) AS d FROM t2 LEFT JOIN
2233
t1 ON t2.a = t1.a AND t2.b = t1.b GROUP BY t2.a, t2.b, c;
2234
SELECT t2.a, t2.b, IF(t1.b IS NULL,'',e) AS c, COUNT(*) AS d FROM t2,t1
2235
WHERE t2.a = t1.a AND t2.b = t1.b GROUP BY a, b, c;
2236
DROP TABLE IF EXISTS t1, t2;
2239
# Bug #13855 select distinct with group by caused server crash
2241
create table t1 (f1 int primary key, f2 int);
2242
create table t2 (f3 int, f4 int, primary key(f3,f4));
2243
insert into t1 values (1,1);
2244
insert into t2 values (1,1),(1,2);
2245
select distinct count(f2) >0 from t1 left join t2 on f1=f3 group by f1;
2249
# Bug #14482 Server crash when subselecting from the same table
2251
create table t1 (f1 int,f2 int);
2252
insert into t1 values(1,1);
2253
create table t2 (f3 int, f4 int, primary key(f3,f4));
2254
insert into t2 values(1,1);
2255
select * from t1 where f1 in (select f3 from t2 where (f3,f4)= (select f3,f4 from t2));
2259
# Bug #4981: 4.x and 5.x produce non-optimal execution path, 3.23 regression test failure
2261
CREATE TABLE t1(a int, b int, c int, KEY b(b), KEY c(c));
2262
insert into t1 values (1,0,0),(2,0,0);
2263
CREATE TABLE t2 (a int, b varchar(2), c varchar(2), PRIMARY KEY(a));
2264
insert into t2 values (1,'',''), (2,'','');
2265
CREATE TABLE t3 (a int, b int, PRIMARY KEY (a,b), KEY a (a), KEY b (b));
2266
insert into t3 values (1,1),(1,2);
2267
# must have "range checked" for t2
2268
explain select straight_join DISTINCT t2.a,t2.b, t1.c from t1, t3, t2
2269
where (t1.c=t2.a or (t1.c=t3.a and t2.a=t3.b)) and t1.b=556476786 and
2270
t2.b like '%%' order by t2.b limit 0,1;
2271
DROP TABLE t1,t2,t3;
2274
# Bug #17873: confusing error message when IGNORE INDEX refers a column name
2277
CREATE TABLE t1 (a int, INDEX idx(a));
2278
INSERT INTO t1 VALUES (2), (3), (1);
2280
EXPLAIN SELECT * FROM t1 IGNORE INDEX (idx);
2282
EXPLAIN SELECT * FROM t1 IGNORE INDEX (a);
2284
EXPLAIN SELECT * FROM t1 FORCE INDEX (a);
2289
# Bug #21019: First result of SELECT COUNT(*) different than consecutive runs
2291
CREATE TABLE t1 (a int, b int);
2292
INSERT INTO t1 VALUES (1,1), (2,1), (4,10);
2294
CREATE TABLE t2 (a int PRIMARY KEY, b int, KEY b (b));
2295
INSERT INTO t2 VALUES (1,NULL), (2,10);
2296
ALTER TABLE t1 ENABLE KEYS;
2298
EXPLAIN SELECT STRAIGHT_JOIN SQL_NO_CACHE COUNT(*) FROM t2, t1 WHERE t1.b = t2.b OR t2.b IS NULL;
2299
SELECT STRAIGHT_JOIN SQL_NO_CACHE * FROM t2, t1 WHERE t1.b = t2.b OR t2.b IS NULL;
2300
EXPLAIN SELECT STRAIGHT_JOIN SQL_NO_CACHE COUNT(*) FROM t2, t1 WHERE t1.b = t2.b OR t2.b IS NULL;
2301
SELECT STRAIGHT_JOIN SQL_NO_CACHE * FROM t2, t1 WHERE t1.b = t2.b OR t2.b IS NULL;
2302
DROP TABLE IF EXISTS t1,t2;
2305
# Bug #20954 "avg(keyval) retuns 0.38 but max(keyval) returns an empty set"
2307
--disable_ps_protocol
2308
CREATE TABLE t1 (key1 float default NULL, UNIQUE KEY key1 (key1));
2309
CREATE TABLE t2 (key2 float default NULL, UNIQUE KEY key2 (key2));
2310
INSERT INTO t1 VALUES (0.3762),(0.3845),(0.6158),(0.7941);
2311
INSERT INTO t2 VALUES (1.3762),(1.3845),(1.6158),(1.7941);
2313
explain select max(key1) from t1 where key1 <= 0.6158;
2314
explain select max(key2) from t2 where key2 <= 1.6158;
2315
explain select min(key1) from t1 where key1 >= 0.3762;
2316
explain select min(key2) from t2 where key2 >= 1.3762;
2317
explain select max(key1), min(key2) from t1, t2
2318
where key1 <= 0.6158 and key2 >= 1.3762;
2319
explain select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;
2320
explain select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;
2322
select max(key1) from t1 where key1 <= 0.6158;
2323
select max(key2) from t2 where key2 <= 1.6158;
2324
select min(key1) from t1 where key1 >= 0.3762;
2325
select min(key2) from t2 where key2 >= 1.3762;
2326
select max(key1), min(key2) from t1, t2
2327
where key1 <= 0.6158 and key2 >= 1.3762;
2328
select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;
2329
select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;
2332
--enable_ps_protocol
2335
# Bug #18759 "Incorrect string to numeric conversion"
2337
# This test is here so that the behavior will not be changed to 4.1
2338
# and not to 5.0 either. In 4.1 and 5.0 sending an integer as a string
2339
# will be converted internally to real (double) value and it is not
2340
# as accurate as bigint (longlong) for integers. Thus the results may
2341
# vary. In 5.1 internally it is decimal, which is a string type and
2342
# will be more accurate. Due to rather big changes needed to fix this
2343
# in 4.1 or 5.0 it is not desired to do it in the stable versions.
2345
# This test is here only to make sure that behavior is not changed in
2348
CREATE TABLE t1 (i BIGINT UNSIGNED NOT NULL);
2349
INSERT INTO t1 VALUES (10);
2350
SELECT i='1e+01',i=1e+01, i in (1e+01,1e+01), i in ('1e+01','1e+01') FROM t1;
2354
# Bug #22533: storing large hex strings
2357
create table t1(a bigint unsigned, b bigint);
2358
insert into t1 values (0xfffffffffffffffff, 0xfffffffffffffffff),
2359
(0x10000000000000000, 0x10000000000000000),
2360
(0x8fffffffffffffff, 0x8fffffffffffffff);
2361
select hex(a), hex(b) from t1;
2365
# Bug #32103: optimizer crash when join on int and mediumint with variable in
2369
CREATE TABLE t1 (c0 int);
2370
CREATE TABLE t2 (c0 int);
2372
# We need any variable that:
2373
# 1. has integer type,
2374
# 2. can be used with the "@@name" syntax
2375
# 3. available in every server build
2376
INSERT INTO t1 VALUES(@@connect_timeout);
2377
INSERT INTO t2 VALUES(@@connect_timeout);
2379
# We only need to ensure 1 row is returned to validate the results
2380
--replace_column 1 X 2 X
2381
SELECT * FROM t1 JOIN t2 ON t1.c0 = t2.c0 WHERE (t1.c0 <=> @@connect_timeout);
2385
--echo End of 4.1 tests
2388
# Test for bug #6474
2392
K2C4 varchar(4) character set latin1 collate latin1_bin NOT NULL default '',
2393
K4N4 varchar(4) character set latin1 collate latin1_bin NOT NULL default '0000',
2394
F2I4 int(11) NOT NULL default '0'
2395
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2397
INSERT INTO t1 VALUES
2398
('W%RT', '0100', 1),
2399
('W-RT', '0100', 1),
2400
('WART', '0100', 1),
2401
('WART', '0200', 1),
2402
('WERT', '0100', 2),
2405
('W_RT', '0100', 2),
2406
('WaRT', '0100', 3),
2407
('WART', '0300', 3),
2408
('WRT' , '0400', 3),
2409
('WURM', '0500', 3),
2411
('WA%T', '0700', 4),
2412
('WA_T', '0800', 4);
2414
SELECT K2C4, K4N4, F2I4 FROM t1
2415
WHERE K2C4 = 'WART' AND
2416
(F2I4 = 2 AND K2C4 = 'WART' OR (F2I4 = 2 OR K4N4 = '0200'));
2417
SELECT K2C4, K4N4, F2I4 FROM t1
2418
WHERE K2C4 = 'WART' AND (K2C4 = 'WART' OR K4N4 = '0200');
2424
create table t1 (a int, b int);
2425
create table t2 like t1;
2426
select t1.a from (t1 inner join t2 on t1.a=t2.a) where t2.a=1;
2427
select t1.a from ((t1 inner join t2 on t1.a=t2.a)) where t2.a=1;
2428
select x.a, y.a, z.a from ( (t1 x inner join t2 y on x.a=y.a) inner join t2 z on y.a=z.a) WHERE x.a=1;
2435
create table t1 (s1 varchar(5));
2436
insert into t1 values ('Wall');
2437
select min(s1) from t1 group by s1 with rollup;
2444
create table t1 (s1 int) engine=myisam;
2445
insert into t1 values (0);
2446
select avg(distinct s1) from t1 group by s1 with rollup;
2453
create table t1 (s1 int);
2454
insert into t1 values (null),(1);
2455
select distinct avg(s1) as x from t1 group by s1 with rollup;
2460
# Test for bug #10084: STRAIGHT_JOIN with ON expression
2463
CREATE TABLE t1 (a int);
2464
CREATE TABLE t2 (a int);
2465
INSERT INTO t1 VALUES (1), (2), (3), (4), (5);
2466
INSERT INTO t2 VALUES (2), (4), (6);
2468
SELECT t1.a FROM t1 STRAIGHT_JOIN t2 ON t1.a=t2.a;
2470
EXPLAIN SELECT t1.a FROM t1 STRAIGHT_JOIN t2 ON t1.a=t2.a;
2471
EXPLAIN SELECT t1.a FROM t1 INNER JOIN t2 ON t1.a=t2.a;
2479
select x'10' + 0, X'10' + 0, b'10' + 0, B'10' + 0;
2482
# Bug #11398 Bug in field_conv() results in wrong result of join with index
2484
create table t1 (f1 varchar(6) default NULL, f2 int(6) primary key not null);
2485
create table t2 (f3 varchar(5) not null, f4 varchar(5) not null, UNIQUE KEY UKEY (f3,f4));
2486
insert into t1 values (" 2", 2);
2487
insert into t2 values (" 2", " one "),(" 2", " two ");
2488
select * from t1 left join t2 on f1 = f3;
2492
# Bug #6558 Views: CREATE VIEW fails with JOIN ... USING
2495
create table t1 (empnum smallint, grp int);
2496
create table t2 (empnum int, name char(5));
2497
insert into t1 values(1,1);
2498
insert into t2 values(1,'bob');
2499
create view v1 as select * from t2 inner join t1 using (empnum);
2505
# Bug #10646 Columns included in the join between two tables are ambigious
2509
create table t1 (pk int primary key, b int);
2510
create table t2 (pk int primary key, c int);
2511
select pk from t1 inner join t2 using (pk);
2515
# Bug #10972 Natural join of view and underlying table gives wrong result
2518
create table t1 (s1 int, s2 char(5), s3 decimal(10));
2519
create view v1 as select s1, s2, 'x' as s3 from t1;
2520
select * from t1 natural join v1;
2521
insert into t1 values (1,'x',5);
2522
select * from t1 natural join v1;
2527
# Bug #6276 A SELECT that does a NATURAL OUTER JOIN without common
2528
# columns crashes server because of empty ON condition
2531
create table t1(a1 int);
2532
create table t2(a2 int);
2533
insert into t1 values(1),(2);
2534
insert into t2 values(1),(2);
2535
create view v2 (c) as select a1 from t1;
2537
select * from t1 natural left join t2;
2538
select * from t1 natural right join t2;
2540
select * from v2 natural left join t2;
2541
select * from v2 natural right join t2;
2548
# Bug #4789 Incosistent results of more than 2-way natural joins due to
2549
# incorrect transformation to join ... on.
2552
create table t1 (a int(10), t1_val int(10));
2553
create table t2 (b int(10), t2_val int(10));
2554
create table t3 (a int(10), b int(10));
2555
insert into t1 values (1,1),(2,2);
2556
insert into t2 values (1,1),(2,2),(3,3);
2557
insert into t3 values (1,1),(2,1),(3,1),(4,1);
2558
# the following two queries must return the same result
2559
select * from t1 natural join t2 natural join t3;
2560
select * from t1 natural join t3 natural join t2;
2561
drop table t1, t2, t3;
2565
# Bug #12841: Server crash on DO IFNULL(NULL,NULL)
2567
# (testing returning of int, decimal, real, string)
2568
DO IFNULL(NULL, NULL);
2569
SELECT CAST(IFNULL(NULL, NULL) AS DECIMAL);
2570
SELECT ABS(IFNULL(NULL, NULL));
2571
SELECT IFNULL(NULL, NULL);
2574
# BUG #12595 (ESCAPE must be exactly one)
2576
SET @OLD_SQL_MODE12595=@@SQL_MODE, @@SQL_MODE='';
2577
SHOW LOCAL VARIABLES LIKE 'SQL_MODE';
2579
CREATE TABLE BUG_12595(a varchar(100));
2580
INSERT INTO BUG_12595 VALUES ('hakan%'), ('hakank'), ("ha%an");
2581
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan\%';
2582
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan*%' ESCAPE '*';
2584
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan**%' ESCAPE '**';
2585
# this should work when sql_mode is not NO_BACKSLASH_ESCAPES
2586
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan%' ESCAPE '';
2587
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan\%' ESCAPE '';
2588
SELECT * FROM BUG_12595 WHERE a LIKE 'ha\%an' ESCAPE 0x5c;
2589
SELECT * FROM BUG_12595 WHERE a LIKE 'ha%%an' ESCAPE '%';
2590
SELECT * FROM BUG_12595 WHERE a LIKE 'ha\%an' ESCAPE '\\';
2591
SELECT * FROM BUG_12595 WHERE a LIKE 'ha|%an' ESCAPE '|';
2593
SET @@SQL_MODE='NO_BACKSLASH_ESCAPES';
2594
SHOW LOCAL VARIABLES LIKE 'SQL_MODE';
2595
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan\%';
2596
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan*%' ESCAPE '*';
2598
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan**%' ESCAPE '**';
2600
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan\%' ESCAPE '\\';
2601
#this gives an error when NO_BACKSLASH_ESCAPES is set
2603
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan%' ESCAPE '';
2604
SELECT * FROM BUG_12595 WHERE a LIKE 'ha\%an' ESCAPE 0x5c;
2605
SELECT * FROM BUG_12595 WHERE a LIKE 'ha|%an' ESCAPE '|';
2607
SELECT * FROM BUG_12595 WHERE a LIKE 'hakan\n%' ESCAPE '\n';
2609
SET @@SQL_MODE=@OLD_SQL_MODE12595;
2610
DROP TABLE BUG_12595;
2613
# Bug #6495 Illogical requirement for column qualification in NATURAL join
2616
create table t1 (a char(1));
2617
create table t2 (a char(1));
2618
insert into t1 values ('a'),('b'),('c');
2619
insert into t2 values ('b'),('c'),('d');
2620
select a from t1 natural join t2;
2621
select * from t1 natural join t2 where a = 'b';
2625
# Bug #12977 Compare table names with qualifying field tables only
2626
# for base tables, search all nested join operands of natural joins.
2629
CREATE TABLE t1 (`id` TINYINT);
2630
CREATE TABLE t2 (`id` TINYINT);
2631
CREATE TABLE t3 (`id` TINYINT);
2632
INSERT INTO t1 VALUES (1),(2),(3);
2633
INSERT INTO t2 VALUES (2);
2634
INSERT INTO t3 VALUES (3);
2636
SELECT t1.id,t3.id FROM t1 JOIN t2 ON (t2.id=t1.id) LEFT JOIN t3 USING (id);
2638
SELECT t1.id,t3.id FROM t1 JOIN t2 ON (t2.notacolumn=t1.id) LEFT JOIN t3 USING (id);
2640
SELECT id,t3.id FROM t1 JOIN t2 ON (t2.id=t1.id) LEFT JOIN t3 USING (id);
2642
SELECT id,t3.id FROM (t1 JOIN t2 ON (t2.id=t1.id)) LEFT JOIN t3 USING (id);
2644
drop table t1, t2, t3;
2647
# Bug #13067 JOIN xxx USING is case sensitive
2650
create table t1 (a int(10),b int(10));
2651
create table t2 (a int(10),b int(10));
2652
insert into t1 values (1,10),(2,20),(3,30);
2653
insert into t2 values (1,10);
2654
# both queries should produce the same result
2655
select * from t1 inner join t2 using (A);
2656
select * from t1 inner join t2 using (a);
2660
# Bug #12943 Incorrect nesting of [INNER| CROSS] JOIN due to unspecified
2661
# associativity in the parser.
2664
create table t1 (a int, c int);
2665
create table t2 (b int);
2666
create table t3 (b int, a int);
2667
create table t4 (c int);
2668
insert into t1 values (1,1);
2669
insert into t2 values (1);
2670
insert into t3 values (1,1);
2671
insert into t4 values (1);
2673
select * from t1 join t2 join t3 on (t2.b = t3.b and t1.a = t3.a);
2674
# Notice that ',' has lower priority than 'join', thus we have that:
2675
# t1, t2 join t3 <==> t1, (t2 join t3).
2677
select * from t1, t2 join t3 on (t2.b = t3.b and t1.a = t3.a);
2678
select * from t1 join t2 join t3 join t4 on (t1.a = t4.c and t2.b = t4.c);
2679
select * from t1 join t2 join t4 using (c);
2680
drop table t1, t2, t3, t4;
2683
# Bug #12291 Table wasn't reinited for index scan after sequential scan
2685
create table t1(x int, y int);
2686
create table t2(x int, y int);
2687
create table t3(x int, primary key(x));
2688
insert into t1 values (1, 1), (2, 1), (3, 1), (4, 3), (5, 6), (6, 6);
2689
insert into t2 values (1, 1), (2, 1), (3, 3), (4, 6), (5, 6);
2690
insert into t3 values (1), (2), (3), (4), (5);
2691
select t1.x, t3.x from t1, t2, t3 where t1.x = t2.x and t3.x >= t1.y and t3.x <= t2.y;
2692
drop table t1,t2,t3;
2695
# Bug #13127 LEFT JOIN against a VIEW returns NULL instead of correct value
2698
create table t1 (id char(16) not null default '', primary key (id));
2699
insert into t1 values ('100'),('101'),('102');
2700
create table t2 (id char(16) default null);
2701
insert into t2 values (1);
2702
create view v1 as select t1.id from t1;
2703
create view v2 as select t2.id from t2;
2704
create view v3 as select (t1.id+2) as id from t1 natural left join t2;
2706
# all queries must return the same result
2707
select t1.id from t1 left join v2 using (id);
2708
select t1.id from v2 right join t1 using (id);
2709
select t1.id from t1 left join v3 using (id);
2710
select * from t1 left join v2 using (id);
2711
select * from v2 right join t1 using (id);
2712
select * from t1 left join v3 using (id);
2714
select v1.id from v1 left join v2 using (id);
2715
select v1.id from v2 right join v1 using (id);
2716
select v1.id from v1 left join v3 using (id);
2717
select * from v1 left join v2 using (id);
2718
select * from v2 right join v1 using (id);
2719
select * from v1 left join v3 using (id);
2722
drop view v1, v2, v3;
2725
# Bug #13597 Column in ON condition not resolved if references a table in
2726
# nested right join.
2729
create table t1 (id int(11) not null default '0');
2730
insert into t1 values (123),(191),(192);
2731
create table t2 (id char(16) character set utf8 not null);
2732
insert into t2 values ('58013'),('58014'),('58015'),('58016');
2733
create table t3 (a_id int(11) not null, b_id char(16) character set utf8);
2734
insert into t3 values (123,null),(123,null),(123,null),(123,null),(123,null),(123,'58013');
2736
# both queries are equivalent
2738
from t1 inner join (t3 left join t2 on t2.id = t3.b_id) on t1.id = t3.a_id;
2741
from t1 inner join (t2 right join t3 on t2.id = t3.b_id) on t1.id = t3.a_id;
2743
drop table t1,t2,t3;
2746
# Bug #13832 Incorrect parse order of join productions due to unspecified
2747
# operator priorities results in incorrect join tree.
2750
create table t1 (a int);
2751
create table t2 (b int);
2752
create table t3 (c int);
2753
select * from t1 join t2 join t3 on (t1.a=t3.c);
2754
select * from t1 join t2 left join t3 on (t1.a=t3.c);
2755
select * from t1 join t2 right join t3 on (t1.a=t3.c);
2756
select * from t1 join t2 straight_join t3 on (t1.a=t3.c);
2757
drop table t1, t2 ,t3;
2760
# Bug #14093 Query takes a lot of time when date format is not valid
2761
# fix optimizes execution. so here we just check that returned set is
2763
create table t1(f1 int, f2 date);
2764
insert into t1 values(1,'2005-01-01'),(2,'2005-09-01'),(3,'2005-09-30'),
2765
(4,'2005-10-01'),(5,'2005-12-30');
2766
# should return all records
2767
select * from t1 where f2 >= 0 order by f2;
2768
select * from t1 where f2 >= '0000-00-00' order by f2;
2770
select * from t1 where f2 >= '2005-09-31' order by f2;
2771
select * from t1 where f2 >= '2005-09-3a' order by f2;
2772
# should return 1,2,3
2773
select * from t1 where f2 <= '2005-09-31' order by f2;
2774
select * from t1 where f2 <= '2005-09-3a' order by f2;
2778
# Bug ##14662 ORDER BY on column of a view, with an alias of the same
2779
# column causes ambiguous
2782
create table t1 (f1 int, f2 int);
2783
insert into t1 values (1, 30), (2, 20), (3, 10);
2784
create algorithm=merge view v1 as select f1, f2 from t1;
2785
create algorithm=merge view v2 (f2, f1) as select f1, f2 from t1;
2786
create algorithm=merge view v3 as select t1.f1 as f2, t1.f2 as f1 from t1;
2787
select t1.f1 as x1, f1 from t1 order by t1.f1;
2788
select v1.f1 as x1, f1 from v1 order by v1.f1;
2789
select v2.f1 as x1, f1 from v2 order by v2.f1;
2790
select v3.f1 as x1, f1 from v3 order by v3.f1;
2791
select f1, f2, v1.f1 as x1 from v1 order by v1.f1;
2792
select f1, f2, v2.f1 as x1 from v2 order by v2.f1;
2793
select f1, f2, v3.f1 as x1 from v3 order by v3.f1;
2795
drop view v1, v2, v3;
2798
# Bug #15106: lost equality predicate of the form field=const in a join query
2801
CREATE TABLE t1(key_a int4 NOT NULL, optimus varchar(32), PRIMARY KEY(key_a));
2802
CREATE TABLE t2(key_a int4 NOT NULL, prime varchar(32), PRIMARY KEY(key_a));
2803
CREATE table t3(key_a int4 NOT NULL, key_b int4 NOT NULL, foo varchar(32),
2804
PRIMARY KEY(key_a,key_b));
2806
INSERT INTO t1 VALUES (0,'');
2807
INSERT INTO t1 VALUES (1,'i');
2808
INSERT INTO t1 VALUES (2,'j');
2809
INSERT INTO t1 VALUES (3,'k');
2811
INSERT INTO t2 VALUES (1,'r');
2812
INSERT INTO t2 VALUES (2,'s');
2813
INSERT INTO t2 VALUES (3,'t');
2815
INSERT INTO t3 VALUES (1,5,'x');
2816
INSERT INTO t3 VALUES (1,6,'y');
2817
INSERT INTO t3 VALUES (2,5,'xx');
2818
INSERT INTO t3 VALUES (2,6,'yy');
2819
INSERT INTO t3 VALUES (2,7,'zz');
2820
INSERT INTO t3 VALUES (3,5,'xxx');
2823
FROM t1 INNER JOIN t2 ON t1.key_a = t2.key_a
2824
INNER JOIN t3 ON t1.key_a = t3.key_a
2825
WHERE t2.key_a=2 and key_b=5;
2826
EXPLAIN SELECT t2.key_a,foo
2827
FROM t1 INNER JOIN t2 ON t1.key_a = t2.key_a
2828
INNER JOIN t3 ON t1.key_a = t3.key_a
2829
WHERE t2.key_a=2 and key_b=5;
2832
FROM t1 INNER JOIN t2 ON t2.key_a = t1.key_a
2833
INNER JOIN t3 ON t1.key_a = t3.key_a
2834
WHERE t2.key_a=2 and key_b=5;
2835
EXPLAIN SELECT t2.key_a,foo
2836
FROM t1 INNER JOIN t2 ON t2.key_a = t1.key_a
2837
INNER JOIN t3 ON t1.key_a = t3.key_a
2838
WHERE t2.key_a=2 and key_b=5;
2840
DROP TABLE t1,t2,t3;
2843
# Bug#15347 Wrong result of subselect when records cache and set functions
2846
create table t1 (f1 int);
2847
insert into t1 values(1),(2);
2848
create table t2 (f2 int, f3 int, key(f2));
2849
insert into t2 values(1,1),(2,2);
2850
create table t3 (f4 int not null);
2851
insert into t3 values (2),(2),(2);
2852
select f1,(select count(*) from t2,t3 where f2=f1 and f3=f4) as count from t1;
2853
drop table t1,t2,t3;
2856
# Bug #15633 Evaluation of Item_equal for non-const table caused wrong
2859
create table t1 (f1 int unique);
2860
create table t2 (f2 int unique);
2861
create table t3 (f3 int unique);
2862
insert into t1 values(1),(2);
2863
insert into t2 values(1),(2);
2864
insert into t3 values(1),(NULL);
2865
select * from t3 where f3 is null;
2866
select t2.f2 from t1 left join t2 on f1=f2 join t3 on f1=f3 where f1=1;
2867
drop table t1,t2,t3;
2870
# Bug#15268 Unchecked null value caused server crash
2872
create table t1(f1 char, f2 char not null);
2873
insert into t1 values(null,'a');
2874
create table t2 (f2 char not null);
2875
insert into t2 values('b');
2876
select * from t1 left join t2 on f1=t2.f2 where t1.f2='a';
2880
# Bug#15538 unchecked table absense caused server crash.
2883
select * from (select * left join t on f1=f2) tt;
2886
# Bug #16504: re-evaluation of Item_equal object after reading const table
2889
CREATE TABLE t1 (sku int PRIMARY KEY, pr int);
2890
CREATE TABLE t2 (sku int PRIMARY KEY, sppr int, name varchar(255));
2892
INSERT INTO t1 VALUES
2893
(10, 10), (20, 10), (30, 20), (40, 30), (50, 10), (60, 10);
2895
INSERT INTO t2 VALUES
2896
(10, 10, 'aaa'), (20, 10, 'bbb'), (30, 10, 'ccc'), (40, 20, 'ddd'),
2897
(50, 10, 'eee'), (60, 20, 'fff'), (70, 20, 'ggg'), (80, 30, 'hhh');
2899
SELECT t2.sku, t2.sppr, t2.name, t1.sku, t1.pr
2900
FROM t2, t1 WHERE t2.sku=20 AND (t2.sku=t1.sku OR t2.sppr=t1.sku);
2902
SELECT t2.sku, t2.sppr, t2.name, t1.sku, t1.pr
2903
FROM t2, t1 WHERE t2.sku=20 AND (t2.sku=t1.sku OR t2.sppr=t1.sku);
2909
# Bug#18712: Truncation problem (needs just documenting and test
2910
# cases to prevent fixing this accidently. It is intended behaviour)
2913
CREATE TABLE t1 (i TINYINT UNSIGNED NOT NULL);
2914
INSERT t1 SET i = 0;
2915
UPDATE t1 SET i = -1;
2917
UPDATE t1 SET i = CAST(i - 1 AS SIGNED);
2919
UPDATE t1 SET i = i - 1;
2925
create table t1 (a int);
2926
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2927
create table t2 (a int, b int, c int, e int, primary key(a,b,c));
2928
insert into t2 select A.a, B.a, C.a, C.a from t1 A, t1 B, t1 C;
2930
select 'In next EXPLAIN, B.rows must be exactly 10:' Z;
2932
explain select * from t2 A, t2 B where A.a=5 and A.b=5 and A.C<5
2933
and B.a=5 and B.b=A.e and (B.b =1 or B.b = 3 or B.b=5);
2937
#Bug #18940: selection of optimal execution plan caused by equality
2938
# propagation (the bug was fixed by the patch for bug #17379)
2940
CREATE TABLE t1 (a int PRIMARY KEY, b int, INDEX(b));
2941
INSERT INTO t1 VALUES (1, 3), (9,4), (7,5), (4,5), (6,2),
2942
(3,1), (5,1), (8,9), (2,2), (0,9);
2944
CREATE TABLE t2 (c int, d int, f int, INDEX(c,f));
2945
INSERT INTO t2 VALUES
2946
(1,0,0), (1,0,1), (2,0,0), (2,0,1), (3,0,0), (4,0,1),
2947
(5,0,0), (5,0,1), (6,0,0), (0,0,1), (7,0,0), (7,0,1),
2948
(0,0,0), (0,0,1), (8,0,0), (8,0,1), (9,0,0), (9,0,1);
2951
SELECT a, c, d, f FROM t1,t2 WHERE a=c AND b BETWEEN 4 AND 6;
2953
SELECT a, c, d, f FROM t1,t2 WHERE a=c AND b BETWEEN 4 AND 6 AND a > 0;
2958
# Bug #18895: BIT values cause joins to fail
2961
a int unsigned not null auto_increment primary key,
2967
a int unsigned not null auto_increment primary key,
2969
c int unsigned not null,
2973
insert into t1 (b,c) values (0,1), (0,1);
2974
insert into t2 (b,c) values (0,1);
2976
# Row 1 should succeed. Row 2 should fail. Both fail.
2977
select t1.a, t1.b + 0, t1.c + 0, t2.a, t2.b + 0, t2.c, t2.d
2978
from t1 left outer join t2 on t1.a = t2.c and t2.b <> 1
2979
where t1.b <> 1 order by t1.a;
2984
# Bug #20569: Garbage in DECIMAL results from some mathematical functions
2986
SELECT 0.9888889889 * 1.011111411911;
2989
# Bug #10977: No warning issued if a column name is truncated
2991
prepare stmt from 'select 1 as " a "';
2995
# Bug #21390: wrong estimate of rows after elimination of const tables
2998
CREATE TABLE t1 (a int NOT NULL PRIMARY KEY, b int NOT NULL);
2999
INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4);
3001
CREATE TABLE t2 (c int NOT NULL, INDEX idx(c));
3002
INSERT INTO t2 VALUES
3003
(1), (1), (1), (1), (1), (1), (1), (1),
3008
EXPLAIN SELECT b FROM t1, t2 WHERE b=c AND a=1;
3009
EXPLAIN SELECT b FROM t1, t2 WHERE b=c AND a=4;
3014
# No matches for a join after substitution of a const table
3017
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a int);
3018
INSERT INTO t1 VALUES (1,2), (2,NULL), (3,2);
3020
CREATE TABLE t2 (b int, c INT, INDEX idx1(b));
3021
INSERT INTO t2 VALUES (2,1), (3,2);
3023
CREATE TABLE t3 (d int, e int, INDEX idx1(d));
3024
INSERT INTO t3 VALUES (2,10), (2,20), (1,30), (2,40), (2,50);
3027
SELECT * FROM t1 LEFT JOIN t2 ON t2.b=t1.a INNER JOIN t3 ON t3.d=t1.id
3029
SELECT * FROM t1 LEFT JOIN t2 ON t2.b=t1.a INNER JOIN t3 ON t3.d=t1.id
3032
DROP TABLE t1,t2,t3;
3035
# Bug#20503: Server crash due to the ORDER clause isn't taken into account
3036
# while space allocation
3038
create table t1 (c1 varchar(1), c2 int, c3 int, c4 int, c5 int, c6 int,
3039
c7 int, c8 int, c9 int, fulltext key (`c1`));
3040
select distinct match (`c1`) against ('z') , c2, c3, c4,c5, c6,c7, c8
3041
from t1 where c9=1 order by c2, c2;
3045
# Bug #22735: no equality propagation for BETWEEN and IN with STRING arguments
3048
CREATE TABLE t1 (pk varchar(10) PRIMARY KEY, fk varchar(16));
3049
CREATE TABLE t2 (pk varchar(16) PRIMARY KEY, fk varchar(10));
3051
INSERT INTO t1 VALUES
3052
('d','dddd'), ('i','iii'), ('a','aa'), ('b','bb'), ('g','gg'),
3053
('e','eee'), ('c','cccc'), ('h','hhh'), ('j','jjj'), ('f','fff');
3054
INSERT INTO t2 VALUES
3055
('jjj', 'j'), ('cc','c'), ('ccc','c'), ('aaa', 'a'), ('jjjj','j'),
3056
('hhh','h'), ('gg','g'), ('fff','f'), ('ee','e'), ('ffff','f'),
3057
('bbb','b'), ('ff','f'), ('cccc','c'), ('dddd','d'), ('jj','j'),
3058
('aaaa','a'), ('bb','b'), ('eeee','e'), ('aa','a'), ('hh','h');
3061
FROM t1 JOIN t2 ON t2.fk=t1.pk
3062
WHERE t2.fk < 'c' AND t2.pk=t1.fk;
3064
FROM t1 JOIN t2 ON t2.fk=t1.pk
3065
WHERE t2.fk BETWEEN 'a' AND 'b' AND t2.pk=t1.fk;
3067
FROM t1 JOIN t2 ON t2.fk=t1.pk
3068
WHERE t2.fk IN ('a','b') AND t2.pk=t1.fk;
3073
# Bug #22367: Optimizer uses ref join type instead of eq_ref for simple
3076
CREATE TABLE t1 (a int, b varchar(20) NOT NULL, PRIMARY KEY(a));
3077
CREATE TABLE t2 (a int, b varchar(20) NOT NULL,
3078
PRIMARY KEY (a), UNIQUE KEY (b));
3079
INSERT INTO t1 VALUES (1,'a'),(2,'b'),(3,'c');
3080
INSERT INTO t2 VALUES (1,'a'),(2,'b'),(3,'c');
3082
EXPLAIN SELECT t1.a FROM t1 LEFT JOIN t2 ON t2.b=t1.b WHERE t1.a=3;
3087
# Bug #19579: predicates that become sargable after reading const tables
3088
# are not taken into account by optimizer
3091
CREATE TABLE t1(id int PRIMARY KEY, b int, e int);
3092
CREATE TABLE t2(i int, a int, INDEX si(i), INDEX ai(a));
3093
CREATE TABLE t3(a int PRIMARY KEY, c char(4), INDEX ci(c));
3095
INSERT INTO t1 VALUES
3096
(1,10,19), (2,20,22), (4,41,42), (9,93,95), (7, 77,79),
3097
(6,63,67), (5,55,58), (3,38,39), (8,81,89);
3098
INSERT INTO t2 VALUES
3099
(21,210), (41,410), (82,820), (83,830), (84,840),
3100
(65,650), (51,510), (37,370), (94,940), (76,760),
3101
(22,220), (33,330), (40,400), (95,950), (38,380),
3102
(67,670), (88,880), (57,570), (96,960), (97,970);
3103
INSERT INTO t3 VALUES
3104
(210,'bb'), (950,'ii'), (400,'ab'), (500,'ee'), (220,'gg'),
3105
(440,'gg'), (310,'eg'), (380,'ee'), (840,'bb'), (830,'ff'),
3106
(230,'aa'), (960,'ii'), (410,'aa'), (510,'ee'), (290,'bb'),
3107
(450,'gg'), (320,'dd'), (390,'hh'), (850,'jj'), (860,'ff');
3110
SELECT t3.a FROM t1,t2 FORCE INDEX (si),t3
3111
WHERE t1.id = 8 AND t2.i BETWEEN t1.b AND t1.e AND
3112
t3.a=t2.a AND t3.c IN ('bb','ee');
3114
SELECT t3.a FROM t1,t2,t3
3115
WHERE t1.id = 8 AND t2.i BETWEEN t1.b AND t1.e AND
3116
t3.a=t2.a AND t3.c IN ('bb','ee') ;
3119
SELECT t3.a FROM t1,t2 FORCE INDEX (si),t3
3120
WHERE t1.id = 8 AND (t2.i=t1.b OR t2.i=t1.e) AND t3.a=t2.a AND
3121
t3.c IN ('bb','ee');
3123
SELECT t3.a FROM t1,t2,t3
3124
WHERE t1.id = 8 AND (t2.i=t1.b OR t2.i=t1.e) AND t3.a=t2.a AND
3125
t3.c IN ('bb','ee');
3127
DROP TABLE t1,t2,t3;
3130
# Bug#25172: Not checked buffer size leads to a server crash
3132
CREATE TABLE t1 ( f1 int primary key, f2 int, f3 int, f4 int, f5 int, f6 int, checked_out int);
3133
CREATE TABLE t2 ( f11 int PRIMARY KEY );
3134
INSERT INTO t1 VALUES (1,1,1,0,0,0,0),(2,1,1,3,8,1,0),(3,1,1,4,12,1,0);
3135
INSERT INTO t2 VALUES (62);
3136
SELECT * FROM t1 LEFT JOIN t2 ON f11 = t1.checked_out GROUP BY f1 ORDER BY f2, f3, f4, f5 LIMIT 0, 1;
3140
# Bug#6298: LIMIT #, -1 no longer works to set start with no end limit
3144
DROP TABLE IF EXISTS t1;
3147
CREATE TABLE t1(a int);
3148
INSERT into t1 values (1), (2), (3);
3150
# LIMIT N, -1 was accepted by accident in 4.0, but was not intended.
3151
# This test verifies that this illegal construct is now properly detected.
3153
--error ER_PARSE_ERROR
3154
SELECT * FROM t1 LIMIT 2, -1;
3159
# 25407: wrong estimate of NULL keys for unique indexes
3163
ID_with_null int NULL,
3164
ID_better int NOT NULL,
3165
INDEX idx1 (ID_with_null),
3166
INDEX idx2 (ID_better)
3169
INSERT INTO t1 VALUES (1,1), (2,1), (null,3), (null,3), (null,3), (null,3);
3170
INSERT INTO t1 SELECT * FROM t1 WHERE ID_with_null IS NULL;
3171
INSERT INTO t1 SELECT * FROM t1 WHERE ID_with_null IS NULL;
3172
INSERT INTO t1 SELECT * FROM t1 WHERE ID_with_null IS NULL;
3173
INSERT INTO t1 SELECT * FROM t1 WHERE ID_with_null IS NULL;
3174
INSERT INTO t1 SELECT * FROM t1 WHERE ID_with_null IS NULL;
3176
SELECT COUNT(*) FROM t1 WHERE ID_with_null IS NULL;
3177
SELECT COUNT(*) FROM t1 WHERE ID_better=1;
3179
EXPLAIN SELECT * FROM t1 WHERE ID_better=1 AND ID_with_null IS NULL;
3181
DROP INDEX idx1 ON t1;
3182
CREATE UNIQUE INDEX idx1 ON t1(ID_with_null);
3184
EXPLAIN SELECT * FROM t1 WHERE ID_better=1 AND ID_with_null IS NULL;
3189
ID1_with_null int NULL,
3190
ID2_with_null int NULL,
3191
ID_better int NOT NULL,
3192
INDEX idx1 (ID1_with_null, ID2_with_null),
3193
INDEX idx2 (ID_better)
3196
INSERT INTO t1 VALUES (1,1,1), (2,2,1), (3,null,3), (null,3,3), (null,null,3),
3197
(3,null,3), (null,3,3), (null,null,3), (3,null,3), (null,3,3), (null,null,3);
3199
INSERT INTO t1 SELECT * FROM t1 WHERE ID1_with_null IS NULL;
3200
INSERT INTO t1 SELECT * FROM t1 WHERE ID2_with_null IS NULL;
3201
INSERT INTO t1 SELECT * FROM t1 WHERE ID1_with_null IS NULL;
3202
INSERT INTO t1 SELECT * FROM t1 WHERE ID2_with_null IS NULL;
3203
INSERT INTO t1 SELECT * FROM t1 WHERE ID1_with_null IS NULL;
3204
INSERT INTO t1 SELECT * FROM t1 WHERE ID2_with_null IS NULL;
3206
SELECT COUNT(*) FROM t1 WHERE ID1_with_null IS NULL AND ID2_with_null=3;
3207
SELECT COUNT(*) FROM t1 WHERE ID1_with_null=3 AND ID2_with_null IS NULL;
3208
SELECT COUNT(*) FROM t1 WHERE ID1_with_null IS NULL AND ID2_with_null IS NULL;
3209
SELECT COUNT(*) FROM t1 WHERE ID_better=1;
3211
EXPLAIN SELECT * FROM t1
3212
WHERE ID_better=1 AND ID1_with_null IS NULL AND ID2_with_null=3 ;
3213
EXPLAIN SELECT * FROM t1
3214
WHERE ID_better=1 AND ID1_with_null=3 AND ID2_with_null=3 IS NULL ;
3215
EXPLAIN SELECT * FROM t1
3216
WHERE ID_better=1 AND ID1_with_null IS NULL AND ID2_with_null IS NULL;
3218
DROP INDEX idx1 ON t1;
3219
CREATE UNIQUE INDEX idx1 ON t1(ID1_with_null,ID2_with_null);
3221
EXPLAIN SELECT * FROM t1
3222
WHERE ID_better=1 AND ID1_with_null IS NULL AND ID2_with_null=3 ;
3223
EXPLAIN SELECT * FROM t1
3224
WHERE ID_better=1 AND ID1_with_null=3 AND ID2_with_null IS NULL ;
3225
EXPLAIN SELECT * FROM t1
3226
WHERE ID_better=1 AND ID1_with_null IS NULL AND ID2_with_null IS NULL;
3227
EXPLAIN SELECT * FROM t1
3228
WHERE ID_better=1 AND ID1_with_null IS NULL AND
3229
(ID2_with_null=1 OR ID2_with_null=2);
3234
# Bug #22344: InnoDB keys act strange on datetime vs timestamp comparison
3236
CREATE TABLE t1 (a INT, ts TIMESTAMP, KEY ts(ts));
3237
INSERT INTO t1 VALUES (30,"2006-01-03 23:00:00"), (31,"2006-01-03 23:00:00");
3240
CREATE TABLE t2 (a INT, dt1 DATETIME, dt2 DATETIME, PRIMARY KEY (a));
3241
INSERT INTO t2 VALUES (30, "2006-01-01 00:00:00", "2999-12-31 00:00:00");
3242
INSERT INTO t2 SELECT a+1,dt1,dt2 FROM t2;
3246
SELECT * FROM t1 LEFT JOIN t2 ON (t1.a=t2.a) WHERE t1.a=30
3247
AND t1.ts BETWEEN t2.dt1 AND t2.dt2
3248
AND t1.ts BETWEEN "2006-01-01" AND "2006-12-31";
3250
SELECT * FROM t1 LEFT JOIN t2 ON (t1.a=t2.a) WHERE t1.a=30
3251
AND t1.ts BETWEEN t2.dt1 AND t2.dt2
3252
AND t1.ts BETWEEN "2006-01-01" AND "2006-12-31";
3255
# Bug #22026: Warning when using IF statement and large unsigned bigint
3258
create table t1 (a bigint unsigned);
3259
insert into t1 values
3260
(if(1, 9223372036854775808, 1)),
3261
(case when 1 then 9223372036854775808 else 1 end),
3262
(coalesce(9223372036854775808, 1));
3265
create table t1 select
3266
if(1, 9223372036854775808, 1) i,
3267
case when 1 then 9223372036854775808 else 1 end c,
3268
coalesce(9223372036854775808, 1) co;
3269
show create table t1;
3271
# Ensure we handle big values properly
3273
if(1, cast(1111111111111111111 as unsigned), 1) i,
3274
case when 1 then cast(1111111111111111111 as unsigned) else 1 end c,
3275
coalesce(cast(1111111111111111111 as unsigned), 1) co;
3278
# Bug #22971: indexes on text columns are ignored for ref accesses
3281
CREATE TABLE t1 (name varchar(255));
3282
CREATE TABLE t2 (name varchar(255), n int, KEY (name(3)));
3283
INSERT INTO t1 VALUES ('ccc'), ('bb'), ('cc '), ('aa '), ('aa');
3284
INSERT INTO t2 VALUES ('bb',1), ('aa',2), ('cc ',3);
3285
INSERT INTO t2 VALUES (concat('cc ', 0x06), 4);
3286
INSERT INTO t2 VALUES ('cc',5), ('bb ',6), ('cc ',7);
3288
SELECT * FROM t2 ORDER BY name;
3289
SELECT name, LENGTH(name), n FROM t2 ORDER BY name;
3291
EXPLAIN SELECT name, LENGTH(name), n FROM t2 WHERE name='cc ';
3292
SELECT name, LENGTH(name), n FROM t2 WHERE name='cc ';
3293
EXPLAIN SELECT name , LENGTH(name), n FROM t2 WHERE name LIKE 'cc%';
3294
SELECT name , LENGTH(name), n FROM t2 WHERE name LIKE 'cc%';
3295
EXPLAIN SELECT name , LENGTH(name), n FROM t2 WHERE name LIKE 'cc%' ORDER BY name;
3296
SELECT name , LENGTH(name), n FROM t2 WHERE name LIKE 'cc%' ORDER BY name;
3297
EXPLAIN SELECT * FROM t1 LEFT JOIN t2 ON t1.name=t2.name;
3298
SELECT * FROM t1 LEFT JOIN t2 ON t1.name=t2.name;
3302
CREATE TABLE t1 (name text);
3303
CREATE TABLE t2 (name text, n int, KEY (name(3)));
3304
INSERT INTO t1 VALUES ('ccc'), ('bb'), ('cc '), ('aa '), ('aa');
3305
INSERT INTO t2 VALUES ('bb',1), ('aa',2), ('cc ',3);
3306
INSERT INTO t2 VALUES (concat('cc ', 0x06), 4);
3307
INSERT INTO t2 VALUES ('cc',5), ('bb ',6), ('cc ',7);
3309
SELECT * FROM t2 ORDER BY name;
3310
SELECT name, LENGTH(name), n FROM t2 ORDER BY name;
3312
EXPLAIN SELECT name, LENGTH(name), n FROM t2 WHERE name='cc ';
3313
SELECT name, LENGTH(name), n FROM t2 WHERE name='cc ';
3314
EXPLAIN SELECT name , LENGTH(name), n FROM t2 WHERE name LIKE 'cc%';
3315
SELECT name , LENGTH(name), n FROM t2 WHERE name LIKE 'cc%';
3316
EXPLAIN SELECT name , LENGTH(name), n FROM t2 WHERE name LIKE 'cc%' ORDER BY name;
3317
SELECT name , LENGTH(name), n FROM t2 WHERE name LIKE 'cc%' ORDER BY name;
3318
EXPLAIN SELECT * FROM t1 LEFT JOIN t2 ON t1.name=t2.name;
3319
SELECT * FROM t1 LEFT JOIN t2 ON t1.name=t2.name;
3325
# Bug #26963: join with predicates that contain fields from equalities evaluated
3326
# to constants after constant table substitution
3330
access_id int NOT NULL default '0',
3331
name varchar(20) default NULL,
3332
rank int NOT NULL default '0',
3337
faq_group_id int NOT NULL default '0',
3338
faq_id int NOT NULL default '0',
3339
access_id int default NULL,
3340
UNIQUE KEY idx1 (faq_id),
3341
KEY idx2 (faq_group_id,faq_id)
3344
INSERT INTO t1 VALUES
3345
(1,'Everyone',2),(2,'Help',3),(3,'Technical Support',1),(4,'Chat User',4);
3346
INSERT INTO t2 VALUES
3347
(261,265,1),(490,494,1);
3351
FROM t1 INNER JOIN t2 IGNORE INDEX (idx1)
3352
ON (t1.access_id = t2.access_id)
3354
ON (t.faq_group_id = t2.faq_group_id AND
3355
find_in_set(t.access_id, '1,4') < find_in_set(t2.access_id, '1,4'))
3357
t2.access_id IN (1,4) AND t.access_id IS NULL AND t2.faq_id in (265);
3360
FROM t1 INNER JOIN t2
3361
ON (t1.access_id = t2.access_id)
3363
ON (t.faq_group_id = t2.faq_group_id AND
3364
find_in_set(t.access_id, '1,4') < find_in_set(t2.access_id, '1,4'))
3366
t2.access_id IN (1,4) AND t.access_id IS NULL AND t2.faq_id in (265);
3372
# Bug #19372: Optimizer does not use index anymore when WHERE index NOT IN
3375
CREATE TABLE t1 (a INT, b INT, KEY inx (b,a));
3377
INSERT INTO t1 VALUES (1,1), (1,2), (1,3), (1,4), (1,5), (1, 6), (1,7);
3378
EXPLAIN SELECT COUNT(*) FROM t1 f1 INNER JOIN t1 f2
3379
ON ( f1.b=f2.b AND f1.a<f2.a )
3380
WHERE 1 AND f1.b NOT IN (100,2232,3343,51111);
3384
# Bug #27352: Incorrect result of nested selects instead of error reporting
3387
CREATE TABLE t1 (c1 INT, c2 INT);
3388
INSERT INTO t1 VALUES (1,11), (2,22), (2,22);
3394
let $q= (SELECT $q);
3398
eval EXPLAIN SELECT c1 FROM t1 WHERE $q > 0;
3405
let $q= (SELECT $q);
3408
--error ER_TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECT
3409
eval EXPLAIN SELECT c1 FROM t1 WHERE $q > 0;
3414
# Bug #30396: crash for a join with equalities and sargable predicates
3415
# in disjunctive parts of the WHERE condition
3419
c1 int(11) NOT NULL AUTO_INCREMENT,
3420
c2 varchar(1000) DEFAULT NULL,
3421
c3 bigint(20) DEFAULT NULL,
3422
c4 bigint(20) DEFAULT NULL,
3438
join_0.c1=join_1.c1 AND
3439
join_1.c1=join_2.c1 AND
3440
join_2.c1=join_3.c1 AND
3441
join_3.c1=join_4.c1 AND
3442
join_4.c1=join_5.c1 AND
3443
join_5.c1=join_6.c1 AND
3452
join_5.c2 <> '?' AND
3453
join_6.c2 <> '?' AND
3454
join_7.c2 >= '?' AND
3455
join_0.c1=join_1.c1 AND
3456
join_1.c1=join_2.c1 AND
3457
join_2.c1=join_3.c1 AND
3458
join_3.c1=join_4.c1 AND
3459
join_4.c1=join_5.c1 AND
3460
join_5.c1=join_6.c1 AND
3474
# Bug #27695: Misleading warning when declaring all space column names and
3475
# truncation of one-space column names to zero length names.
3478
--disable_ps_protocol
3482
--enable_ps_protocol
3485
CREATE VIEW v1 AS SELECT 1 AS ``;
3488
CREATE VIEW v1 AS SELECT 1 AS ` `;
3491
CREATE VIEW v1 AS SELECT 1 AS ` `;
3494
CREATE VIEW v1 AS SELECT (SELECT 1 AS ` `);
3496
CREATE VIEW v1 AS SELECT 1 AS ` x`;
3500
ALTER VIEW v1 AS SELECT 1 AS ` `;
3505
# Bug#31800: Date comparison fails with timezone and slashes for greater
3509
# On DATETIME-like literals with trailing garbage, BETWEEN fudged in a
3510
# DATETIME comparator, while greater/less-than used bin-string comparisons.
3511
# Should correctly be compared as DATE or DATETIME, but throw a warning:
3513
select str_to_date('2007-10-09','%Y-%m-%d') between '2007/10/01 00:00:00 GMT'
3514
and '2007/10/20 00:00:00 GMT';
3515
select str_to_date('2007-10-09','%Y-%m-%d') > '2007/10/01 00:00:00 GMT-6';
3516
select str_to_date('2007-10-09','%Y-%m-%d') <= '2007/10/2000:00:00 GMT-6';
3518
# We have all we need -- and trailing garbage:
3519
# (leaving out a leading zero in first example to prove it's a
3520
# value-comparison, not a string-comparison!)
3521
select str_to_date('2007-10-01','%Y-%m-%d') = '2007-10-1 00:00:00 GMT-6';
3522
select str_to_date('2007-10-01','%Y-%m-%d') = '2007-10-01 x00:00:00 GMT-6';
3523
select str_to_date('2007-10-01','%Y-%m-%d %H:%i:%s') = '2007-10-01 00:00:00 GMT-6';
3524
select str_to_date('2007-10-01','%Y-%m-%d %H:%i:%s') = '2007-10-01 00:x00:00 GMT-6';
3526
select str_to_date('2007-10-01','%Y-%m-%d %H:%i:%s') = '2007-10-01 x12:34:56 GMT-6';
3528
select str_to_date('2007-10-01 12:34:00','%Y-%m-%d %H:%i:%s') = '2007-10-01 12:34x:56 GMT-6';
3529
# fail, different second part:
3530
select str_to_date('2007-10-01 12:34:56','%Y-%m-%d %H:%i:%s') = '2007-10-01 12:34x:56 GMT-6';
3531
# correct syntax, no trailing nonsense -- this one must throw no warning:
3532
select str_to_date('2007-10-01 12:34:56','%Y-%m-%d %H:%i:%s') = '2007-10-01 12:34:56';
3533
# no warning, but failure (different hour parts):
3534
select str_to_date('2007-10-01','%Y-%m-%d') = '2007-10-01 12:00:00';
3536
select str_to_date('2007-10-01 12','%Y-%m-%d %H') = '2007-10-01 12:00:00';
3537
# succeed, but warn for "trailing garbage" (":34"):
3538
select str_to_date('2007-10-01 12:34','%Y-%m-%d %H') = '2007-10-01 12:00:00';
3539
# invalid date (Feb 30) succeeds
3540
select str_to_date('2007-02-30 12:34','%Y-%m-%d %H:%i') = '2007-02-30 12:34';
3541
# 0-day for both, just works in default SQL mode.
3542
select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34';
3544
select str_to_date('2007-10-00','%Y-%m-%d') between '2007/09/01 00:00:00'
3545
and '2007/10/20 00:00:00';
3546
set SQL_MODE=TRADITIONAL;
3547
# 0-day throws warning in traditional mode, and fails
3548
select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34';
3549
select str_to_date('2007-10-01 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34';
3550
# different code-path: get_datetime_value() with 0-day
3551
select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-01 12:34';
3552
select str_to_date('2007-10-00','%Y-%m-%d') between '2007/09/01'
3554
set SQL_MODE=DEFAULT;
3555
select str_to_date('2007-10-00','%Y-%m-%d') between '' and '2007/10/20';
3556
select str_to_date('','%Y-%m-%d') between '2007/10/01' and '2007/10/20';
3557
select str_to_date('','%Y-%m-%d %H:%i') = '2007-10-01 12:34';
3558
select str_to_date(NULL,'%Y-%m-%d %H:%i') = '2007-10-01 12:34';
3559
select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '';
3561
select str_to_date('1','%Y-%m-%d') = '1';
3562
select str_to_date('1','%Y-%m-%d') = '1';
3563
select str_to_date('','%Y-%m-%d') = '';
3565
# these three should work!
3566
select str_to_date('1000-01-01','%Y-%m-%d') between '0000-00-00' and NULL;
3567
select str_to_date('1000-01-01','%Y-%m-%d') between NULL and '2000-00-00';
3568
select str_to_date('1000-01-01','%Y-%m-%d') between NULL and NULL;
3571
# Bug #30666: Incorrect order when using range conditions on 2 tables or more
3574
CREATE TABLE t1 (c11 INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY);
3575
CREATE TABLE t2 (c21 INT UNSIGNED NOT NULL,
3576
c22 INT DEFAULT NULL,
3578
CREATE TABLE t3 (c31 INT UNSIGNED NOT NULL DEFAULT 0,
3579
c32 INT DEFAULT NULL,
3581
c34 INT UNSIGNED DEFAULT 0,
3582
KEY (c33, c34, c32));
3584
INSERT INTO t1 values (),(),(),(),();
3585
INSERT INTO t2 SELECT a.c11, b.c11 FROM t1 a, t1 b;
3586
INSERT INTO t3 VALUES (1, 1, 1, 0),
3592
# Show that ORDER BY produces the correct results order
3593
SELECT c32 FROM t1, t2, t3 WHERE t1.c11 IN (1, 3, 5) AND
3594
t3.c31 = t1.c11 AND t2.c21 = t1.c11 AND
3595
t3.c33 = 1 AND t2.c22 in (1, 3)
3598
# Show that ORDER BY DESC produces the correct results order
3599
SELECT c32 FROM t1, t2, t3 WHERE t1.c11 IN (1, 3, 5) AND
3600
t3.c31 = t1.c11 AND t2.c21 = t1.c11 AND
3601
t3.c33 = 1 AND t2.c22 in (1, 3)
3604
DROP TABLE t1, t2, t3;
3605
###########################################################################
3609
--echo # Bug#30736: Row Size Too Large Error Creating a Table and
3610
--echo # Inserting Data.
3614
DROP TABLE IF EXISTS t1;
3615
DROP TABLE IF EXISTS t2;
3626
INSERT INTO t1 VALUES (0, 1), (2, 3), (4, 5);
3651
###########################################################################
3654
# Bug #32335: Error on BIGINT > NULL + 1
3657
CREATE TABLE t1 (c1 BIGINT NOT NULL);
3658
INSERT INTO t1 (c1) VALUES (1);
3659
SELECT * FROM t1 WHERE c1 > NULL + 1;
3664
###########################################################################
3667
# Bug #33764: Wrong result with IN(), CONCAT() and implicit type conversion
3670
CREATE TABLE t1 (a VARCHAR(10) NOT NULL PRIMARY KEY);
3671
INSERT INTO t1 (a) VALUES ('foo0'), ('bar0'), ('baz0');
3672
SELECT * FROM t1 WHERE a IN (CONCAT('foo', 0), 'bar');
3676
# Bug #32942 now() - interval '7200' second is NOT pre-calculated, causing "full table scan"
3679
CREATE TABLE t1 (a INT, b INT);
3680
CREATE TABLE t2 (a INT, c INT, KEY(a));
3682
INSERT INTO t1 VALUES (1, 1), (2, 2);
3683
INSERT INTO t2 VALUES (1, 1), (1, 2), (1, 3), (1, 4), (1, 5),
3684
(2, 1), (2, 2), (2, 3), (2, 4), (2, 5),
3685
(3, 1), (3, 2), (3, 3), (3, 4), (3, 5),
3686
(4, 1), (4, 2), (4, 3), (4, 4), (4, 5);
3689
SELECT DISTINCT b FROM t1 LEFT JOIN t2 USING(a) WHERE c <= 3;
3690
SHOW STATUS LIKE 'Handler_read%';
3694
# Bug#40953 SELECT query throws "ERROR 1062 (23000): Duplicate entry..." error
3696
CREATE TABLE t1 (f1 bigint(20) NOT NULL default '0',
3697
f2 int(11) NOT NULL default '0',
3698
f3 bigint(20) NOT NULL default '0',
3699
f4 varchar(255) NOT NULL default '',
3703
CREATE TABLE t2 (f1 int(11) NOT NULL default '0',
3704
f2 enum('A1','A2','A3') NOT NULL default 'A1',
3705
f3 int(11) NOT NULL default '0',
3708
CREATE TABLE t3 (f1 bigint(20) NOT NULL default '0',
3709
f2 datetime NOT NULL default '1980-01-01 00:00:00',
3712
insert into t1 values (1, 1, 1, 'abc');
3713
insert into t1 values (2, 1, 2, 'def');
3714
insert into t1 values (3, 1, 2, 'def');
3715
insert into t2 values (1, 'A1', 1);
3716
insert into t3 values (1, '1980-01-01');
3718
SELECT a.f3, cr.f4, count(*) count
3720
STRAIGHT_JOIN t1 cr ON cr.f2 = a.f1
3723
JOIN t3 ae2 ON cr2.f3 = ae2.f1
3724
) ON a.f1 = cr2.f2 AND ae2.f2 < now() - INTERVAL 7 DAY AND
3726
GROUP BY a.f3, cr.f4;
3728
drop table t1, t2, t3;
3732
# Bug #40925: Equality propagation takes non indexed attribute
3735
CREATE TABLE t1 (a INT KEY, b INT);
3736
INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4);
3738
EXPLAIN EXTENDED SELECT a, b FROM t1 WHERE a > 1 AND a = b LIMIT 2;
3739
EXPLAIN EXTENDED SELECT a, b FROM t1 WHERE a > 1 AND b = a LIMIT 2;
3745
--echo # Bug#47019: Assertion failed: 0, file .\rt_mbr.c, line 138 when
3746
--echo # forcing a spatial index
3748
CREATE TABLE t1(a LINESTRING NOT NULL, SPATIAL KEY(a));
3749
INSERT INTO t1 VALUES
3750
(GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)')),
3751
(GEOMFROMTEXT('LINESTRING(-1 -1, 1 -1, -1 -1, -1 1, 1 1)'));
3752
EXPLAIN SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2;
3753
SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2;
3754
EXPLAIN SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2 FORCE INDEX(a);
3755
SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2 FORCE INDEX(a);
3760
--echo # Bug #48291 : crash with row() operator,select into @var, and
3761
--echo # subquery returning multiple rows
3764
CREATE TABLE t1(a INT);
3765
INSERT INTO t1 VALUES (2),(3);
3767
--echo # Should not crash
3768
--error ER_SUBQUERY_NO_1_ROW
3769
SELECT 1 FROM t1 WHERE a <> 1 AND NOT
3770
ROW(a,a) <=> ROW((SELECT 1 FROM t1 WHERE 1=2),(SELECT 1 FROM t1))
3776
--echo # Bug #48458: simple query tries to allocate enormous amount of
3780
CREATE TABLE t1(a INT NOT NULL, b YEAR);
3781
INSERT INTO t1 VALUES ();
3782
CREATE TABLE t2(c INT);
3783
--echo # Should not err out because of out-of-memory
3784
SELECT 1 FROM t2 JOIN t1 ON 1=1
3785
WHERE a != '1' AND NOT a >= b OR NOT ROW(b,a )<> ROW(a,a);
3790
--echo # Bug #49199: Optimizer handles incorrectly:
3791
--echo # field='const1' AND field='const2' in some cases
3793
CREATE TABLE t1(a DATETIME NOT NULL);
3794
INSERT INTO t1 VALUES('2001-01-01');
3795
SELECT * FROM t1 WHERE a='2001-01-01' AND a='2001-01-01 00:00:00';
3796
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a='2001-01-01' AND a='2001-01-01 00:00:00';
3799
CREATE TABLE t1(a DATE NOT NULL);
3800
INSERT INTO t1 VALUES('2001-01-01');
3801
SELECT * FROM t1 WHERE a='2001-01-01' AND a='2001-01-01 00:00:00';
3802
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a='2001-01-01' AND a='2001-01-01 00:00:00';
3805
CREATE TABLE t1(a TIMESTAMP NOT NULL);
3806
INSERT INTO t1 VALUES('2001-01-01');
3807
SELECT * FROM t1 WHERE a='2001-01-01' AND a='2001-01-01 00:00:00';
3808
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a='2001-01-01' AND a='2001-01-01 00:00:00';
3811
CREATE TABLE t1(a DATETIME NOT NULL, b DATE NOT NULL);
3812
INSERT INTO t1 VALUES('2001-01-01', '2001-01-01');
3813
SELECT * FROM t1 WHERE a='2001-01-01' AND a=b AND b='2001-01-01 00:00:00';
3814
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a='2001-01-01' AND a=b AND b='2001-01-01 00:00:00';
3817
CREATE TABLE t1(a DATETIME NOT NULL, b VARCHAR(20) NOT NULL);
3818
INSERT INTO t1 VALUES('2001-01-01', '2001-01-01');
3819
SELECT * FROM t1 WHERE a='2001-01-01' AND a=b AND b='2001-01-01 00:00:00';
3820
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a='2001-01-01' AND a=b AND b='2001-01-01 00:00:00';
3822
SELECT * FROM t1 WHERE a='2001-01-01 00:00:00' AND a=b AND b='2001-01-01';
3823
EXPLAIN EXTENDED SELECT * FROM t1 WHERE a='2001-01-01 00:00:00' AND a=b AND b='2001-01-01';
3826
CREATE TABLE t1(a DATETIME NOT NULL, b DATE NOT NULL);
3827
INSERT INTO t1 VALUES('2001-01-01', '2001-01-01');
3828
SELECT x.a, y.a, z.a FROM t1 x
3829
JOIN t1 y ON x.a=y.a
3830
JOIN t1 z ON y.a=z.a
3831
WHERE x.a='2001-01-01' AND z.a='2001-01-01 00:00:00';
3832
EXPLAIN EXTENDED SELECT x.a, y.a, z.a FROM t1 x
3833
JOIN t1 y ON x.a=y.a
3834
JOIN t1 z ON y.a=z.a
3835
WHERE x.a='2001-01-01' AND z.a='2001-01-01 00:00:00';
3840
--echo # Bug #49897: crash in ptr_compare when char(0) NOT NULL
3841
--echo # column is used for ORDER BY
3843
SET @old_sort_buffer_size= @@session.sort_buffer_size;
3844
SET @@sort_buffer_size= 40000;
3846
CREATE TABLE t1(a CHAR(0) NOT NULL);
3848
INSERT INTO t1 VALUES (0), (0), (0);
3850
INSERT INTO t1 SELECT t11.a FROM t1 t11, t1 t12;
3851
INSERT INTO t1 SELECT t11.a FROM t1 t11, t1 t12;
3852
INSERT INTO t1 SELECT t11.a FROM t1 t11, t1 t12;
3853
EXPLAIN SELECT a FROM t1 ORDER BY a;
3854
--disable_result_log
3855
SELECT a FROM t1 ORDER BY a;
3859
CREATE TABLE t1(a CHAR(0) NOT NULL, b CHAR(0) NOT NULL, c int);
3861
INSERT INTO t1 VALUES (0, 0, 0), (0, 0, 2), (0, 0, 1);
3863
INSERT INTO t1 SELECT t11.a, t11.b, t11.c FROM t1 t11, t1 t12;
3864
INSERT INTO t1 SELECT t11.a, t11.b, t11.c FROM t1 t11, t1 t12;
3865
INSERT INTO t1 SELECT t11.a, t11.b, t11.c FROM t1 t11, t1 t12;
3866
EXPLAIN SELECT a FROM t1 ORDER BY a LIMIT 5;
3867
SELECT a FROM t1 ORDER BY a LIMIT 5;
3868
EXPLAIN SELECT * FROM t1 ORDER BY a, b LIMIT 5;
3869
SELECT * FROM t1 ORDER BY a, b LIMIT 5;
3870
EXPLAIN SELECT * FROM t1 ORDER BY a, b, c LIMIT 5;
3871
SELECT * FROM t1 ORDER BY a, b, c LIMIT 5;
3872
EXPLAIN SELECT * FROM t1 ORDER BY c, a LIMIT 5;
3873
SELECT * FROM t1 ORDER BY c, a LIMIT 5;
3875
SET @@sort_buffer_size= @old_sort_buffer_size;
3879
--echo End of 5.0 tests
3882
# Bug #30639: limit offset,rowcount wraps when rowcount >= 2^32 in windows
3884
create table t1(a INT, KEY (a));
3885
INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
3886
SELECT a FROM t1 ORDER BY a LIMIT 2;
3887
SELECT a FROM t1 ORDER BY a LIMIT 2,4294967296;
3888
SELECT a FROM t1 ORDER BY a LIMIT 2,4294967297;
3892
# Bug #37936: ASSERT_COLUMN_MARKED_FOR_WRITE in Field_datetime::store ,
3893
# Field_varstring::store
3896
CREATE TABLE A (date_key date);
3902
date_key date NOT NULL,
3904
varchar_key varchar(1)
3907
INSERT INTO C VALUES
3908
(1,1,1,'0000-00-00',NULL,NULL),
3909
(1,1,1,'0000-00-00',NULL,NULL);
3911
SELECT 1 FROM C WHERE pk > ANY (SELECT 1 FROM C);
3913
SELECT COUNT(DISTINCT 1) FROM C
3914
WHERE date_key = (SELECT 1 FROM A WHERE C.date_key IS NULL) GROUP BY pk;
3915
SELECT date_nokey FROM C
3916
WHERE int_key IN (SELECT 1 FROM A)
3917
HAVING date_nokey = '10:41:7'
3923
# Bug #42957: no results from
3924
# select where .. (col=col and col=col) or ... (false expression)
3926
CREATE TABLE t1 (a INT NOT NULL, b INT);
3927
INSERT INTO t1 VALUES (1, 1);
3928
EXPLAIN EXTENDED SELECT * FROM t1 WHERE (a=a AND a=a) OR b > 2;
3929
SELECT * FROM t1 WHERE (a=a AND a=a) OR b > 2;
3932
CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL);
3933
EXPLAIN EXTENDED SELECT * FROM t1 WHERE (a=a AND b=b AND c=c) OR b > 20;
3934
EXPLAIN EXTENDED SELECT * FROM t1 WHERE (a=a AND a=a AND b=b) OR b > 20;
3935
EXPLAIN EXTENDED SELECT * FROM t1 WHERE (a=a AND b=b AND a=a) OR b > 20;
3940
--echo # Bug#45266: Uninitialized variable lead to an empty result.
3943
drop table if exists A,AA,B,BB;
3945
`pk` int(11) NOT NULL AUTO_INCREMENT,
3946
`date_key` date NOT NULL,
3947
`date_nokey` date NOT NULL,
3948
`datetime_key` datetime NOT NULL,
3949
`int_nokey` int(11) NOT NULL,
3950
`time_key` time NOT NULL,
3951
`time_nokey` time NOT NULL,
3953
KEY `date_key` (`date_key`),
3954
KEY `time_key` (`time_key`),
3955
KEY `datetime_key` (`datetime_key`)
3959
`pk` int(11) NOT NULL AUTO_INCREMENT,
3960
`int_nokey` int(11) NOT NULL,
3961
`time_key` time NOT NULL,
3962
KEY `time_key` (`time_key`),
3967
`date_nokey` date NOT NULL,
3968
`date_key` date NOT NULL,
3969
`time_key` time NOT NULL,
3970
`datetime_nokey` datetime NOT NULL,
3971
`varchar_key` varchar(1) NOT NULL,
3972
KEY `date_key` (`date_key`),
3973
KEY `time_key` (`time_key`),
3974
KEY `varchar_key` (`varchar_key`)
3977
INSERT INTO `B` VALUES ('2003-07-28','2003-07-28','15:13:38','0000-00-00 00:00:00','f'),('0000-00-00','0000-00-00','00:05:48','2004-07-02 14:34:13','x');
3980
`pk` int(11) NOT NULL AUTO_INCREMENT,
3981
`int_nokey` int(11) NOT NULL,
3982
`date_key` date NOT NULL,
3983
`varchar_nokey` varchar(1) NOT NULL,
3984
`date_nokey` date NOT NULL,
3986
KEY `date_key` (`date_key`)
3989
INSERT INTO `BB` VALUES (10,8,'0000-00-00','i','0000-00-00'),(11,0,'2005-08-18','','2005-08-18');
3991
SELECT table1 . `pk` AS field1
3993
(BB AS table1 INNER JOIN
3994
(AA AS table2 STRAIGHT_JOIN A AS table3
3995
ON ( table3 . `date_key` = table2 . `pk` ))
3996
ON ( table3 . `datetime_key` = table2 . `int_nokey` ))
3997
WHERE ( table3 . `date_key` <= 4 AND table2 . `pk` = table1 . `varchar_nokey`)
4000
SELECT table3 .`date_key` field1
4002
B table1 LEFT JOIN B table3 JOIN
4003
(BB table6 JOIN A table7 ON table6 .`varchar_nokey`)
4004
ON table6 .`int_nokey` ON table6 .`date_key`
4005
WHERE NOT ( table1 .`varchar_key` AND table7 .`pk`) GROUP BY field1;
4008
SELECT table4 . `time_nokey` AS field1 FROM
4009
(AA AS table1 CROSS JOIN
4010
(AA AS table2 STRAIGHT_JOIN
4011
(B AS table3 STRAIGHT_JOIN A AS table4
4012
ON ( table4 . `date_key` = table3 . `time_key` ))
4013
ON ( table4 . `pk` = table3 . `date_nokey` ))
4014
ON ( table4 . `time_key` = table3 . `datetime_nokey` ))
4015
WHERE ( table4 . `time_key` < table1 . `time_key` AND
4016
table1 . `int_nokey` != 'f')
4017
GROUP BY field1 ORDER BY field1 , field1;
4019
SELECT table1 .`time_key` field2 FROM B table1 LEFT JOIN BB JOIN A table5 ON table5 .`date_nokey` ON table5 .`int_nokey` GROUP BY field2;
4022
drop table A,AA,B,BB;
4023
--echo #end of test for bug#45266
4026
--echo # BUG#48052: Valgrind warning - uninitialized value in init_read_record()
4029
# Needed in 6.0 codebase
4030
#--echo # Disable Index condition pushdown
4031
#--replace_column 1 #
4032
#SELECT @old_icp:=@@engine_condition_pushdown;
4033
#SET SESSION engine_condition_pushdown = 'OFF';
4036
pk int(11) NOT NULL,
4037
i int(11) DEFAULT NULL,
4038
v varchar(1) DEFAULT NULL,
4042
INSERT INTO t1 VALUES (2,7,'m');
4043
INSERT INTO t1 VALUES (3,9,'m');
4051
# Needed in 6.0 codebase
4052
#--echo # Restore old value for Index condition pushdown
4053
#SET SESSION engine_condition_pushdown=@old_icp;
4058
--echo # Bug#49489 Uninitialized cache led to a wrong result.
4060
CREATE TABLE t1(c1 DOUBLE(5,4));
4061
INSERT INTO t1 VALUES (9.1234);
4062
SELECT * FROM t1 WHERE c1 < 9.12345;
4064
--echo # End of test for bug#49489.
4068
--echo # Bug #49517: Inconsistent behavior while using
4069
--echo # NULLable BIGINT and INT columns in comparison
4071
CREATE TABLE t1(a BIGINT UNSIGNED NOT NULL, b BIGINT NULL, c INT NULL);
4072
INSERT INTO t1 VALUES(105, NULL, NULL);
4073
SELECT * FROM t1 WHERE b < 102;
4074
SELECT * FROM t1 WHERE c < 102;
4075
SELECT * FROM t1 WHERE 102 < b;
4076
SELECT * FROM t1 WHERE 102 < c;
4080
--echo End of 5.1 tests