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