oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: yuchen.wyc
5
# owner group: sql4
6
# description:范围查询测试
7
#
8
# Problem with range optimizer
9
#
10

11
--disable_warnings
12
drop table if exists t1, t2, t3;
13
--enable_warnings
14

15
CREATE TABLE t1 (
16
  event_date datetime DEFAULT '2014-02-22' NOT NULL,
17
  obtype int DEFAULT '0' NOT NULL,
18
  event_id int DEFAULT '0' NOT NULL,
19
  extra int,
20
  PRIMARY KEY (event_date,obtype,event_id)
21
);
22

23
INSERT INTO t1(event_date,obtype,event_id) VALUES ('1999-07-10',100100,24), ('1999-07-11',100100,25),
24
('1999-07-13',100600,0), ('1999-07-13',100600,4), ('1999-07-13',100600,26),
25
('1999-07-14',100600,10), ('1999-07-15',100600,16), ('1999-07-15',100800,45),
26
('1999-07-15',101000,47), ('1999-07-16',100800,46), ('1999-07-20',100600,5),
27
('1999-07-20',100600,27), ('1999-07-21',100600,11), ('1999-07-22',100600,17),
28
('1999-07-23',100100,39), ('1999-07-24',100100,39), ('1999-07-24',100500,40),
29
('1999-07-25',100100,39), ('1999-07-27',100600,1), ('1999-07-27',100600,6),
30
('1999-07-27',100600,28), ('1999-07-28',100600,12), ('1999-07-29',100500,41),
31
('1999-07-29',100600,18), ('1999-07-30',100500,41), ('1999-07-31',100500,41),
32
('1999-08-01',100700,34), ('1999-08-03',100600,7), ('1999-08-03',100600,29),
33
('1999-08-04',100600,13), ('1999-08-05',100500,42), ('1999-08-05',100600,19),
34
('1999-08-06',100500,42), ('1999-08-07',100500,42), ('1999-08-08',100500,42),
35
('1999-08-10',100600,2), ('1999-08-10',100600,9), ('1999-08-10',100600,30),
36
('1999-08-11',100600,14), ('1999-08-12',100600,20), ('1999-08-17',100500,8),
37
('1999-08-17',100600,31), ('1999-08-18',100600,15), ('1999-08-19',100600,22),
38
('1999-08-24',100600,3), ('1999-08-24',100600,32), ('1999-08-27',100500,43),
39
('1999-08-31',100600,33), ('1999-09-17',100100,37), ('1999-09-18',100100,37),
40
('1999-09-19',100100,37), ('2000-12-18',100700,38);
41

42
select event_date,obtype,event_id from t1 WHERE event_date >= '1999-07-01' AND event_date < '1999-07-15' AND (obtype=100600 OR obtype=100100) ORDER BY event_date;
43
select event_date,obtype,event_id from t1 WHERE event_date >= '1999-07-01' AND event_date <= '1999-07-15' AND (obtype=100600 OR obtype=100100) or event_date >= '1999-07-01' AND event_date <= '1999-07-15' AND obtype=100099;
44
drop table t1;
45

46
CREATE TABLE t1 (
47
  PAPER_ID smallint DEFAULT '0' NOT NULL,
48
  YEAR smallint DEFAULT '0' NOT NULL,
49
  ISSUE smallint DEFAULT '0' NOT NULL,
50
  CLOSED tinyint DEFAULT '0' NOT NULL,
51
  ISS_DATE datetime DEFAULT '2014-02-22' NOT NULL,
52
  PRIMARY KEY (PAPER_ID,YEAR,ISSUE)
53
);
54
INSERT INTO t1 VALUES (3,1999,34,0,'1999-07-12'), (1,1999,111,0,'1999-03-23'),
55
                      (1,1999,222,0,'1999-03-23'), (3,1999,33,0,'1999-07-12'),
56
                      (3,1999,32,0,'1999-07-12'), (3,1999,31,0,'1999-07-12'),
57
                      (3,1999,30,0,'1999-07-12'), (3,1999,29,0,'1999-07-12'),
58
                      (3,1999,28,0,'1999-07-12'), (1,1999,40,1,'1999-05-01'),
59
                      (1,1999,41,1,'1999-05-01'), (1,1999,42,1,'1999-05-01'),
60
                      (1,1999,46,1,'1999-05-01'), (1,1999,47,1,'1999-05-01'),
61
                      (1,1999,48,1,'1999-05-01'), (1,1999,49,1,'1999-05-01'),
62
                      (1,1999,50,0,'1999-05-01'), (1,1999,51,0,'1999-05-01'),
63
                      (1,1999,200,0,'1999-06-28'), (1,1999,52,0,'1999-06-28'),
64
                      (1,1999,53,0,'1999-06-28'), (1,1999,54,0,'1999-06-28'),
65
                      (1,1999,55,0,'1999-06-28'), (1,1999,56,0,'1999-07-01'),
66
                      (1,1999,57,0,'1999-07-01'), (1,1999,58,0,'1999-07-01'),
67
                      (1,1999,59,0,'1999-07-01'), (1,1999,60,0,'1999-07-01'),
68
                      (3,1999,35,0,'1999-07-12');
69
select YEAR,ISSUE from t1 where PAPER_ID=3 and (YEAR>1999 or (YEAR=1999 and ISSUE>28))  order by YEAR,ISSUE;
70
drop table t1;
71

72
CREATE TABLE t1 (
73
  id int NOT NULL auto_increment,
74
  parent_id int DEFAULT '0' NOT NULL,
75
  `level` tinyint DEFAULT '0' NOT NULL,
76
  PRIMARY KEY (id)
77
);
78
INSERT INTO t1 VALUES (1,0,0), (3,1,1), (4,1,1), (8,2,2), (9,2,2), (17,3,2),
79
(22,4,2), (24,4,2), (28,5,2), (29,5,2), (30,5,2), (31,6,2), (32,6,2), (33,6,2),
80
(203,7,2), (202,7,2), (20,3,2), (157,0,0), (193,5,2), (40,7,2), (2,1,1),
81
(15,2,2), (6,1,1), (34,6,2), (35,6,2), (16,3,2), (7,1,1), (36,7,2), (18,3,2),
82
(26,5,2), (27,5,2), (183,4,2), (38,7,2), (25,5,2), (37,7,2), (21,4,2),
83
(19,3,2), (5,1,1), (179,5,2);
84
SELECT * FROM t1 WHERE `level` = 1 AND parent_id = 1;
85
# The following select returned 0 rows in 3.23.8
86
SELECT * FROM t1 WHERE `level` = 1 AND parent_id = 1 order by id;
87
drop table t1;
88

89
#
90
# Testing of bug in range optimizer with many key parts and > and <
91
#
92

93
create table t1(
94
		Satellite		varchar(25)	not null,
95
		SensorMode		varchar(25)	not null,
96
		FullImageCornersUpperLeftLongitude	double	not null,
97
		FullImageCornersUpperRightLongitude	double	not null,
98
		FullImageCornersUpperRightLatitude	double	not null,
99
		FullImageCornersLowerRightLatitude	double	not null,
100
	        primary key(Satellite,SensorMode));
101

102
insert into t1 values('OV-3','PAN1',91,-92,40,50);
103
insert into t1 values('OV-4','PAN1',91,-92,40,50);
104

105
select * from t1 where t1.Satellite = 'OV-3' and t1.SensorMode = 'PAN1' and t1.FullImageCornersUpperLeftLongitude > -90.000000 and t1.FullImageCornersUpperRightLongitude < -82.000000;
106
drop table t1;
107

108
create table t1 ( aString char(100) not null default '', primary key (aString) , extra char(100));
109
insert into t1 (aString) values ( 'believe in myself' ), ( 'believe' ), ('baaa' ), ( 'believe in love');
110
select * from t1 where aString < 'believe in myself' order by aString;
111
select * from t1 where aString > 'believe in love' order by aString;
112
drop table t1;
113

114
#
115
# Problem with binary strings
116
#
117

118
CREATE TABLE t1 (
119
  t1ID int NOT NULL ,
120
  art binary(1) NOT NULL default '',
121
  KNR char(5) NOT NULL default '',
122
  RECHNR char(6) NOT NULL default '',
123
  POSNR char(2) NOT NULL default '',
124
  ARTNR char(10) NOT NULL default '',
125
  TEX char(70) NOT NULL default '',
126
  PRIMARY KEY  (t1ID)
127
);
128

129
INSERT INTO t1 (t1ID,art) VALUES
130
(0,'j'),
131
(1,'J'),
132
(2,'J'),
133
(3,'j'),
134
(4,'J'),
135
(5,'J'),
136
(6,'j'),
137
(7,'J'),
138
(8,'J'),
139
(9,'j'),
140
(10,'J'),
141
(11,'J'),
142
(12,'j'),
143
(13,'J'),
144
(14,'J'),
145
(15,'j'),
146
(16,'J'),
147
(17,'J'),
148
(18,'j'),
149
(19,'J'),
150
(20,'J'),
151
(21,'j'),
152
(22,'J'),
153
(23,'J'),
154
(24,'j'),
155
(25,'J'),
156
(26,'J'),
157
(27,'j'),
158
(28,'J'),
159
(29,'J'),
160
(30,'j'),
161
(31,'J'),
162
(32,'J'),
163
(33,'j'),
164
(34,'J'),
165
(35,'J'),
166
(36,'j'),
167
(37,'J'),
168
(38,'J'),
169
(39,'j'),
170
(40,'J'),
171
(41,'J'),
172
(42,'j'),
173
(43,'J'),
174
(44,'J'),
175
(45,'j'),
176
(46,'J'),
177
(47,'J'),
178
(48,'j'),
179
(49,'J'),
180
(50,'J'),
181
(51,'j'),
182
(52,'J'),
183
(53,'J'),
184
(54,'j'),
185
(55,'J'),
186
(56,'J'),
187
(57,'j'),
188
(58,'J'),
189
(59,'J'),
190
(60,'j'),
191
(61,'J'),
192
(62,'J'),
193
(63,'j'),
194
(64,'J'),
195
(65,'J'),
196
(66,'j'),
197
(67,'J'),
198
(68,'J'),
199
(69,'j'),
200
(70,'J'),
201
(71,'J'),
202
(72,'j'),
203
(73,'J'),
204
(74,'J'),
205
(75,'j'),
206
(76,'J'),
207
(77,'J'),
208
(78,'j'),
209
(79,'J'),
210
(80,'J'),
211
(81,'j'),
212
(82,'J'),
213
(83,'J'),
214
(84,'j'),
215
(85,'J'),
216
(86,'J'),
217
(87,'j'),
218
(88,'J'),
219
(89,'J'),
220
(90,'j'),
221
(91,'J'),
222
(92,'J'),
223
(93,'j'),
224
(94,'J'),
225
(95,'J'),
226
(96,'j'),
227
(97,'J'),
228
(98,'J'),
229
(99,'j'),
230
(100,'J'),
231
(101,'J'),
232
(102,'j'),
233
(103,'J'),
234
(104,'J'),
235
(105,'j'),
236
(106,'J'),
237
(107,'J'),
238
(108,'j'),
239
(109,'J'),
240
(110,'J'),
241
(111,'j'),
242
(112,'J'),
243
(113,'J'),
244
(114,'j'),
245
(115,'J'),
246
(116,'J'),
247
(117,'j'),
248
(118,'J'),
249
(119,'J'),
250
(120,'j'),
251
(121,'J'),
252
(122,'J'),
253
(123,'j'),
254
(124,'J'),
255
(125,'J'),
256
(126,'j'),
257
(127,'J'),
258
(128,'J'),
259
(129,'j'),
260
(130,'J'),
261
(131,'J'),
262
(132,'j'),
263
(133,'J'),
264
(134,'J'),
265
(135,'j'),
266
(136,'J'),
267
(137,'J'),
268
(138,'j'),
269
(139,'J'),
270
(140,'J'),
271
(141,'j'),
272
(142,'J'),
273
(143,'J'),
274
(144,'j'),
275
(145,'J'),
276
(146,'J'),
277
(147,'j'),
278
(148,'J'),
279
(149,'J'),
280
(150,'j'),
281
(151,'J'),
282
(152,'J'),
283
(153,'j'),
284
(154,'J'),
285
(155,'J'),
286
(156,'j'),
287
(157,'J'),
288
(158,'J'),
289
(159,'j'),
290
(160,'J'),
291
(161,'J'),
292
(162,'j'),
293
(163,'J'),
294
(164,'J'),
295
(165,'j'),
296
(166,'J'),
297
(167,'J'),
298
(168,'j'),
299
(169,'J'),
300
(170,'J'),
301
(171,'j'),
302
(172,'J'),
303
(173,'J'),
304
(174,'j'),
305
(175,'J'),
306
(176,'J'),
307
(177,'j'),
308
(178,'J'),
309
(179,'J'),
310
(180,'j'),
311
(181,'J'),
312
(182,'J'),
313
(183,'j'),
314
(184,'J'),
315
(185,'J'),
316
(186,'j'),
317
(187,'J'),
318
(188,'J'),
319
(189,'j'),
320
(190,'J'),
321
(191,'J'),
322
(192,'j'),
323
(193,'J'),
324
(194,'J'),
325
(195,'j'),
326
(196,'J'),
327
(197,'J'),
328
(198,'j'),
329
(199,'J');
330
select count(*) from t1 where upper(art) = 'J';
331
select count(*) from t1 where art = 'J' or art = 'j';
332
select count(*) from t1 where art = 'j' or art = 'J';
333
select count(*) from t1 where art = 'j';
334
select count(*) from t1 where art = 'J';
335
drop table t1;
336

337
CREATE TABLE t1 (
338
  a int,
339
  b int,
340
  c int,
341
  primary key(a,b)
342
);
343

344

345
INSERT INTO t1(a,b) VALUES
346
(1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,2),
347
(13,2),(14,2),(15,2),(16,2),(17,3),(16,3),(19,3),(20,3),
348
(21,4),(22,5),(23,5),(24,5),(25,5),(26,5),(30,5),(31,5),(32,5),
349
(33,5),(34,5),(35,5);
350

351
# we expect that optimizer will choose index on A
352
SELECT * FROM t1 WHERE a IN(1,2) AND b=5;
353
DROP TABLE t1;
354

355
#
356
# Test of problem with IN on many different keyparts. (Bug #4157)
357
#
358
create table t1(c1 varchar(1024),c2 varchar(1024), c3 varchar(1024), primary key(c1,c2,c3), extra varchar(1024));
359
insert into t1(c1,c2,c3) values ('s1_1','s1_2','s1_3'),('s2_1','s2_2','s2_3');
360
select * from t1 where c1 in ('s1_1','s2_1') and c2 in ('s2_1','s1_2');
361
drop table t1;
362

363

364
create table t2 (x bigint not null primary key, y bigint);
365
insert into t2(x) values (-16);
366
insert into t2(x) values (-15);
367
select * from t2;
368
select count(*) from t2 where x>0;
369
select count(*) from t2 where x=0;
370
select count(*) from t2 where x<0;
371
select count(*) from t2 where x < -16;
372
select count(*) from t2 where x = -16;
373
select count(*) from t2 where x > -16;
374
select count(*) from t2 where x = 1844674407370955160;
375
drop table t2;
376

377
# BUG#26624 high mem usage (crash) in range optimizer (depends on order of fields in where)
378
create table t1 (
379
  c1  char(10) primary key, c2  char(10), c3  char(10), c4  char(10),
380
  c5  char(10), c6  char(10), c7  char(10), c8  char(10),
381
  c9  char(10), c10 char(10), c11 char(10), c12 char(10),
382
  c13 char(10), c14 char(10), c15 char(10), c16 char(10)
383
);
384
insert into t1 (c1) values ('1');
385

386
# This must run without crash and fast:
387
select * from t1 where
388
     c1 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
389
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
390
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
391
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
392
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
393
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
394
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
395
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
396
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
397
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
398
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
399
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
400
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
401
 and c2 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
402
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
403
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
404
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
405
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
406
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
407
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
408
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
409
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
410
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
411
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
412
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
413
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
414
 and c3 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
415
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
416
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
417
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
418
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
419
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
420
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
421
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
422
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
423
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
424
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
425
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
426
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
427
 and c4 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
428
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
429
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
430
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
431
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
432
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
433
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
434
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
435
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
436
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
437
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
438
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
439
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
440
 and c5 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
441
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
442
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
443
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
444
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
445
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
446
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
447
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
448
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
449
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
450
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
451
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
452
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
453
 and c6 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
454
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
455
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
456
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
457
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
458
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
459
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
460
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
461
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
462
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
463
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
464
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
465
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
466
 and c7 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
467
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
468
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
469
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
470
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
471
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
472
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
473
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
474
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
475
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
476
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
477
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
478
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
479
 and c8 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
480
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
481
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
482
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
483
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
484
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
485
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
486
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
487
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
488
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
489
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
490
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
491
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
492
 and c9 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
493
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
494
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
495
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
496
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
497
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
498
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
499
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
500
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
501
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
502
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
503
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
504
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
505
 and c10 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
506
            'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
507
            'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
508
            'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
509
            'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
510
            'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
511
            'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
512
            'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
513
            'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
514
            'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
515
            'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
516
            'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
517
            'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC');
518
drop table t1;
519