oceanbase

1
drop table if exists t1, t2, t3;
2
CREATE TABLE t1 (
3
event_date datetime DEFAULT '2014-02-22' NOT NULL,
4
obtype int DEFAULT '0' NOT NULL,
5
event_id int DEFAULT '0' NOT NULL,
6
extra int,
7
PRIMARY KEY (event_date,obtype,event_id)
8
);
9
INSERT INTO t1(event_date,obtype,event_id) VALUES ('1999-07-10',100100,24), ('1999-07-11',100100,25),
10
('1999-07-13',100600,0), ('1999-07-13',100600,4), ('1999-07-13',100600,26),
11
('1999-07-14',100600,10), ('1999-07-15',100600,16), ('1999-07-15',100800,45),
12
('1999-07-15',101000,47), ('1999-07-16',100800,46), ('1999-07-20',100600,5),
13
('1999-07-20',100600,27), ('1999-07-21',100600,11), ('1999-07-22',100600,17),
14
('1999-07-23',100100,39), ('1999-07-24',100100,39), ('1999-07-24',100500,40),
15
('1999-07-25',100100,39), ('1999-07-27',100600,1), ('1999-07-27',100600,6),
16
('1999-07-27',100600,28), ('1999-07-28',100600,12), ('1999-07-29',100500,41),
17
('1999-07-29',100600,18), ('1999-07-30',100500,41), ('1999-07-31',100500,41),
18
('1999-08-01',100700,34), ('1999-08-03',100600,7), ('1999-08-03',100600,29),
19
('1999-08-04',100600,13), ('1999-08-05',100500,42), ('1999-08-05',100600,19),
20
('1999-08-06',100500,42), ('1999-08-07',100500,42), ('1999-08-08',100500,42),
21
('1999-08-10',100600,2), ('1999-08-10',100600,9), ('1999-08-10',100600,30),
22
('1999-08-11',100600,14), ('1999-08-12',100600,20), ('1999-08-17',100500,8),
23
('1999-08-17',100600,31), ('1999-08-18',100600,15), ('1999-08-19',100600,22),
24
('1999-08-24',100600,3), ('1999-08-24',100600,32), ('1999-08-27',100500,43),
25
('1999-08-31',100600,33), ('1999-09-17',100100,37), ('1999-09-18',100100,37),
26
('1999-09-19',100100,37), ('2000-12-18',100700,38);
27
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;
28
event_date	obtype	event_id
29
1999-07-10 00:00:00	100100	24
30
1999-07-11 00:00:00	100100	25
31
1999-07-13 00:00:00	100600	0
32
1999-07-13 00:00:00	100600	4
33
1999-07-13 00:00:00	100600	26
34
1999-07-14 00:00:00	100600	10
35
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;
36
event_date	obtype	event_id
37
1999-07-10 00:00:00	100100	24
38
1999-07-11 00:00:00	100100	25
39
1999-07-13 00:00:00	100600	0
40
1999-07-13 00:00:00	100600	4
41
1999-07-13 00:00:00	100600	26
42
1999-07-14 00:00:00	100600	10
43
1999-07-15 00:00:00	100600	16
44
drop table t1;
45
CREATE TABLE t1 (
46
PAPER_ID smallint DEFAULT '0' NOT NULL,
47
YEAR smallint DEFAULT '0' NOT NULL,
48
ISSUE smallint DEFAULT '0' NOT NULL,
49
CLOSED tinyint DEFAULT '0' NOT NULL,
50
ISS_DATE datetime DEFAULT '2014-02-22' NOT NULL,
51
PRIMARY KEY (PAPER_ID,YEAR,ISSUE)
52
);
53
INSERT INTO t1 VALUES (3,1999,34,0,'1999-07-12'), (1,1999,111,0,'1999-03-23'),
54
(1,1999,222,0,'1999-03-23'), (3,1999,33,0,'1999-07-12'),
55
(3,1999,32,0,'1999-07-12'), (3,1999,31,0,'1999-07-12'),
56
(3,1999,30,0,'1999-07-12'), (3,1999,29,0,'1999-07-12'),
57
(3,1999,28,0,'1999-07-12'), (1,1999,40,1,'1999-05-01'),
58
(1,1999,41,1,'1999-05-01'), (1,1999,42,1,'1999-05-01'),
59
(1,1999,46,1,'1999-05-01'), (1,1999,47,1,'1999-05-01'),
60
(1,1999,48,1,'1999-05-01'), (1,1999,49,1,'1999-05-01'),
61
(1,1999,50,0,'1999-05-01'), (1,1999,51,0,'1999-05-01'),
62
(1,1999,200,0,'1999-06-28'), (1,1999,52,0,'1999-06-28'),
63
(1,1999,53,0,'1999-06-28'), (1,1999,54,0,'1999-06-28'),
64
(1,1999,55,0,'1999-06-28'), (1,1999,56,0,'1999-07-01'),
65
(1,1999,57,0,'1999-07-01'), (1,1999,58,0,'1999-07-01'),
66
(1,1999,59,0,'1999-07-01'), (1,1999,60,0,'1999-07-01'),
67
(3,1999,35,0,'1999-07-12');
68
select YEAR,ISSUE from t1 where PAPER_ID=3 and (YEAR>1999 or (YEAR=1999 and ISSUE>28))  order by YEAR,ISSUE;
69
YEAR	ISSUE
70
1999	29
71
1999	30
72
1999	31
73
1999	32
74
1999	33
75
1999	34
76
1999	35
77
drop table t1;
78
CREATE TABLE t1 (
79
id int NOT NULL auto_increment,
80
parent_id int DEFAULT '0' NOT NULL,
81
`level` tinyint DEFAULT '0' NOT NULL,
82
PRIMARY KEY (id)
83
);
84
INSERT INTO t1 VALUES (1,0,0), (3,1,1), (4,1,1), (8,2,2), (9,2,2), (17,3,2),
85
(22,4,2), (24,4,2), (28,5,2), (29,5,2), (30,5,2), (31,6,2), (32,6,2), (33,6,2),
86
(203,7,2), (202,7,2), (20,3,2), (157,0,0), (193,5,2), (40,7,2), (2,1,1),
87
(15,2,2), (6,1,1), (34,6,2), (35,6,2), (16,3,2), (7,1,1), (36,7,2), (18,3,2),
88
(26,5,2), (27,5,2), (183,4,2), (38,7,2), (25,5,2), (37,7,2), (21,4,2),
89
(19,3,2), (5,1,1), (179,5,2);
90
SELECT * FROM t1 WHERE `level` = 1 AND parent_id = 1;
91
id	parent_id	level
92
2	1	1
93
3	1	1
94
4	1	1
95
5	1	1
96
6	1	1
97
7	1	1
98
SELECT * FROM t1 WHERE `level` = 1 AND parent_id = 1 order by id;
99
id	parent_id	level
100
2	1	1
101
3	1	1
102
4	1	1
103
5	1	1
104
6	1	1
105
7	1	1
106
drop table t1;
107
create table t1(
108
Satellite		varchar(25)	not null,
109
SensorMode		varchar(25)	not null,
110
FullImageCornersUpperLeftLongitude	double	not null,
111
FullImageCornersUpperRightLongitude	double	not null,
112
FullImageCornersUpperRightLatitude	double	not null,
113
FullImageCornersLowerRightLatitude	double	not null,
114
primary key(Satellite,SensorMode));
115
insert into t1 values('OV-3','PAN1',91,-92,40,50);
116
insert into t1 values('OV-4','PAN1',91,-92,40,50);
117
select * from t1 where t1.Satellite = 'OV-3' and t1.SensorMode = 'PAN1' and t1.FullImageCornersUpperLeftLongitude > -90.000000 and t1.FullImageCornersUpperRightLongitude < -82.000000;
118
Satellite	SensorMode	FullImageCornersUpperLeftLongitude	FullImageCornersUpperRightLongitude	FullImageCornersUpperRightLatitude	FullImageCornersLowerRightLatitude
119
OV-3	PAN1	91	-92	40	50
120
drop table t1;
121
create table t1 ( aString char(100) not null default '', primary key (aString) , extra char(100));
122
insert into t1 (aString) values ( 'believe in myself' ), ( 'believe' ), ('baaa' ), ( 'believe in love');
123
select * from t1 where aString < 'believe in myself' order by aString;
124
aString	extra
125
baaa	NULL
126
believe	NULL
127
believe in love	NULL
128
select * from t1 where aString > 'believe in love' order by aString;
129
aString	extra
130
believe in myself	NULL
131
drop table t1;
132
CREATE TABLE t1 (
133
t1ID int NOT NULL ,
134
art binary(1) NOT NULL default '',
135
KNR char(5) NOT NULL default '',
136
RECHNR char(6) NOT NULL default '',
137
POSNR char(2) NOT NULL default '',
138
ARTNR char(10) NOT NULL default '',
139
TEX char(70) NOT NULL default '',
140
PRIMARY KEY  (t1ID)
141
);
142
INSERT INTO t1 (t1ID,art) VALUES
143
(0,'j'),
144
(1,'J'),
145
(2,'J'),
146
(3,'j'),
147
(4,'J'),
148
(5,'J'),
149
(6,'j'),
150
(7,'J'),
151
(8,'J'),
152
(9,'j'),
153
(10,'J'),
154
(11,'J'),
155
(12,'j'),
156
(13,'J'),
157
(14,'J'),
158
(15,'j'),
159
(16,'J'),
160
(17,'J'),
161
(18,'j'),
162
(19,'J'),
163
(20,'J'),
164
(21,'j'),
165
(22,'J'),
166
(23,'J'),
167
(24,'j'),
168
(25,'J'),
169
(26,'J'),
170
(27,'j'),
171
(28,'J'),
172
(29,'J'),
173
(30,'j'),
174
(31,'J'),
175
(32,'J'),
176
(33,'j'),
177
(34,'J'),
178
(35,'J'),
179
(36,'j'),
180
(37,'J'),
181
(38,'J'),
182
(39,'j'),
183
(40,'J'),
184
(41,'J'),
185
(42,'j'),
186
(43,'J'),
187
(44,'J'),
188
(45,'j'),
189
(46,'J'),
190
(47,'J'),
191
(48,'j'),
192
(49,'J'),
193
(50,'J'),
194
(51,'j'),
195
(52,'J'),
196
(53,'J'),
197
(54,'j'),
198
(55,'J'),
199
(56,'J'),
200
(57,'j'),
201
(58,'J'),
202
(59,'J'),
203
(60,'j'),
204
(61,'J'),
205
(62,'J'),
206
(63,'j'),
207
(64,'J'),
208
(65,'J'),
209
(66,'j'),
210
(67,'J'),
211
(68,'J'),
212
(69,'j'),
213
(70,'J'),
214
(71,'J'),
215
(72,'j'),
216
(73,'J'),
217
(74,'J'),
218
(75,'j'),
219
(76,'J'),
220
(77,'J'),
221
(78,'j'),
222
(79,'J'),
223
(80,'J'),
224
(81,'j'),
225
(82,'J'),
226
(83,'J'),
227
(84,'j'),
228
(85,'J'),
229
(86,'J'),
230
(87,'j'),
231
(88,'J'),
232
(89,'J'),
233
(90,'j'),
234
(91,'J'),
235
(92,'J'),
236
(93,'j'),
237
(94,'J'),
238
(95,'J'),
239
(96,'j'),
240
(97,'J'),
241
(98,'J'),
242
(99,'j'),
243
(100,'J'),
244
(101,'J'),
245
(102,'j'),
246
(103,'J'),
247
(104,'J'),
248
(105,'j'),
249
(106,'J'),
250
(107,'J'),
251
(108,'j'),
252
(109,'J'),
253
(110,'J'),
254
(111,'j'),
255
(112,'J'),
256
(113,'J'),
257
(114,'j'),
258
(115,'J'),
259
(116,'J'),
260
(117,'j'),
261
(118,'J'),
262
(119,'J'),
263
(120,'j'),
264
(121,'J'),
265
(122,'J'),
266
(123,'j'),
267
(124,'J'),
268
(125,'J'),
269
(126,'j'),
270
(127,'J'),
271
(128,'J'),
272
(129,'j'),
273
(130,'J'),
274
(131,'J'),
275
(132,'j'),
276
(133,'J'),
277
(134,'J'),
278
(135,'j'),
279
(136,'J'),
280
(137,'J'),
281
(138,'j'),
282
(139,'J'),
283
(140,'J'),
284
(141,'j'),
285
(142,'J'),
286
(143,'J'),
287
(144,'j'),
288
(145,'J'),
289
(146,'J'),
290
(147,'j'),
291
(148,'J'),
292
(149,'J'),
293
(150,'j'),
294
(151,'J'),
295
(152,'J'),
296
(153,'j'),
297
(154,'J'),
298
(155,'J'),
299
(156,'j'),
300
(157,'J'),
301
(158,'J'),
302
(159,'j'),
303
(160,'J'),
304
(161,'J'),
305
(162,'j'),
306
(163,'J'),
307
(164,'J'),
308
(165,'j'),
309
(166,'J'),
310
(167,'J'),
311
(168,'j'),
312
(169,'J'),
313
(170,'J'),
314
(171,'j'),
315
(172,'J'),
316
(173,'J'),
317
(174,'j'),
318
(175,'J'),
319
(176,'J'),
320
(177,'j'),
321
(178,'J'),
322
(179,'J'),
323
(180,'j'),
324
(181,'J'),
325
(182,'J'),
326
(183,'j'),
327
(184,'J'),
328
(185,'J'),
329
(186,'j'),
330
(187,'J'),
331
(188,'J'),
332
(189,'j'),
333
(190,'J'),
334
(191,'J'),
335
(192,'j'),
336
(193,'J'),
337
(194,'J'),
338
(195,'j'),
339
(196,'J'),
340
(197,'J'),
341
(198,'j'),
342
(199,'J');
343
select count(*) from t1 where upper(art) = 'J';
344
count(*)
345
133
346
select count(*) from t1 where art = 'J' or art = 'j';
347
count(*)
348
200
349
select count(*) from t1 where art = 'j' or art = 'J';
350
count(*)
351
200
352
select count(*) from t1 where art = 'j';
353
count(*)
354
67
355
select count(*) from t1 where art = 'J';
356
count(*)
357
133
358
drop table t1;
359
CREATE TABLE t1 (
360
a int,
361
b int,
362
c int,
363
primary key(a,b)
364
);
365
INSERT INTO t1(a,b) VALUES
366
(1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,2),
367
(13,2),(14,2),(15,2),(16,2),(17,3),(16,3),(19,3),(20,3),
368
(21,4),(22,5),(23,5),(24,5),(25,5),(26,5),(30,5),(31,5),(32,5),
369
(33,5),(34,5),(35,5);
370
SELECT * FROM t1 WHERE a IN(1,2) AND b=5;
371
a	b	c
372
DROP TABLE t1;
373
create table t1(c1 varchar(1024),c2 varchar(1024), c3 varchar(1024), primary key(c1,c2,c3), extra varchar(1024));
374
insert into t1(c1,c2,c3) values ('s1_1','s1_2','s1_3'),('s2_1','s2_2','s2_3');
375
select * from t1 where c1 in ('s1_1','s2_1') and c2 in ('s2_1','s1_2');
376
c1	c2	c3	extra
377
s1_1	s1_2	s1_3	NULL
378
drop table t1;
379
create table t2 (x bigint not null primary key, y bigint);
380
insert into t2(x) values (-16);
381
insert into t2(x) values (-15);
382
select * from t2;
383
x	y
384
-16	NULL
385
-15	NULL
386
select count(*) from t2 where x>0;
387
count(*)
388
0
389
select count(*) from t2 where x=0;
390
count(*)
391
0
392
select count(*) from t2 where x<0;
393
count(*)
394
2
395
select count(*) from t2 where x < -16;
396
count(*)
397
0
398
select count(*) from t2 where x = -16;
399
count(*)
400
1
401
select count(*) from t2 where x > -16;
402
count(*)
403
1
404
select count(*) from t2 where x = 1844674407370955160;
405
count(*)
406
0
407
drop table t2;
408
create table t1 (
409
c1  char(10) primary key, c2  char(10), c3  char(10), c4  char(10),
410
c5  char(10), c6  char(10), c7  char(10), c8  char(10),
411
c9  char(10), c10 char(10), c11 char(10), c12 char(10),
412
c13 char(10), c14 char(10), c15 char(10), c16 char(10)
413
);
414
insert into t1 (c1) values ('1');
415
select * from t1 where
416
c1 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
417
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
418
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
419
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
420
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
421
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
422
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
423
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
424
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
425
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
426
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
427
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
428
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
429
and c2 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
430
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
431
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
432
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
433
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
434
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
435
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
436
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
437
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
438
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
439
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
440
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
441
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
442
and c3 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
443
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
444
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
445
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
446
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
447
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
448
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
449
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
450
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
451
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
452
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
453
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
454
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
455
and c4 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
456
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
457
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
458
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
459
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
460
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
461
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
462
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
463
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
464
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
465
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
466
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
467
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
468
and c5 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
469
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
470
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
471
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
472
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
473
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
474
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
475
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
476
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
477
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
478
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
479
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
480
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
481
and c6 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
482
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
483
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
484
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
485
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
486
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
487
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
488
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
489
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
490
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
491
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
492
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
493
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
494
and c7 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
495
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
496
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
497
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
498
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
499
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
500
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
501
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
502
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
503
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
504
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
505
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
506
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
507
and c8 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
508
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
509
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
510
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
511
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
512
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
513
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
514
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
515
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
516
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
517
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
518
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
519
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
520
and c9 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
521
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
522
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
523
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
524
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
525
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
526
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
527
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
528
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
529
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
530
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
531
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
532
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC')
533
and c10 in ('abcdefgh', '123456789', 'qwertyuio', 'asddfgh',
534
'abcdefg1', '123456781', 'qwertyui1', 'asddfg1',
535
'abcdefg2', '123456782', 'qwertyui2', 'asddfg2',
536
'abcdefg3', '123456783', 'qwertyui3', 'asddfg3',
537
'abcdefg4', '123456784', 'qwertyui4', 'asddfg4',
538
'abcdefg5', '123456785', 'qwertyui5', 'asddfg5',
539
'abcdefg6', '123456786', 'qwertyui6', 'asddfg6',
540
'abcdefg7', '123456787', 'qwertyui7', 'asddfg7',
541
'abcdefg8', '123456788', 'qwertyui8', 'asddfg8',
542
'abcdefg9', '123456789', 'qwertyui9', 'asddfg9',
543
'abcdefgA', '12345678A', 'qwertyuiA', 'asddfgA',
544
'abcdefgB', '12345678B', 'qwertyuiB', 'asddfgB',
545
'abcdefgC', '12345678C', 'qwertyuiC', 'asddfgC');
546
c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16
547
drop table t1;
548