1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
|
#
# Bug#24444899 MYSQLD CRASHED WHILE DROPPING UNIQUE KEY ...
# - test adding and using unique index of varying length
# - test drop and using unique index of varying length
#
CREATE TABLE t1 (
c1 int PRIMARY KEY, c2 int, c3 int, c4 int, c5 int,
c6 int, c7 int, c8 int, c9 int, c10 int, c11 int,
c12 int, c13 int, c14 int, c15 int, c16 int, c17 int,
c18 int, c19 int, c20 int, c21 int, c22 int, c23 int,
c24 int, c25 int, c26 int, c27 int, c28 int, c29 int,
c30 int, c31 int, c32 int, c33 int, c34 int, c35 int
) engine = NDB;
INSERT INTO t1 VALUES
(1,2,3,4,5,6,7,8,9,10,
11,12,13,14,15,16,17,18,19,20,
21,22,23,24,25,26,27,28,29,30,
31,32,33,34,35);
# Create and use unique indexes
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique1 ( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16);
SELECT c1 FROM t1 WHERE c1=1 AND c2=2 AND c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16;
c1
1
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique2 ( c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17);
SELECT c2 FROM t1 WHERE c2=2 AND c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17;
c2
2
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique3 ( c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18);
SELECT c3 FROM t1 WHERE c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18;
c3
3
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique4 ( c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19);
SELECT c4 FROM t1 WHERE c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19;
c4
4
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique5 ( c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20);
SELECT c5 FROM t1 WHERE c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20;
c5
5
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique6 ( c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21);
SELECT c6 FROM t1 WHERE c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21;
c6
6
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique7 ( c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22);
SELECT c7 FROM t1 WHERE c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22;
c7
7
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique8 ( c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23);
SELECT c8 FROM t1 WHERE c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23;
c8
8
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique9 ( c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24);
SELECT c9 FROM t1 WHERE c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24;
c9
9
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique10 ( c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25);
SELECT c10 FROM t1 WHERE c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25;
c10
10
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique11 ( c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26);
SELECT c11 FROM t1 WHERE c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26;
c11
11
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique12 ( c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27);
SELECT c12 FROM t1 WHERE c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27;
c12
12
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique13 ( c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28);
SELECT c13 FROM t1 WHERE c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28;
c13
13
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique14 ( c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29);
SELECT c14 FROM t1 WHERE c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29;
c14
14
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique15 ( c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30);
SELECT c15 FROM t1 WHERE c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30;
c15
15
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique16 ( c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31);
SELECT c16 FROM t1 WHERE c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31;
c16
16
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique17 ( c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32);
SELECT c17 FROM t1 WHERE c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32;
c17
17
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique18 ( c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33);
SELECT c18 FROM t1 WHERE c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33;
c18
18
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique19 ( c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c19 FROM t1 WHERE c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c19
19
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique20 ( c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c20 FROM t1 WHERE c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c20
20
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique21 ( c21, c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c21 FROM t1 WHERE c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c21
21
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique22 ( c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c22 FROM t1 WHERE c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c22
22
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique23 ( c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c23 FROM t1 WHERE c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c23
23
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique24 ( c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c24 FROM t1 WHERE c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c24
24
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique25 ( c25, c26, c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c25 FROM t1 WHERE c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c25
25
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique26 ( c26, c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c26 FROM t1 WHERE c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c26
26
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique27 ( c27, c28, c29, c30, c31, c32, c33, c34);
SELECT c27 FROM t1 WHERE c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c27
27
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique28 ( c28, c29, c30, c31, c32, c33, c34);
SELECT c28 FROM t1 WHERE c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c28
28
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique29 ( c29, c30, c31, c32, c33, c34);
SELECT c29 FROM t1 WHERE c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c29
29
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique30 ( c30, c31, c32, c33, c34);
SELECT c30 FROM t1 WHERE c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c30
30
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique31 ( c31, c32, c33, c34);
SELECT c31 FROM t1 WHERE c31=31 AND c32=32 AND c33=33 AND c34=34;
c31
31
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique32 ( c32, c33, c34);
SELECT c32 FROM t1 WHERE c32=32 AND c33=33 AND c34=34;
c32
32
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique33 ( c33, c34);
SELECT c33 FROM t1 WHERE c33=33 AND c34=34;
c33
33
ALTER TABLE t1 ALGORITHM=inplace, ADD UNIQUE INDEX unique34 ( c34);
SELECT c34 FROM t1 WHERE c34=34;
c34
34
# Some handcrafted use of unique indexes, also where row does not exist
SELECT c35 FROM t1 WHERE c2=2 AND c3=3 AND c4=4 /* not full index */;
c35
35
SELECT c35 FROM t1
WHERE c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND
c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND
c31=31 AND c32=32 /* full unique index */;
c35
35
SELECT c35 FROM t1
WHERE c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND
c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND
c31=31 AND c32=37 /* row does not exist */;
c35
SELECT c35 FROM t1 WHERE c35=35 /* no index on this column */;
c35
35
# Drop and use unique indexes
SELECT c1 FROM t1 WHERE c1=1 AND c2=2 AND c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 /* read before drop */;
c1
1
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique1;
SELECT c1 FROM t1 WHERE c1=1 AND c2=2 AND c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16;
c1
1
SELECT c2 FROM t1 WHERE c2=2 AND c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 /* read before drop */;
c2
2
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique2;
SELECT c2 FROM t1 WHERE c2=2 AND c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17;
c2
2
SELECT c3 FROM t1 WHERE c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 /* read before drop */;
c3
3
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique3;
SELECT c3 FROM t1 WHERE c3=3 AND c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18;
c3
3
SELECT c4 FROM t1 WHERE c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 /* read before drop */;
c4
4
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique4;
SELECT c4 FROM t1 WHERE c4=4 AND c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19;
c4
4
SELECT c5 FROM t1 WHERE c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 /* read before drop */;
c5
5
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique5;
SELECT c5 FROM t1 WHERE c5=5 AND c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20;
c5
5
SELECT c6 FROM t1 WHERE c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 /* read before drop */;
c6
6
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique6;
SELECT c6 FROM t1 WHERE c6=6 AND c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21;
c6
6
SELECT c7 FROM t1 WHERE c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 /* read before drop */;
c7
7
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique7;
SELECT c7 FROM t1 WHERE c7=7 AND c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22;
c7
7
SELECT c8 FROM t1 WHERE c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 /* read before drop */;
c8
8
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique8;
SELECT c8 FROM t1 WHERE c8=8 AND c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23;
c8
8
SELECT c9 FROM t1 WHERE c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 /* read before drop */;
c9
9
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique9;
SELECT c9 FROM t1 WHERE c9=9 AND c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24;
c9
9
SELECT c10 FROM t1 WHERE c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 /* read before drop */;
c10
10
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique10;
SELECT c10 FROM t1 WHERE c10=10 AND c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25;
c10
10
SELECT c11 FROM t1 WHERE c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 /* read before drop */;
c11
11
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique11;
SELECT c11 FROM t1 WHERE c11=11 AND c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26;
c11
11
SELECT c12 FROM t1 WHERE c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 /* read before drop */;
c12
12
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique12;
SELECT c12 FROM t1 WHERE c12=12 AND c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27;
c12
12
SELECT c13 FROM t1 WHERE c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 /* read before drop */;
c13
13
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique13;
SELECT c13 FROM t1 WHERE c13=13 AND c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28;
c13
13
SELECT c14 FROM t1 WHERE c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 /* read before drop */;
c14
14
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique14;
SELECT c14 FROM t1 WHERE c14=14 AND c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29;
c14
14
SELECT c15 FROM t1 WHERE c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 /* read before drop */;
c15
15
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique15;
SELECT c15 FROM t1 WHERE c15=15 AND c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30;
c15
15
SELECT c16 FROM t1 WHERE c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 /* read before drop */;
c16
16
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique16;
SELECT c16 FROM t1 WHERE c16=16 AND c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31;
c16
16
SELECT c17 FROM t1 WHERE c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 /* read before drop */;
c17
17
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique17;
SELECT c17 FROM t1 WHERE c17=17 AND c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32;
c17
17
SELECT c18 FROM t1 WHERE c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 /* read before drop */;
c18
18
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique18;
SELECT c18 FROM t1 WHERE c18=18 AND c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33;
c18
18
SELECT c19 FROM t1 WHERE c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c19
19
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique19;
SELECT c19 FROM t1 WHERE c19=19 AND c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c19
19
SELECT c20 FROM t1 WHERE c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c20
20
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique20;
SELECT c20 FROM t1 WHERE c20=20 AND c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c20
20
SELECT c21 FROM t1 WHERE c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c21
21
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique21;
SELECT c21 FROM t1 WHERE c21=21 AND c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c21
21
SELECT c22 FROM t1 WHERE c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c22
22
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique22;
SELECT c22 FROM t1 WHERE c22=22 AND c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c22
22
SELECT c23 FROM t1 WHERE c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c23
23
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique23;
SELECT c23 FROM t1 WHERE c23=23 AND c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c23
23
SELECT c24 FROM t1 WHERE c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c24
24
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique24;
SELECT c24 FROM t1 WHERE c24=24 AND c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c24
24
SELECT c25 FROM t1 WHERE c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c25
25
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique25;
SELECT c25 FROM t1 WHERE c25=25 AND c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c25
25
SELECT c26 FROM t1 WHERE c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c26
26
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique26;
SELECT c26 FROM t1 WHERE c26=26 AND c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c26
26
SELECT c27 FROM t1 WHERE c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c27
27
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique27;
SELECT c27 FROM t1 WHERE c27=27 AND c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c27
27
SELECT c28 FROM t1 WHERE c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c28
28
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique28;
SELECT c28 FROM t1 WHERE c28=28 AND c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c28
28
SELECT c29 FROM t1 WHERE c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c29
29
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique29;
SELECT c29 FROM t1 WHERE c29=29 AND c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c29
29
SELECT c30 FROM t1 WHERE c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c30
30
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique30;
SELECT c30 FROM t1 WHERE c30=30 AND c31=31 AND c32=32 AND c33=33 AND c34=34;
c30
30
SELECT c31 FROM t1 WHERE c31=31 AND c32=32 AND c33=33 AND c34=34 /* read before drop */;
c31
31
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique31;
SELECT c31 FROM t1 WHERE c31=31 AND c32=32 AND c33=33 AND c34=34;
c31
31
SELECT c32 FROM t1 WHERE c32=32 AND c33=33 AND c34=34 /* read before drop */;
c32
32
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique32;
SELECT c32 FROM t1 WHERE c32=32 AND c33=33 AND c34=34;
c32
32
SELECT c33 FROM t1 WHERE c33=33 AND c34=34 /* read before drop */;
c33
33
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique33;
SELECT c33 FROM t1 WHERE c33=33 AND c34=34;
c33
33
SELECT c34 FROM t1 WHERE c34=34 /* read before drop */;
c34
34
ALTER TABLE t1 ALGORITHM=inplace, DROP INDEX unique34;
SELECT c34 FROM t1 WHERE c34=34;
c34
34
DROP TABLE t1;
|
