Debian Codegraph @

mysql-test/suite/innodb/r/innodb-64k.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 call mtr.add_suppression('InnoDB: Cannot add field.*because after adding it, the row size is');
3 SET SESSION innodb_strict_mode=ON;
4 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
5 ERROR HY000: Can't create table `test`.`t1` (errno: 140 "Wrong create options")
6 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
7 ERROR HY000: Can't create table `test`.`t1` (errno: 140 "Wrong create options")
8 SET SESSION innodb_strict_mode=OFF;
9 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
10 Warnings:
11 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
12 SHOW WARNINGS;
13 Level Code Message
14 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
15 DROP TABLE t1;
16 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
17 Warnings:
18 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
19 SHOW WARNINGS;
20 Level Code Message
21 Warning 1478 InnoDB: Cannot create a COMPRESSED table when innodb_page_size > 16k. Assuming ROW_FORMAT=DYNAMIC.
22 DROP TABLE t1;
23 # Test 1) Show the page size from Information Schema
24 SELECT variable_value FROM information_schema.global_status
25 WHERE LOWER(variable_name) = 'innodb_page_size';
26 variable_value
27 65536
28 # Test 4) The maximum row size is dependent upon the page size.
29 SET SESSION innodb_strict_mode = ON;
30 SELECT @@innodb_strict_mode;
31 @@innodb_strict_mode
32 1
33 CREATE TABLE tab5(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255),
34 col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255),
35 col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255),
36 col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255),
37 col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255),
38 col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255),
39 col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255),
40 col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255),
41 col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255),
42 col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255),
43 col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255),col64 CHAR(255), col65 CHAR(255))
44 ENGINE = innodb ROW_FORMAT=REDUNDANT;
45 ERROR 42000: Row size too large (> 16382). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
46 show warnings;
47 Level Code Message
48 Error 1118 Row size too large (> 16382). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
49 Warning 1030 Got error 139 "Too big row" from storage engine InnoDB
50 CREATE TABLE t1 (
51 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
52 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
53 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
54 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
55 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
56 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
57 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
58 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
59 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
60 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
61 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
62 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
63 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
64 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
65 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
66 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
67 c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
68 c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
69 c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
70 c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
71 c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
72 c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
73 c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
74 c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
75 c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
76 c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
77 c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
78 c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
79 c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
80 c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
81 c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
82 c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
83 c190 char(200), c191 char(200), c192 char(100),
84 c81 char(156)
85 ) ROW_FORMAT=compact;
86 DROP TABLE t1;
87 CREATE TABLE t1 (
88 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
89 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
90 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
91 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
92 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
93 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
94 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
95 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
96 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
97 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
98 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
99 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
100 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
101 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
102 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
103 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
104 c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
105 c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
106 c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
107 c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
108 c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
109 c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
110 c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
111 c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
112 c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
113 c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
114 c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
115 c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
116 c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
117 c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
118 c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
119 c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
120 c190 char(200), c191 char(200), c192 char(100),
121 c81 char(157)
122 ) ROW_FORMAT=compact;
123 ERROR 42000: Row size too large (> max_row_size). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
124 CREATE TABLE t1 (
125 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
126 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
127 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
128 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
129 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
130 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
131 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
132 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
133 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
134 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
135 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
136 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
137 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
138 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
139 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
140 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
141 c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
142 c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
143 c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
144 c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
145 c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
146 c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
147 c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
148 c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
149 c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
150 c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
151 c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
152 c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
153 c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
154 c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
155 c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
156 c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
157 c190 char(200), c191 char(200), c192 char(100),
158 c81 char(156)
159 ) ROW_FORMAT=dynamic;
160 DROP TABLE t1;
161 CREATE TABLE t1 (
162 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
163 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
164 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
165 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
166 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
167 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
168 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
169 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
170 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
171 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
172 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
173 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
174 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
175 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
176 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
177 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
178 c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
179 c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
180 c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
181 c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
182 c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
183 c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
184 c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
185 c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
186 c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
187 c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
188 c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
189 c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
190 c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
191 c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
192 c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
193 c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
194 c190 char(200), c191 char(200), c192 char(100),
195 c81 char(157)
196 ) ROW_FORMAT=dynamic;
197 ERROR 42000: Row size too large (> max_row_size). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
198 # Test 8) Test creating a table that could lead to undo log overflow.
199 CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
200 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
201 o blob,p blob,q blob,r blob,s blob,t blob,u blob,
202 v blob, w blob, x blob, y blob, z blob,
203 aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob,
204 ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob,
205 oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob,
206 va blob, wa blob, xa blob, ya blob, za blob,
207 ab blob,bb blob,cb blob,db blob,eb blob,fb blob,gb blob,
208 hb blob,ib blob,jb blob,kb blob,lb blob,mb blob,nb blob,
209 ob blob,pb blob,qb blob,rb blob,sb blob,tb blob,ub blob,
210 vb blob, wb blob, xb blob, yb blob, zb blob,
211 ac blob, bc blob, cc blob, dc blob, ec blob,fc blob,gc blob,
212 hc blob, ic blob, jc blob, kc blob, lc blob,mc blob,nc blob,
213 oc blob, pc blob, qc blob, rc blob, sc blob,tc blob,uc blob,
214 vc blob, wc blob, xc blob, yc blob, zc blob
215 ) ENGINE=InnoDB ROW_FORMAT=dynamic;
216 SET @a = repeat('a', 767);
217 SET @b = repeat('b', 767);
218 SET @c = repeat('c', 767);
219 SET @d = repeat('d', 767);
220 SET @e = repeat('e', 767);
221 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,
222 @a,@a,@a,@a,@a,@a,@a,
223 @a,@a,@a,@a,@a,@a,@a,
224 @a,@a,@a,@a,@a,
225 @a,@a,@a,@a,@a,@a,@a,
226 @a,@a,@a,@a,@a,@a,@a,
227 @a,@a,@a,@a,@a,@a,@a,
228 @a,@a,@a,@a,@a,
229 @a,@a,@a,@a,@a,@a,@a,
230 @a,@a,@a,@a,@a,@a,@a,
231 @a,@a,@a,@a,@a,@a,@a,
232 @a,@a,@a,@a,@a,
233 @a,@a,@a,@a,@a,@a,@a,
234 @a,@a,@a,@a,@a,@a,@a,
235 @a,@a,@a,@a,@a,@a,@a,
236 @a,@a,@a,@a,@a
237 );
238 UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
239 k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b,
240 v=@b,w=@b,x=@b,y=@b,z=@b,
241 aa=@b,ba=@b,ca=@b,da=@b,ea=@b,fa=@b,ga=@b,ha=@b,ia=@b,ja=@b,
242 ka=@b,la=@b,ma=@b,na=@b,oa=@b,pa=@b,qa=@b,ra=@b,sa=@b,ta=@b,ua=@b,
243 va=@b,wa=@b,xa=@b,ya=@b,za=@b,
244 ab=@b,bb=@b,cb=@b,db=@b,eb=@b,fb=@b,gb=@b,hb=@b,ib=@b,jb=@b,
245 kb=@b,lb=@b,mb=@b,nb=@b,ob=@b,pb=@b,qb=@b,rb=@b,sb=@b,tb=@b,ub=@b,
246 vb=@b,wb=@b,xb=@b,yb=@b,zb=@b,
247 ab=@b,bb=@b,cb=@b,db=@b,eb=@b,fb=@b,gb=@b,hb=@b,ib=@b,jb=@b,
248 kb=@b,lb=@b,mb=@b,nb=@b,ob=@b,pb=@b,qb=@b,rb=@b,sb=@b,tb=@b,ub=@b,
249 vb=@b,wb=@b,xb=@b,yb=@b,zb=@b,
250 ac=@b,bc=@b,cc=@b,dc=@b,ec=@b,fc=@b,gc=@b,hc=@b,ic=@b,jc=@b,
251 kc=@b,lc=@b,mc=@b,nc=@b,oc=@b,pc=@b,qc=@b,rc=@b,sc=@b,tc=@b,uc=@b,
252 vc=@b,wc=@b,xc=@b,yc=@b,zc=@b;
253 CREATE INDEX t1a ON t1 (a(767),b(767));
254 CREATE INDEX t1c ON t1 (c(767),d(767));
255 CREATE INDEX t1e ON t1 (e(767),f(767));
256 CREATE INDEX t1f2 ON t1 (g(767),h(767));
257 CREATE INDEX t1f4 ON t1 (i(767),j(767));
258 CREATE INDEX t1k ON t1 (k(767),m(767));
259 CREATE INDEX t1f8 ON t1 (n(767),o(767));
260 CREATE INDEX t1f11 ON t1 (p(767),q(767));
261 CREATE INDEX t1f13 ON t1 (r(767),s(767));
262 CREATE INDEX t1f15 ON t1 (t(767),u(767));
263 CREATE INDEX t1f18 ON t1 (w(767),x(767));
264 CREATE INDEX t1f20 ON t1 (y(767),z(767));
265 CREATE INDEX ta1a6 ON t1 (aa(767),ba(767));
266 CREATE INDEX tc1c6 ON t1 (ca(767),da(767));
267 CREATE INDEX te1e6 ON t1 (ea(767),fa(767));
268 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
269 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c,
270 v=@c,w=@c,x=@c,y=@c,z=@c,
271 aa=@c,ba=@c,ca=@c,da=@c,ea=@c,fa=@c,ga=@c,ha=@c,ia=@c,ja=@c,
272 ka=@c,la=@c,ma=@c,na=@c,oa=@c,pa=@c,qa=@c,ra=@c,sa=@c,ta=@c,ua=@c,
273 va=@c,wa=@c,xa=@c,ya=@c,za=@c,
274 ab=@c,bb=@c,cb=@c,db=@c,eb=@c,fb=@c,gb=@c,hb=@c,ib=@c,jb=@c,
275 kb=@c,lb=@c,mb=@c,nb=@c,ob=@c,pb=@c,qb=@c,rb=@c,sb=@c,tb=@c,ub=@c,
276 vb=@c,wb=@c,xb=@c,yb=@c,zb=@c,
277 ac=@c,bc=@c,cc=@c,dc=@c,ec=@c,fc=@c,gc=@c,hc=@c,ic=@c,jc=@c,
278 kc=@c,lc=@c,mc=@c,nc=@c,oc=@c,pc=@c,qc=@c,rc=@c,sc=@c,tc=@c,uc=@c,
279 vc=@c,wc=@c,xc=@c,yc=@c,zc=@c;
280 COMMIT;
281 CREATE INDEX tg1f2 ON t1 (ia(767),ja(767));
282 BEGIN;
283 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d,f=@d,g=@d,h=@d,i=@d,j=@d,
284 k=@d,l=@d,m=@d,n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d,
285 v=@d,w=@d,x=@d,y=@d,z=@d,
286 aa=@d,ba=@d,ca=@d,da=@d,ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d,
287 ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d,qa=@d,ra=@d,sa=@d,ta=@d,ua=@d,
288 va=@d,wa=@d,xa=@d,ya=@d,za=@d,
289 ab=@d,bb=@d,cb=@d,db=@d,eb=@d,fb=@d,gb=@d,hb=@d,ib=@d,jb=@d,
290 kb=@d,lb=@d,mb=@d,nb=@d,ob=@d,pb=@d,qb=@d,rb=@d,sb=@d,tb=@d,ub=@d,
291 vb=@d,wb=@d,xb=@d,yb=@d,zb=@d,
292 ac=@d,bc=@d,cc=@d,dc=@d,ec=@d,fc=@d,gc=@d,hc=@d,ic=@d,jc=@d,
293 kc=@d,lc=@d,mc=@d,nc=@d,oc=@d,pc=@d,qc=@d,rc=@d,sc=@d,tc=@d,uc=@d,
294 vc=@d,wc=@d,xc=@d,yc=@d,zc=@d;
295 ROLLBACK;
296 BEGIN;
297 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
298 UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d;
299 UPDATE t1 SET k=@d,l=@d,m=@d,n=@d,o=@d;
300 UPDATE t1 SET p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
301 UPDATE t1 SET v=@d,w=@d,x=@d,y=@d,z=@d;
302 UPDATE t1 SET aa=@d,ba=@d,ca=@d,da=@d;
303 UPDATE t1 SET ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d;
304 UPDATE t1 SET ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d;
305 UPDATE t1 SET qa=@d,ra=@d,sa=@d,ta=@d,ua=@d;
306 UPDATE t1 SET va=@d,wa=@d,xa=@d,ya=@d,za=@d;
307 UPDATE t1 SET ab=@d,bb=@d,cb=@d,db=@d;
308 UPDATE t1 SET eb=@d,fb=@d,gb=@d,hb=@d,ib=@d,ja=@d;
309 UPDATE t1 SET kb=@d,lb=@d,mb=@d,nb=@d,ob=@d,pa=@d;
310 UPDATE t1 SET qb=@d,rb=@d,sb=@d,tb=@d,ub=@d;
311 UPDATE t1 SET vb=@d,wb=@d,xb=@d,yb=@d,zb=@d;
312 UPDATE t1 SET ac=@d,bc=@d,cc=@d,dc=@d;
313 UPDATE t1 SET ec=@d,fc=@d,gc=@d,hc=@d,ic=@d,jc=@d;
314 UPDATE t1 SET kc=@d,lc=@d,mc=@d,nc=@d,oc=@d,pc=@d;
315 UPDATE t1 SET qc=@d,rc=@d,sc=@d,tc=@d,uc=@d;
316 UPDATE t1 SET vc=@d,wc=@d,xc=@d,yc=@d,zc=@d;
317 COMMIT;
318 CREATE INDEX ti1f4 ON t1 (ia(767),ka(767));
319 CREATE INDEX tk1f6 ON t1 (la(767),ma(767));
320 CREATE INDEX tm1f8 ON t1 (na(767),oa(767));
321 CREATE INDEX to1f11 ON t1 (pa(767),qa(767));
322 CREATE INDEX tq1f13 ON t1 (ra(767),sa(767));
323 CREATE INDEX ts1f15 ON t1 (ta(767),ua(767));
324 CREATE INDEX tu1f18 ON t1 (wa(767),xa(767));
325 CREATE INDEX tx1f20 ON t1 (ya(767),za(767));
326 CREATE INDEX ta1a5 ON t1 (ab(767),bb(767));
327 CREATE INDEX tc1c5 ON t1 (cb(767),db(767));
328 CREATE INDEX te1e5 ON t1 (eb(767),fb(767));
329 CREATE INDEX t5g1f2 ON t1 (gb(767),hb(767));
330 CREATE INDEX t5i1f4 ON t1 (ib(767),kb(767));
331 CREATE INDEX t5k1f6 ON t1 (lb(767),mb(767));
332 CREATE INDEX t5m1f8 ON t1 (nb(767),ob(767));
333 CREATE INDEX t5o1f11 ON t1 (pb(767),qb(767));
334 CREATE INDEX t65q1f13 ON t1 (rb(767),sb(767));
335 CREATE INDEX t65s1f15 ON t1 (tb(767),ub(767));
336 CREATE INDEX t65u1f18 ON t1 (wb(767),xb(767));
337 CREATE INDEX t65x1f20 ON t1 (yb(767),zb(767));
338 CREATE INDEX xta1a5 ON t1 (ac(767),bc(767));
339 CREATE INDEX xt5g1f2 ON t1 (gc(767),hc(767));
340 CREATE INDEX xt5i1f4 ON t1 (ic(767));
341 CREATE INDEX xtc1c5 ON t1 (cc(767),dc(767));
342 CREATE INDEX xte1e5 ON t1 (ec(767),fc(767));
343 UPDATE t1 SET t=@e;
344 CREATE INDEX xt5k1f6 ON t1 (lc(767),mc(767));
345 SHOW CREATE TABLE t1;
346 Table Create Table
347 t1 CREATE TABLE `t1` (
348 `a` blob DEFAULT NULL,
349 `b` blob DEFAULT NULL,
350 `c` blob DEFAULT NULL,
351 `d` blob DEFAULT NULL,
352 `e` blob DEFAULT NULL,
353 `f` blob DEFAULT NULL,
354 `g` blob DEFAULT NULL,
355 `h` blob DEFAULT NULL,
356 `i` blob DEFAULT NULL,
357 `j` blob DEFAULT NULL,
358 `k` blob DEFAULT NULL,
359 `l` blob DEFAULT NULL,
360 `m` blob DEFAULT NULL,
361 `n` blob DEFAULT NULL,
362 `o` blob DEFAULT NULL,
363 `p` blob DEFAULT NULL,
364 `q` blob DEFAULT NULL,
365 `r` blob DEFAULT NULL,
366 `s` blob DEFAULT NULL,
367 `t` blob DEFAULT NULL,
368 `u` blob DEFAULT NULL,
369 `v` blob DEFAULT NULL,
370 `w` blob DEFAULT NULL,
371 `x` blob DEFAULT NULL,
372 `y` blob DEFAULT NULL,
373 `z` blob DEFAULT NULL,
374 `aa` blob DEFAULT NULL,
375 `ba` blob DEFAULT NULL,
376 `ca` blob DEFAULT NULL,
377 `da` blob DEFAULT NULL,
378 `ea` blob DEFAULT NULL,
379 `fa` blob DEFAULT NULL,
380 `ga` blob DEFAULT NULL,
381 `ha` blob DEFAULT NULL,
382 `ia` blob DEFAULT NULL,
383 `ja` blob DEFAULT NULL,
384 `ka` blob DEFAULT NULL,
385 `la` blob DEFAULT NULL,
386 `ma` blob DEFAULT NULL,
387 `na` blob DEFAULT NULL,
388 `oa` blob DEFAULT NULL,
389 `pa` blob DEFAULT NULL,
390 `qa` blob DEFAULT NULL,
391 `ra` blob DEFAULT NULL,
392 `sa` blob DEFAULT NULL,
393 `ta` blob DEFAULT NULL,
394 `ua` blob DEFAULT NULL,
395 `va` blob DEFAULT NULL,
396 `wa` blob DEFAULT NULL,
397 `xa` blob DEFAULT NULL,
398 `ya` blob DEFAULT NULL,
399 `za` blob DEFAULT NULL,
400 `ab` blob DEFAULT NULL,
401 `bb` blob DEFAULT NULL,
402 `cb` blob DEFAULT NULL,
403 `db` blob DEFAULT NULL,
404 `eb` blob DEFAULT NULL,
405 `fb` blob DEFAULT NULL,
406 `gb` blob DEFAULT NULL,
407 `hb` blob DEFAULT NULL,
408 `ib` blob DEFAULT NULL,
409 `jb` blob DEFAULT NULL,
410 `kb` blob DEFAULT NULL,
411 `lb` blob DEFAULT NULL,
412 `mb` blob DEFAULT NULL,
413 `nb` blob DEFAULT NULL,
414 `ob` blob DEFAULT NULL,
415 `pb` blob DEFAULT NULL,
416 `qb` blob DEFAULT NULL,
417 `rb` blob DEFAULT NULL,
418 `sb` blob DEFAULT NULL,
419 `tb` blob DEFAULT NULL,
420 `ub` blob DEFAULT NULL,
421 `vb` blob DEFAULT NULL,
422 `wb` blob DEFAULT NULL,
423 `xb` blob DEFAULT NULL,
424 `yb` blob DEFAULT NULL,
425 `zb` blob DEFAULT NULL,
426 `ac` blob DEFAULT NULL,
427 `bc` blob DEFAULT NULL,
428 `cc` blob DEFAULT NULL,
429 `dc` blob DEFAULT NULL,
430 `ec` blob DEFAULT NULL,
431 `fc` blob DEFAULT NULL,
432 `gc` blob DEFAULT NULL,
433 `hc` blob DEFAULT NULL,
434 `ic` blob DEFAULT NULL,
435 `jc` blob DEFAULT NULL,
436 `kc` blob DEFAULT NULL,
437 `lc` blob DEFAULT NULL,
438 `mc` blob DEFAULT NULL,
439 `nc` blob DEFAULT NULL,
440 `oc` blob DEFAULT NULL,
441 `pc` blob DEFAULT NULL,
442 `qc` blob DEFAULT NULL,
443 `rc` blob DEFAULT NULL,
444 `sc` blob DEFAULT NULL,
445 `tc` blob DEFAULT NULL,
446 `uc` blob DEFAULT NULL,
447 `vc` blob DEFAULT NULL,
448 `wc` blob DEFAULT NULL,
449 `xc` blob DEFAULT NULL,
450 `yc` blob DEFAULT NULL,
451 `zc` blob DEFAULT NULL,
452 KEY `t1a` (`a`(767),`b`(767)),
453 KEY `t1c` (`c`(767),`d`(767)),
454 KEY `t1e` (`e`(767),`f`(767)),
455 KEY `t1f2` (`g`(767),`h`(767)),
456 KEY `t1f4` (`i`(767),`j`(767)),
457 KEY `t1k` (`k`(767),`m`(767)),
458 KEY `t1f8` (`n`(767),`o`(767)),
459 KEY `t1f11` (`p`(767),`q`(767)),
460 KEY `t1f13` (`r`(767),`s`(767)),
461 KEY `t1f15` (`t`(767),`u`(767)),
462 KEY `t1f18` (`w`(767),`x`(767)),
463 KEY `t1f20` (`y`(767),`z`(767)),
464 KEY `ta1a6` (`aa`(767),`ba`(767)),
465 KEY `tc1c6` (`ca`(767),`da`(767)),
466 KEY `te1e6` (`ea`(767),`fa`(767)),
467 KEY `tg1f2` (`ia`(767),`ja`(767)),
468 KEY `ti1f4` (`ia`(767),`ka`(767)),
469 KEY `tk1f6` (`la`(767),`ma`(767)),
470 KEY `tm1f8` (`na`(767),`oa`(767)),
471 KEY `to1f11` (`pa`(767),`qa`(767)),
472 KEY `tq1f13` (`ra`(767),`sa`(767)),
473 KEY `ts1f15` (`ta`(767),`ua`(767)),
474 KEY `tu1f18` (`wa`(767),`xa`(767)),
475 KEY `tx1f20` (`ya`(767),`za`(767)),
476 KEY `ta1a5` (`ab`(767),`bb`(767)),
477 KEY `tc1c5` (`cb`(767),`db`(767)),
478 KEY `te1e5` (`eb`(767),`fb`(767)),
479 KEY `t5g1f2` (`gb`(767),`hb`(767)),
480 KEY `t5i1f4` (`ib`(767),`kb`(767)),
481 KEY `t5k1f6` (`lb`(767),`mb`(767)),
482 KEY `t5m1f8` (`nb`(767),`ob`(767)),
483 KEY `t5o1f11` (`pb`(767),`qb`(767)),
484 KEY `t65q1f13` (`rb`(767),`sb`(767)),
485 KEY `t65s1f15` (`tb`(767),`ub`(767)),
486 KEY `t65u1f18` (`wb`(767),`xb`(767)),
487 KEY `t65x1f20` (`yb`(767),`zb`(767)),
488 KEY `xta1a5` (`ac`(767),`bc`(767)),
489 KEY `xt5g1f2` (`gc`(767),`hc`(767)),
490 KEY `xt5i1f4` (`ic`(767)),
491 KEY `xtc1c5` (`cc`(767),`dc`(767)),
492 KEY `xte1e5` (`ec`(767),`fc`(767)),
493 KEY `xt5k1f6` (`lc`(767),`mc`(767))
494 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
495 SHOW WARNINGS;
496 Level Code Message
497 CREATE TABLE t2(COL1 TEXT,
498 COL2 TEXT,
499 COL3 TEXT,
500 COL4 TEXT,
501 COL5 TEXT,
502 COL6 TEXT,
503 COL7 TEXT,
504 COL8 TEXT,
505 COL9 TEXT,
506 COL10 TEXT,
507 COL11 TEXT,
508 COL12 TEXT,
509 COL13 TEXT,
510 COL14 TEXT,
511 COL15 TEXT,
512 COL16 TEXT,
513 COL17 TEXT,
514 COL18 TEXT,
515 COL19 TEXT,
516 COL20 TEXT,
517 COL21 TEXT,
518 COL22 TEXT,
519 COL23 TEXT,
520 COL24 TEXT,
521 COL25 TEXT,
522 COL26 TEXT,
523 COL27 TEXT,
524 COL28 TEXT,
525 COL29 TEXT,
526 COL30 TEXT,
527 COL31 TEXT,
528 COL32 TEXT,
529 COL33 TEXT,
530 COL34 TEXT,
531 COL35 TEXT,
532 COL36 TEXT,
533 COL37 TEXT,
534 COL38 TEXT,
535 COL39 TEXT,
536 COL40 TEXT,
537 COL41 TEXT,
538 COL42 TEXT,
539 COL43 TEXT,
540 COL44 TEXT,
541 COL45 TEXT,
542 COL46 TEXT,
543 COL47 TEXT,
544 COL48 TEXT,
545 COL49 TEXT,
546 COL50 TEXT,
547 COL51 TEXT,
548 COL52 TEXT,
549 COL53 TEXT,
550 COL54 TEXT,
551 COL55 TEXT,
552 COL56 TEXT,
553 COL57 TEXT,
554 COL58 TEXT,
555 COL59 TEXT,
556 COL60 TEXT,
557 COL61 TEXT,
558 COL62 TEXT,
559 COL63 TEXT,
560 COL64 TEXT,
561 COL65 TEXT,
562 COL66 TEXT,
563 COL67 TEXT,
564 COL68 TEXT,
565 COL69 TEXT,
566 COL70 TEXT,
567 COL71 TEXT,
568 COL72 TEXT,
569 COL73 TEXT,
570 COL74 TEXT,
571 COL75 TEXT,
572 COL76 TEXT,
573 COL77 TEXT,
574 COL78 TEXT,
575 COL79 TEXT,
576 COL80 TEXT,
577 COL81 TEXT,
578 COL82 TEXT,
579 COL83 TEXT,
580 COL84 TEXT,
581 COL85 TEXT,
582 COL86 TEXT,
583 COL87 TEXT,
584 COL88 TEXT,
585 COL89 TEXT,
586 COL90 TEXT,
587 COL91 TEXT,
588 COL92 TEXT,
589 COL93 TEXT,
590 COL94 TEXT,
591 COL95 TEXT,
592 COL96 TEXT,
593 COL97 TEXT,
594 COL98 TEXT,
595 COL99 TEXT,
596 COL100 TEXT,
597 COL101 TEXT,
598 COL102 TEXT,
599 COL103 TEXT,
600 COL104 TEXT,
601 COL105 TEXT,
602 COL106 TEXT,
603 COL107 TEXT,
604 COL108 TEXT,
605 COL109 TEXT,
606 COL110 TEXT,
607 COL111 TEXT,
608 COL112 TEXT,
609 COL113 TEXT,
610 COL114 TEXT,
611 COL115 TEXT,
612 COL116 TEXT,
613 COL117 TEXT,
614 COL118 TEXT,
615 COL119 TEXT,
616 COL120 TEXT,
617 COL121 TEXT,
618 COL122 TEXT,
619 COL123 TEXT,
620 COL124 TEXT,
621 COL125 TEXT,
622 COL126 TEXT,
623 COL127 TEXT,
624 COL128 TEXT,
625 COL129 TEXT,
626 COL130 TEXT,
627 COL131 TEXT,
628 COL132 TEXT,
629 COL133 TEXT,
630 COL134 TEXT,
631 COL135 TEXT,
632 COL136 TEXT,
633 COL137 TEXT,
634 COL138 TEXT,
635 COL139 TEXT,
636 COL140 TEXT,
637 COL141 TEXT,
638 COL142 TEXT,
639 COL143 TEXT,
640 COL144 TEXT,
641 COL145 TEXT,
642 COL146 TEXT,
643 COL147 TEXT,
644 COL148 TEXT,
645 COL149 TEXT,
646 COL150 TEXT,
647 COL151 TEXT,
648 COL152 TEXT,
649 COL153 TEXT,
650 COL154 TEXT,
651 COL155 TEXT,
652 COL156 TEXT,
653 COL157 TEXT,
654 COL158 TEXT,
655 COL159 TEXT,
656 COL160 TEXT,
657 COL161 TEXT,
658 COL162 TEXT,
659 COL163 TEXT,
660 COL164 TEXT,
661 COL165 TEXT,
662 COL166 TEXT,
663 COL167 TEXT,
664 COL168 TEXT,
665 COL169 TEXT,
666 COL170 TEXT,
667 COL171 TEXT,
668 COL172 TEXT,
669 COL173 TEXT,
670 COL174 TEXT,
671 COL175 TEXT,
672 COL176 TEXT,
673 COL177 TEXT,
674 COL178 TEXT,
675 COL179 TEXT,
676 COL180 TEXT,
677 COL181 TEXT,
678 COL182 TEXT,
679 COL183 TEXT,
680 COL184 TEXT,
681 COL185 TEXT,
682 COL186 TEXT,
683 COL187 TEXT,
684 COL188 TEXT,
685 COL189 TEXT,
686 COL190 TEXT,
687 COL191 TEXT,
688 COL192 TEXT,
689 COL193 TEXT,
690 COL194 TEXT,
691 COL195 TEXT,
692 COL196 TEXT,
693 COL197 TEXT)
694 row_format=dynamic,ENGINE=INNODB;
695 set @a = repeat('0123456789', 800);
696 set @b = repeat('9876543210', 800);
697 insert into t2 values(
698 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
699 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
700 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
701 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
702 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
703 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
704 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
705 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
706 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
707 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
708 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
709 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
710 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
711 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
712 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
713 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
714 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
715 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
716 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
717 @a,@a,@a,@a,@a,@a,@a);
718 update t2 set col190=@b;
719 set @a = repeat('0123456789', 1650);
720 set @b = repeat('9876543210', 2000);
721 insert into t2 values(
722 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
723 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
724 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
725 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
726 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
727 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
728 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
729 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
730 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
731 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
732 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
733 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
734 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
735 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
736 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
737 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
738 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
739 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
740 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
741 @a,@a,@a,@a,@a,@a,@a);
742 update t2 set col190=@b;
743 # restart
744 set @a = repeat('abcdefghijklmnopqrstuvwxyz', 1650);
745 set @b = repeat('zyxwvutsrqponmlkjihgfedcba', 2000);
746 update t2 set col189 = @b;
747 insert into t2 select * from t2;
748 show create table t1;
749 Table Create Table
750 t1 CREATE TABLE `t1` (
751 `a` blob DEFAULT NULL,
752 `b` blob DEFAULT NULL,
753 `c` blob DEFAULT NULL,
754 `d` blob DEFAULT NULL,
755 `e` blob DEFAULT NULL,
756 `f` blob DEFAULT NULL,
757 `g` blob DEFAULT NULL,
758 `h` blob DEFAULT NULL,
759 `i` blob DEFAULT NULL,
760 `j` blob DEFAULT NULL,
761 `k` blob DEFAULT NULL,
762 `l` blob DEFAULT NULL,
763 `m` blob DEFAULT NULL,
764 `n` blob DEFAULT NULL,
765 `o` blob DEFAULT NULL,
766 `p` blob DEFAULT NULL,
767 `q` blob DEFAULT NULL,
768 `r` blob DEFAULT NULL,
769 `s` blob DEFAULT NULL,
770 `t` blob DEFAULT NULL,
771 `u` blob DEFAULT NULL,
772 `v` blob DEFAULT NULL,
773 `w` blob DEFAULT NULL,
774 `x` blob DEFAULT NULL,
775 `y` blob DEFAULT NULL,
776 `z` blob DEFAULT NULL,
777 `aa` blob DEFAULT NULL,
778 `ba` blob DEFAULT NULL,
779 `ca` blob DEFAULT NULL,
780 `da` blob DEFAULT NULL,
781 `ea` blob DEFAULT NULL,
782 `fa` blob DEFAULT NULL,
783 `ga` blob DEFAULT NULL,
784 `ha` blob DEFAULT NULL,
785 `ia` blob DEFAULT NULL,
786 `ja` blob DEFAULT NULL,
787 `ka` blob DEFAULT NULL,
788 `la` blob DEFAULT NULL,
789 `ma` blob DEFAULT NULL,
790 `na` blob DEFAULT NULL,
791 `oa` blob DEFAULT NULL,
792 `pa` blob DEFAULT NULL,
793 `qa` blob DEFAULT NULL,
794 `ra` blob DEFAULT NULL,
795 `sa` blob DEFAULT NULL,
796 `ta` blob DEFAULT NULL,
797 `ua` blob DEFAULT NULL,
798 `va` blob DEFAULT NULL,
799 `wa` blob DEFAULT NULL,
800 `xa` blob DEFAULT NULL,
801 `ya` blob DEFAULT NULL,
802 `za` blob DEFAULT NULL,
803 `ab` blob DEFAULT NULL,
804 `bb` blob DEFAULT NULL,
805 `cb` blob DEFAULT NULL,
806 `db` blob DEFAULT NULL,
807 `eb` blob DEFAULT NULL,
808 `fb` blob DEFAULT NULL,
809 `gb` blob DEFAULT NULL,
810 `hb` blob DEFAULT NULL,
811 `ib` blob DEFAULT NULL,
812 `jb` blob DEFAULT NULL,
813 `kb` blob DEFAULT NULL,
814 `lb` blob DEFAULT NULL,
815 `mb` blob DEFAULT NULL,
816 `nb` blob DEFAULT NULL,
817 `ob` blob DEFAULT NULL,
818 `pb` blob DEFAULT NULL,
819 `qb` blob DEFAULT NULL,
820 `rb` blob DEFAULT NULL,
821 `sb` blob DEFAULT NULL,
822 `tb` blob DEFAULT NULL,
823 `ub` blob DEFAULT NULL,
824 `vb` blob DEFAULT NULL,
825 `wb` blob DEFAULT NULL,
826 `xb` blob DEFAULT NULL,
827 `yb` blob DEFAULT NULL,
828 `zb` blob DEFAULT NULL,
829 `ac` blob DEFAULT NULL,
830 `bc` blob DEFAULT NULL,
831 `cc` blob DEFAULT NULL,
832 `dc` blob DEFAULT NULL,
833 `ec` blob DEFAULT NULL,
834 `fc` blob DEFAULT NULL,
835 `gc` blob DEFAULT NULL,
836 `hc` blob DEFAULT NULL,
837 `ic` blob DEFAULT NULL,
838 `jc` blob DEFAULT NULL,
839 `kc` blob DEFAULT NULL,
840 `lc` blob DEFAULT NULL,
841 `mc` blob DEFAULT NULL,
842 `nc` blob DEFAULT NULL,
843 `oc` blob DEFAULT NULL,
844 `pc` blob DEFAULT NULL,
845 `qc` blob DEFAULT NULL,
846 `rc` blob DEFAULT NULL,
847 `sc` blob DEFAULT NULL,
848 `tc` blob DEFAULT NULL,
849 `uc` blob DEFAULT NULL,
850 `vc` blob DEFAULT NULL,
851 `wc` blob DEFAULT NULL,
852 `xc` blob DEFAULT NULL,
853 `yc` blob DEFAULT NULL,
854 `zc` blob DEFAULT NULL,
855 KEY `t1a` (`a`(767),`b`(767)),
856 KEY `t1c` (`c`(767),`d`(767)),
857 KEY `t1e` (`e`(767),`f`(767)),
858 KEY `t1f2` (`g`(767),`h`(767)),
859 KEY `t1f4` (`i`(767),`j`(767)),
860 KEY `t1k` (`k`(767),`m`(767)),
861 KEY `t1f8` (`n`(767),`o`(767)),
862 KEY `t1f11` (`p`(767),`q`(767)),
863 KEY `t1f13` (`r`(767),`s`(767)),
864 KEY `t1f15` (`t`(767),`u`(767)),
865 KEY `t1f18` (`w`(767),`x`(767)),
866 KEY `t1f20` (`y`(767),`z`(767)),
867 KEY `ta1a6` (`aa`(767),`ba`(767)),
868 KEY `tc1c6` (`ca`(767),`da`(767)),
869 KEY `te1e6` (`ea`(767),`fa`(767)),
870 KEY `tg1f2` (`ia`(767),`ja`(767)),
871 KEY `ti1f4` (`ia`(767),`ka`(767)),
872 KEY `tk1f6` (`la`(767),`ma`(767)),
873 KEY `tm1f8` (`na`(767),`oa`(767)),
874 KEY `to1f11` (`pa`(767),`qa`(767)),
875 KEY `tq1f13` (`ra`(767),`sa`(767)),
876 KEY `ts1f15` (`ta`(767),`ua`(767)),
877 KEY `tu1f18` (`wa`(767),`xa`(767)),
878 KEY `tx1f20` (`ya`(767),`za`(767)),
879 KEY `ta1a5` (`ab`(767),`bb`(767)),
880 KEY `tc1c5` (`cb`(767),`db`(767)),
881 KEY `te1e5` (`eb`(767),`fb`(767)),
882 KEY `t5g1f2` (`gb`(767),`hb`(767)),
883 KEY `t5i1f4` (`ib`(767),`kb`(767)),
884 KEY `t5k1f6` (`lb`(767),`mb`(767)),
885 KEY `t5m1f8` (`nb`(767),`ob`(767)),
886 KEY `t5o1f11` (`pb`(767),`qb`(767)),
887 KEY `t65q1f13` (`rb`(767),`sb`(767)),
888 KEY `t65s1f15` (`tb`(767),`ub`(767)),
889 KEY `t65u1f18` (`wb`(767),`xb`(767)),
890 KEY `t65x1f20` (`yb`(767),`zb`(767)),
891 KEY `xta1a5` (`ac`(767),`bc`(767)),
892 KEY `xt5g1f2` (`gc`(767),`hc`(767)),
893 KEY `xt5i1f4` (`ic`(767)),
894 KEY `xtc1c5` (`cc`(767),`dc`(767)),
895 KEY `xte1e5` (`ec`(767),`fc`(767)),
896 KEY `xt5k1f6` (`lc`(767),`mc`(767))
897 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
898 show create table t2;
899 Table Create Table
900 t2 CREATE TABLE `t2` (
901 `COL1` text DEFAULT NULL,
902 `COL2` text DEFAULT NULL,
903 `COL3` text DEFAULT NULL,
904 `COL4` text DEFAULT NULL,
905 `COL5` text DEFAULT NULL,
906 `COL6` text DEFAULT NULL,
907 `COL7` text DEFAULT NULL,
908 `COL8` text DEFAULT NULL,
909 `COL9` text DEFAULT NULL,
910 `COL10` text DEFAULT NULL,
911 `COL11` text DEFAULT NULL,
912 `COL12` text DEFAULT NULL,
913 `COL13` text DEFAULT NULL,
914 `COL14` text DEFAULT NULL,
915 `COL15` text DEFAULT NULL,
916 `COL16` text DEFAULT NULL,
917 `COL17` text DEFAULT NULL,
918 `COL18` text DEFAULT NULL,
919 `COL19` text DEFAULT NULL,
920 `COL20` text DEFAULT NULL,
921 `COL21` text DEFAULT NULL,
922 `COL22` text DEFAULT NULL,
923 `COL23` text DEFAULT NULL,
924 `COL24` text DEFAULT NULL,
925 `COL25` text DEFAULT NULL,
926 `COL26` text DEFAULT NULL,
927 `COL27` text DEFAULT NULL,
928 `COL28` text DEFAULT NULL,
929 `COL29` text DEFAULT NULL,
930 `COL30` text DEFAULT NULL,
931 `COL31` text DEFAULT NULL,
932 `COL32` text DEFAULT NULL,
933 `COL33` text DEFAULT NULL,
934 `COL34` text DEFAULT NULL,
935 `COL35` text DEFAULT NULL,
936 `COL36` text DEFAULT NULL,
937 `COL37` text DEFAULT NULL,
938 `COL38` text DEFAULT NULL,
939 `COL39` text DEFAULT NULL,
940 `COL40` text DEFAULT NULL,
941 `COL41` text DEFAULT NULL,
942 `COL42` text DEFAULT NULL,
943 `COL43` text DEFAULT NULL,
944 `COL44` text DEFAULT NULL,
945 `COL45` text DEFAULT NULL,
946 `COL46` text DEFAULT NULL,
947 `COL47` text DEFAULT NULL,
948 `COL48` text DEFAULT NULL,
949 `COL49` text DEFAULT NULL,
950 `COL50` text DEFAULT NULL,
951 `COL51` text DEFAULT NULL,
952 `COL52` text DEFAULT NULL,
953 `COL53` text DEFAULT NULL,
954 `COL54` text DEFAULT NULL,
955 `COL55` text DEFAULT NULL,
956 `COL56` text DEFAULT NULL,
957 `COL57` text DEFAULT NULL,
958 `COL58` text DEFAULT NULL,
959 `COL59` text DEFAULT NULL,
960 `COL60` text DEFAULT NULL,
961 `COL61` text DEFAULT NULL,
962 `COL62` text DEFAULT NULL,
963 `COL63` text DEFAULT NULL,
964 `COL64` text DEFAULT NULL,
965 `COL65` text DEFAULT NULL,
966 `COL66` text DEFAULT NULL,
967 `COL67` text DEFAULT NULL,
968 `COL68` text DEFAULT NULL,
969 `COL69` text DEFAULT NULL,
970 `COL70` text DEFAULT NULL,
971 `COL71` text DEFAULT NULL,
972 `COL72` text DEFAULT NULL,
973 `COL73` text DEFAULT NULL,
974 `COL74` text DEFAULT NULL,
975 `COL75` text DEFAULT NULL,
976 `COL76` text DEFAULT NULL,
977 `COL77` text DEFAULT NULL,
978 `COL78` text DEFAULT NULL,
979 `COL79` text DEFAULT NULL,
980 `COL80` text DEFAULT NULL,
981 `COL81` text DEFAULT NULL,
982 `COL82` text DEFAULT NULL,
983 `COL83` text DEFAULT NULL,
984 `COL84` text DEFAULT NULL,
985 `COL85` text DEFAULT NULL,
986 `COL86` text DEFAULT NULL,
987 `COL87` text DEFAULT NULL,
988 `COL88` text DEFAULT NULL,
989 `COL89` text DEFAULT NULL,
990 `COL90` text DEFAULT NULL,
991 `COL91` text DEFAULT NULL,
992 `COL92` text DEFAULT NULL,
993 `COL93` text DEFAULT NULL,
994 `COL94` text DEFAULT NULL,
995 `COL95` text DEFAULT NULL,
996 `COL96` text DEFAULT NULL,
997 `COL97` text DEFAULT NULL,
998 `COL98` text DEFAULT NULL,
999 `COL99` text DEFAULT NULL,
1000 `COL100` text DEFAULT NULL,
1001 `COL101` text DEFAULT NULL,
1002 `COL102` text DEFAULT NULL,
1003 `COL103` text DEFAULT NULL,
1004 `COL104` text DEFAULT NULL,
1005 `COL105` text DEFAULT NULL,
1006 `COL106` text DEFAULT NULL,
1007 `COL107` text DEFAULT NULL,
1008 `COL108` text DEFAULT NULL,
1009 `COL109` text DEFAULT NULL,
1010 `COL110` text DEFAULT NULL,
1011 `COL111` text DEFAULT NULL,
1012 `COL112` text DEFAULT NULL,
1013 `COL113` text DEFAULT NULL,
1014 `COL114` text DEFAULT NULL,
1015 `COL115` text DEFAULT NULL,
1016 `COL116` text DEFAULT NULL,
1017 `COL117` text DEFAULT NULL,
1018 `COL118` text DEFAULT NULL,
1019 `COL119` text DEFAULT NULL,
1020 `COL120` text DEFAULT NULL,
1021 `COL121` text DEFAULT NULL,
1022 `COL122` text DEFAULT NULL,
1023 `COL123` text DEFAULT NULL,
1024 `COL124` text DEFAULT NULL,
1025 `COL125` text DEFAULT NULL,
1026 `COL126` text DEFAULT NULL,
1027 `COL127` text DEFAULT NULL,
1028 `COL128` text DEFAULT NULL,
1029 `COL129` text DEFAULT NULL,
1030 `COL130` text DEFAULT NULL,
1031 `COL131` text DEFAULT NULL,
1032 `COL132` text DEFAULT NULL,
1033 `COL133` text DEFAULT NULL,
1034 `COL134` text DEFAULT NULL,
1035 `COL135` text DEFAULT NULL,
1036 `COL136` text DEFAULT NULL,
1037 `COL137` text DEFAULT NULL,
1038 `COL138` text DEFAULT NULL,
1039 `COL139` text DEFAULT NULL,
1040 `COL140` text DEFAULT NULL,
1041 `COL141` text DEFAULT NULL,
1042 `COL142` text DEFAULT NULL,
1043 `COL143` text DEFAULT NULL,
1044 `COL144` text DEFAULT NULL,
1045 `COL145` text DEFAULT NULL,
1046 `COL146` text DEFAULT NULL,
1047 `COL147` text DEFAULT NULL,
1048 `COL148` text DEFAULT NULL,
1049 `COL149` text DEFAULT NULL,
1050 `COL150` text DEFAULT NULL,
1051 `COL151` text DEFAULT NULL,
1052 `COL152` text DEFAULT NULL,
1053 `COL153` text DEFAULT NULL,
1054 `COL154` text DEFAULT NULL,
1055 `COL155` text DEFAULT NULL,
1056 `COL156` text DEFAULT NULL,
1057 `COL157` text DEFAULT NULL,
1058 `COL158` text DEFAULT NULL,
1059 `COL159` text DEFAULT NULL,
1060 `COL160` text DEFAULT NULL,
1061 `COL161` text DEFAULT NULL,
1062 `COL162` text DEFAULT NULL,
1063 `COL163` text DEFAULT NULL,
1064 `COL164` text DEFAULT NULL,
1065 `COL165` text DEFAULT NULL,
1066 `COL166` text DEFAULT NULL,
1067 `COL167` text DEFAULT NULL,
1068 `COL168` text DEFAULT NULL,
1069 `COL169` text DEFAULT NULL,
1070 `COL170` text DEFAULT NULL,
1071 `COL171` text DEFAULT NULL,
1072 `COL172` text DEFAULT NULL,
1073 `COL173` text DEFAULT NULL,
1074 `COL174` text DEFAULT NULL,
1075 `COL175` text DEFAULT NULL,
1076 `COL176` text DEFAULT NULL,
1077 `COL177` text DEFAULT NULL,
1078 `COL178` text DEFAULT NULL,
1079 `COL179` text DEFAULT NULL,
1080 `COL180` text DEFAULT NULL,
1081 `COL181` text DEFAULT NULL,
1082 `COL182` text DEFAULT NULL,
1083 `COL183` text DEFAULT NULL,
1084 `COL184` text DEFAULT NULL,
1085 `COL185` text DEFAULT NULL,
1086 `COL186` text DEFAULT NULL,
1087 `COL187` text DEFAULT NULL,
1088 `COL188` text DEFAULT NULL,
1089 `COL189` text DEFAULT NULL,
1090 `COL190` text DEFAULT NULL,
1091 `COL191` text DEFAULT NULL,
1092 `COL192` text DEFAULT NULL,
1093 `COL193` text DEFAULT NULL,
1094 `COL194` text DEFAULT NULL,
1095 `COL195` text DEFAULT NULL,
1096 `COL196` text DEFAULT NULL,
1097 `COL197` text DEFAULT NULL
1098 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
1099 BEGIN;
1100 update t2 set col150=@a;
1101 update t2 set col145=@b;
1102 COMMIT;
1103 drop table t2;
1104 DROP TABLE t1;
1105 #
1106 # MDEV-19526/MDEV-29742 heap number overflow
1107 #
1108 CREATE TABLE t1(a SMALLINT NOT NULL UNIQUE AUTO_INCREMENT, KEY(a))
1109 ENGINE=InnoDB;
1110 INSERT INTO t1 (a) SELECT seq FROM seq_1_to_8191;
1111 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
1112 DROP TABLE t1;
1113 # End of 10.3 tests
1114 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;