Debian Codegraph @

mysql-test/suite/ndb_ddl/alter_inplace_unique_index.result

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