Debian Codegraph @

mysql-test/suite/innodb/t/innodb-64k-crash.test

raw
1 --source include/have_innodb.inc
2 --source include/have_innodb_64k.inc
3 # Embedded server does not support restarting
4 --source include/not_embedded.inc
5 --source innodb_default_row_format.inc
6
7 let $MYSQLD_DATADIR= `select @@datadir`;
8
9 CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
10 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
11 o blob,p blob,q blob,r blob,s blob,t blob,u blob,
12 v blob, w blob, x blob, y blob, z blob,
13 aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob,
14 ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob,
15 oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob,
16 va blob, wa blob, xa blob, ya blob, za blob,
17 ab blob,bb blob,cb blob,db blob,eb blob,fb blob,gb blob,
18 hb blob,ib blob,jb blob,kb blob,lb blob,mb blob,nb blob,
19 ob blob,pb blob,qb blob,rb blob,sb blob,tb blob,ub blob,
20 vb blob, wb blob, xb blob, yb blob, zb blob,
21 ac blob, bc blob, cc blob, dc blob, ec blob,fc blob,gc blob,
22 hc blob, ic blob, jc blob, kc blob, lc blob,mc blob,nc blob,
23 oc blob, pc blob, qc blob, rc blob, sc blob,tc blob,uc blob,
24 vc blob, wc blob, xc blob, yc blob, zc blob
25 ) ENGINE=InnoDB ROW_FORMAT=dynamic;
26
27 SET innodb_strict_mode=OFF;
28 CREATE TABLE t2(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
29 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
30 o blob,p blob,q blob,r blob,s blob,t blob,u blob,
31 v blob, w blob, x blob, y blob, z blob,
32 aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob,
33 ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob,
34 oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob,
35 va blob, wa blob, xa blob, ya blob, za blob,
36 ab blob,bb blob,cb blob,db blob,eb blob,fb blob,gb blob,
37 hb blob,ib blob,jb blob,kb blob,lb blob,mb blob,nb blob,
38 ob blob,pb blob,qb blob,rb blob,sb blob,tb blob,ub blob,
39 vb blob, wb blob, xb blob, yb blob, zb blob,
40 ac blob, bc blob, cc blob, dc blob, ec blob,fc blob,gc blob,
41 hc blob, ic blob, jc blob, kc blob, lc blob,mc blob,nc blob,
42 oc blob, pc blob, qc blob, rc blob, sc blob,tc blob,uc blob,
43 vc blob, wc blob, xc blob, yc blob, zc blob
44 ) ENGINE=InnoDB ROW_FORMAT=compact;
45 SET innodb_strict_mode=ON;
46
47 SET @a = repeat('a', 767);
48 SET @b = repeat('b', 767);
49 SET @c = repeat('c', 767);
50 SET @d = repeat('d', 767);
51 SET @e = repeat('e', 767);
52 SET @f = repeat('f', 767);
53 SET @f = repeat('g', 767);
54
55 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,
56 @a,@a,@a,@a,@a,@a,@a,
57 @a,@a,@a,@a,@a,@a,@a,
58 @a,@a,@a,@a,@a,
59 @a,@a,@a,@a,@a,@a,@a,
60 @a,@a,@a,@a,@a,@a,@a,
61 @a,@a,@a,@a,@a,@a,@a,
62 @a,@a,@a,@a,@a,
63 @a,@a,@a,@a,@a,@a,@a,
64 @a,@a,@a,@a,@a,@a,@a,
65 @a,@a,@a,@a,@a,@a,@a,
66 @a,@a,@a,@a,@a,
67 @a,@a,@a,@a,@a,@a,@a,
68 @a,@a,@a,@a,@a,@a,@a,
69 @a,@a,@a,@a,@a,@a,@a,
70 @a,@a,@a,@a,@a
71 );
72
73 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,
74 @a,@a,@a,@a,@a,@a,@a,
75 @a,@a,@a,@a,@a,@a,@a,
76 @a,@a,@a,@a,@a,
77 @a,@a,@a,@a,@a,@a,@a,
78 @a,@a,@a,@a,@a,@a,@a,
79 @a,@a,@a,@a,@a,@a,@a,
80 @a,@a,@a,@a,@a,
81 @a,@a,@a,@a,@a,@a,@a,
82 @a,@a,@a,@a,@a,@a,@a,
83 @a,@a,@a,@a,@a,@a,@a,
84 @a,@a,@a,@a,@a,
85 @a,@a,@a,@a,@a,@a,@a,
86 @a,@a,@a,@a,@a,@a,@a,
87 @a,@a,@a,@a,@a,@a,@a,
88 @a,@a,@a,@a,@a
89 );
90
91 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,
92 @a,@a,@a,@a,@a,@a,@a,
93 @a,@a,@a,@a,@a,@a,@a,
94 @a,@a,@a,@a,@a,
95 @a,@a,@a,@a,@a,@a,@a,
96 @a,@a,@a,@a,@a,@a,@a,
97 @a,@a,@a,@a,@a,@a,@a,
98 @a,@a,@a,@a,@a,
99 @a,@a,@a,@a,@a,@a,@a,
100 @a,@a,@a,@a,@a,@a,@a,
101 @a,@a,@a,@a,@a,@a,@a,
102 @a,@a,@a,@a,@a,
103 @a,@a,@a,@a,@a,@a,@a,
104 @a,@a,@a,@a,@a,@a,@a,
105 @a,@a,@a,@a,@a,@a,@a,
106 @a,@a,@a,@a,@a
107 );
108
109 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,
110 @a,@a,@a,@a,@a,@a,@a,
111 @a,@a,@a,@a,@a,@a,@a,
112 @a,@a,@a,@a,@a,
113 @a,@a,@a,@a,@a,@a,@a,
114 @a,@a,@a,@a,@a,@a,@a,
115 @a,@a,@a,@a,@a,@a,@a,
116 @a,@a,@a,@a,@a,
117 @a,@a,@a,@a,@a,@a,@a,
118 @a,@a,@a,@a,@a,@a,@a,
119 @a,@a,@a,@a,@a,@a,@a,
120 @a,@a,@a,@a,@a,
121 @a,@a,@a,@a,@a,@a,@a,
122 @a,@a,@a,@a,@a,@a,@a,
123 @a,@a,@a,@a,@a,@a,@a,
124 @a,@a,@a,@a,@a
125 );
126
127 SET @h = repeat('h', 100);
128 SET @i = repeat('i', 100);
129 SET @j = repeat('j', 100);
130 SET @k = repeat('k', 100);
131 SET @l = repeat('l', 100);
132
133 INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,
134 @h,@h,@h,@h,@h,@h,@h,
135 @h,@h,@h,@h,@h,@h,@h,
136 @h,@h,@h,@h,@h,
137 @h,@h,@h,@h,@h,@h,@h,
138 @h,@h,@h,@h,@h,@h,@h,
139 @h,@h,@h,@h,@h,@h,@h,
140 @h,@h,@h,@h,@h,
141 @h,@h,@h,@h,@h,@h,@h,
142 @h,@h,@h,@h,@h,@h,@h,
143 @h,@h,@h,@h,@h,@h,@h,
144 @h,@h,@h,@h,@h,
145 @h,@h,@h,@h,@h,@h,@h,
146 @h,@h,@h,@h,@h,@h,@h,
147 @h,@h,@h,@h,@h,@h,@h,
148 @h,@h,@h,@h,@h
149 );
150
151 UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
152 k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b,
153 v=@b,w=@b,x=@b,y=@b,z=@b,
154 aa=@b,ba=@b,ca=@b,da=@b,ea=@b,fa=@b,ga=@b,ha=@b,ia=@b,ja=@b,
155 ka=@b,la=@b,ma=@b,na=@b,oa=@b,pa=@b,qa=@b,ra=@b,sa=@b,ta=@b,ua=@b,
156 va=@b,wa=@b,xa=@b,ya=@b,za=@b,
157 ab=@b,bb=@b,cb=@b,db=@b,eb=@b,fb=@b,gb=@b,hb=@b,ib=@b,jb=@b,
158 kb=@b,lb=@b,mb=@b,nb=@b,ob=@b,pb=@b,qb=@b,rb=@b,sb=@b,tb=@b,ub=@b,
159 vb=@b,wb=@b,xb=@b,yb=@b,zb=@b,
160 ab=@b,bb=@b,cb=@b,db=@b,eb=@b,fb=@b,gb=@b,hb=@b,ib=@b,jb=@b,
161 kb=@b,lb=@b,mb=@b,nb=@b,ob=@b,pb=@b,qb=@b,rb=@b,sb=@b,tb=@b,ub=@b,
162 vb=@b,wb=@b,xb=@b,yb=@b,zb=@b,
163 ac=@b,bc=@b,cc=@b,dc=@b,ec=@b,fc=@b,gc=@b,hc=@b,ic=@b,jc=@b,
164 kc=@b,lc=@b,mc=@b,nc=@b,oc=@b,pc=@b,qc=@b,rc=@b,sc=@b,tc=@b,uc=@b,
165 vc=@b,wc=@b,xc=@b,yc=@b,zc=@b;
166
167 UPDATE t2 SET a=@i,b=@i,c=@i,d=@i,e=@i,f=@i,g=@i,h=@i,i=@i,j=@i,
168 k=@i,l=@i,m=@i,n=@i,o=@i,p=@i,q=@i,r=@i,s=@i,t=@i,u=@i,
169 v=@i,w=@i,x=@i,y=@i,z=@i,
170 aa=@i,ba=@i,ca=@i,da=@i,ea=@i,fa=@i,ga=@i,ha=@i,ia=@i,ja=@i,
171 ka=@i,la=@i,ma=@i,na=@i,oa=@i,pa=@i,qa=@i,ra=@i,sa=@i,ta=@i,ua=@i,
172 va=@i,wa=@i,xa=@i,ya=@i,za=@i,
173 ab=@i,bb=@i,cb=@i,db=@i,eb=@i,fb=@i,gb=@i,hb=@i,ib=@i,jb=@i,
174 kb=@i,lb=@i,mb=@i,nb=@i,ob=@i,pb=@i,qb=@i,rb=@i,sb=@i,tb=@i,ub=@i,
175 vb=@i,wb=@i,xb=@i,yb=@i,zb=@i,
176 ab=@i,bb=@i,cb=@i,db=@i,eb=@i,fb=@i,gb=@i,hb=@i,ib=@i,jb=@i,
177 kb=@i,lb=@i,mb=@i,nb=@i,ob=@i,pb=@i,qb=@i,rb=@i,sb=@i,tb=@i,ub=@i,
178 vb=@i,wb=@i,xb=@i,yb=@i,zb=@i,
179 ac=@i,bc=@i,cc=@i,dc=@i,ec=@i,fc=@i,gc=@i,hc=@i,ic=@i,jc=@i,
180 kc=@i,lc=@i,mc=@i,nc=@i,oc=@i,pc=@i,qc=@i,rc=@i,sc=@i,tc=@i,uc=@i,
181 vc=@i,wc=@i,xc=@i,yc=@i,zc=@i;
182
183 # With this many indexes defined, we can still update all fields.
184 CREATE INDEX t1a ON t1 (a(767),b(767));
185 CREATE INDEX t1c ON t1 (c(767),d(767));
186 CREATE INDEX t1e ON t1 (e(767),f(767));
187 CREATE INDEX t1f2 ON t1 (g(767),h(767));
188 CREATE INDEX t1f4 ON t1 (i(767),j(767));
189 CREATE INDEX t1k ON t1 (k(767),m(767));
190 CREATE INDEX t1f8 ON t1 (n(767),o(767));
191 CREATE INDEX t1f11 ON t1 (p(767),q(767));
192 CREATE INDEX t1f13 ON t1 (r(767),s(767));
193 CREATE INDEX t1f15 ON t1 (t(767),u(767));
194 CREATE INDEX t1f18 ON t1 (w(767),x(767));
195 CREATE INDEX t1f20 ON t1 (y(767),z(767));
196 CREATE INDEX ta1a6 ON t1 (aa(767),ba(767));
197 CREATE INDEX tc1c6 ON t1 (ca(767),da(767));
198 CREATE INDEX te1e6 ON t1 (ea(767),fa(767));
199
200
201 CREATE INDEX t2a ON t2 (a(767),b(767));
202 CREATE INDEX t2c ON t2 (c(767),d(767));
203 CREATE INDEX t2e ON t2 (e(767),f(767));
204 CREATE INDEX t2f2 ON t2 (g(767),h(767));
205 CREATE INDEX t2f4 ON t2 (i(767),j(767));
206 CREATE INDEX t2k ON t2 (k(767),m(767));
207 CREATE INDEX t2f8 ON t2 (n(767),o(767));
208 CREATE INDEX t2f11 ON t2 (p(767),q(767));
209 CREATE INDEX t2f13 ON t2 (r(767),s(767));
210 CREATE INDEX t2f15 ON t2 (t(767),u(767));
211 CREATE INDEX t2f18 ON t2 (w(767),x(767));
212 CREATE INDEX t2f20 ON t2 (y(767),z(767));
213 CREATE INDEX ta2a6 ON t2 (aa(767),ba(767));
214 CREATE INDEX tc2c6 ON t2 (ca(767),da(767));
215 CREATE INDEX te2e6 ON t2 (ea(767),fa(767));
216
217 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
218 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c,
219 v=@c,w=@c,x=@c,y=@c,z=@c,
220 aa=@c,ba=@c,ca=@c,da=@c,ea=@c,fa=@c,ga=@c,ha=@c,ia=@c,ja=@c,
221 ka=@c,la=@c,ma=@c,na=@c,oa=@c,pa=@c,qa=@c,ra=@c,sa=@c,ta=@c,ua=@c,
222 va=@c,wa=@c,xa=@c,ya=@c,za=@c,
223 ab=@c,bb=@c,cb=@c,db=@c,eb=@c,fb=@c,gb=@c,hb=@c,ib=@c,jb=@c,
224 kb=@c,lb=@c,mb=@c,nb=@c,ob=@c,pb=@c,qb=@c,rb=@c,sb=@c,tb=@c,ub=@c,
225 vb=@c,wb=@c,xb=@c,yb=@c,zb=@c,
226 ac=@c,bc=@c,cc=@c,dc=@c,ec=@c,fc=@c,gc=@c,hc=@c,ic=@c,jc=@c,
227 kc=@c,lc=@c,mc=@c,nc=@c,oc=@c,pc=@c,qc=@c,rc=@c,sc=@c,tc=@c,uc=@c,
228 vc=@c,wc=@c,xc=@c,yc=@c,zc=@c;
229
230 UPDATE t2 SET a=@k,b=@k,c=@k,d=@k,e=@k,f=@k,g=@k,h=@k,i=@k,j=@k,
231 k=@k,l=@k,m=@k,n=@k,o=@k,p=@k,q=@k,r=@k,s=@k,t=@k,u=@k,
232 v=@k,w=@k,x=@k,y=@k,z=@k,
233 aa=@k,ba=@k,ca=@k,da=@k,ea=@k,fa=@k,ga=@k,ha=@k,ia=@k,ja=@k,
234 ka=@k,la=@k,ma=@k,na=@k,oa=@k,pa=@k,qa=@k,ra=@k,sa=@k,ta=@k,ua=@k,
235 va=@k,wa=@k,xa=@k,ya=@k,za=@k,
236 ab=@k,bb=@k,cb=@k,db=@k,eb=@k,fb=@k,gb=@k,hb=@k,ib=@k,jb=@k,
237 kb=@k,lb=@k,mb=@k,nb=@k,ob=@k,pb=@k,qb=@k,rb=@k,sb=@k,tb=@k,ub=@k,
238 vb=@k,wb=@k,xb=@k,yb=@k,zb=@k,
239 ac=@k,bc=@k,cc=@k,dc=@k,ec=@k,fc=@k,gc=@k,hc=@k,ic=@k,jc=@k,
240 kc=@k,lc=@k,mc=@k,nc=@k,oc=@k,pc=@k,qc=@k,rc=@k,sc=@k,tc=@k,uc=@k,
241 vc=@k,wc=@k,xc=@k,yc=@k,zc=@k;
242
243 COMMIT;
244
245 BEGIN;
246 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
247 UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d;
248 UPDATE t1 SET k=@d,l=@d,m=@d,n=@d,o=@d;
249 UPDATE t1 SET p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
250 UPDATE t1 SET v=@d,w=@d,x=@d,y=@d,z=@d;
251 UPDATE t1 SET aa=@d,ba=@d,ca=@d,da=@d;
252 UPDATE t1 SET ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d;
253 UPDATE t1 SET ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d;
254 UPDATE t1 SET qa=@d,ra=@d,sa=@d,ta=@d,ua=@d;
255 UPDATE t1 SET va=@d,wa=@d,xa=@d,ya=@d,za=@d;
256 UPDATE t1 SET ab=@d,bb=@d,cb=@d,db=@d;
257 UPDATE t1 SET eb=@d,fb=@d,gb=@d,hb=@d,ib=@d,ja=@d;
258 UPDATE t1 SET kb=@d,lb=@d,mb=@d,nb=@d,ob=@d,pa=@d;
259 UPDATE t1 SET qb=@d,rb=@d,sb=@d,tb=@d,ub=@d;
260 UPDATE t1 SET vb=@d,wb=@d,xb=@d,yb=@d,zb=@d;
261 UPDATE t1 SET ac=@d,bc=@d,cc=@d,dc=@d;
262 UPDATE t1 SET ec=@d,fc=@d,gc=@d,hc=@d,ic=@d,jc=@d;
263 UPDATE t1 SET kc=@d,lc=@d,mc=@d,nc=@d,oc=@d,pc=@d;
264 UPDATE t1 SET qc=@d,rc=@d,sc=@d,tc=@d,uc=@d;
265 UPDATE t1 SET vc=@d,wc=@d,xc=@d,yc=@d,zc=@d;
266 COMMIT;
267
268 BEGIN;
269 UPDATE t2 SET a=@i,b=@i,c=@i,d=@i,e=@i;
270 UPDATE t2 SET f=@i,g=@i,h=@i,i=@i,j=@i;
271 UPDATE t2 SET k=@i,l=@i,m=@i,n=@i,o=@i;
272 UPDATE t2 SET p=@i,q=@i,r=@i,s=@i,t=@i,u=@i;
273 UPDATE t2 SET v=@i,w=@i,x=@i,y=@i,z=@i;
274 UPDATE t2 SET aa=@i,ba=@i,ca=@i,da=@i;
275 UPDATE t2 SET ea=@i,fa=@i,ga=@i,ha=@i,ia=@i,ja=@i;
276 UPDATE t2 SET ka=@i,la=@i,ma=@i,na=@i,oa=@i,pa=@i;
277 UPDATE t2 SET qa=@i,ra=@i,sa=@i,ta=@i,ua=@i;
278 UPDATE t2 SET va=@i,wa=@i,xa=@i,ya=@i,za=@i;
279 UPDATE t2 SET ab=@i,bb=@i,cb=@i,db=@i;
280 UPDATE t2 SET eb=@i,fb=@i,gb=@i,hb=@i,ib=@i,ja=@i;
281 UPDATE t2 SET kb=@i,lb=@i,mb=@i,nb=@i,ob=@i,pa=@i;
282 UPDATE t2 SET qb=@i,rb=@i,sb=@i,tb=@i,ub=@i;
283 UPDATE t2 SET vb=@i,wb=@i,xb=@i,yb=@i,zb=@i;
284 UPDATE t2 SET ac=@i,bc=@i,cc=@i,dc=@i;
285 UPDATE t2 SET ec=@i,fc=@i,gc=@i,hc=@i,ic=@i,jc=@i;
286 UPDATE t2 SET kc=@i,lc=@i,mc=@i,nc=@i,oc=@i,pc=@i;
287 UPDATE t2 SET qc=@i,rc=@i,sc=@i,tc=@i,uc=@i;
288 UPDATE t2 SET vc=@i,wc=@i,xc=@i,yc=@i,zc=@i;
289 COMMIT;
290
291
292 BEGIN;
293 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
294 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c,
295 v=@c,w=@c,x=@c,y=@c,z=@c,
296 aa=@c,ba=@c,ca=@c,da=@c,ea=@c,fa=@c,ga=@c,ha=@c,ia=@c,ja=@c,
297 ka=@c,la=@c,ma=@c,na=@c,oa=@c,pa=@c,qa=@c,ra=@c,sa=@c,ta=@c,ua=@c,
298 va=@c,wa=@c,xa=@c,ya=@c,za=@c,
299 ab=@c,bb=@c,cb=@c,db=@c,eb=@c,fb=@c,gb=@c,hb=@c,ib=@c,jb=@c,
300 kb=@c,lb=@c,mb=@c,nb=@c,ob=@c,pb=@c,qb=@c,rb=@c,sb=@c,tb=@c,ub=@c,
301 vb=@c,wb=@c,xb=@c,yb=@c,zb=@c,
302 ac=@c,bc=@c,cc=@c,dc=@c,ec=@c,fc=@c,gc=@c,hc=@c,ic=@c,jc=@c,
303 kc=@c,lc=@c,mc=@c,nc=@c,oc=@c,pc=@c,qc=@c,rc=@c,sc=@c,tc=@c,uc=@c,
304 vc=@c,wc=@c,xc=@c,yc=@c,zc=@c;
305
306 connect (con1,localhost,root,,);
307 SET GLOBAL innodb_flush_log_at_trx_commit=1;
308 DELETE FROM t2 LIMIT 1;
309 disconnect con1;
310 connection default;
311
312 --let $shutdown_timeout=0
313 --source include/restart_mysqld.inc
314 --let $shutdown_timeout=
315
316 check table t1,t2;
317 drop table t1,t2;
318
319 --echo #
320 --echo # MDEV-35475 Assertion `!rec_offs_nth_extern(offsets1, n)'
321 --echo # failed in cmp_rec_rec_simple_field
322 --echo #
323 let $row_format= `select @@global.innodb_default_row_format`;
324 if ($row_format != "redundant")
325 {
326 CREATE TABLE t1(f1 int not null, f2 text, f3 text, f4 text,
327 f5 text, f6 text, f7 text, f8 text,
328 f9 text, f10 text, f11 text, f12 text,
329 f13 text, f14 text, f15 text, f16 text,
330 f17 text, f18 text, f19 text, f20 text,
331 f21 text, f22 text, f23 text, f24 text,
332 f25 text, PRIMARY KEY(f1))ENGINE=InnoDB;
333 let $error_code = ER_TOO_BIG_ROWSIZE;
334 if ($row_format == "dynamic")
335 {
336 let $error_code = 0;
337 }
338
339 --error $error_code
340 SET STATEMENT unique_checks=0,foreign_key_checks=0 FOR
341 INSERT INTO t1 VALUES(1, REPEAT('a', 1024), REPEAT('b', 1024),
342 REPEAT('c', 1024), REPEAT('d', 1024),
343 REPEAT('e', 1024), REPEAT('f', 1024),
344 REPEAT('g', 4096), REPEAT('h', 1024),
345 REPEAT('i', 1024), REPEAT('j', 1024),
346 REPEAT('k', 1024), REPEAT('l', 1024),
347 REPEAT('m', 1024), REPEAT('n', 1024),
348 REPEAT('o', 1024), REPEAT('p', 1024),
349 REPEAT('q', 1024), REPEAT('r', 1024),
350 REPEAT('s', 1024), REPEAT('t', 1024),
351 REPEAT('u', 1024), REPEAT('v', 1024),
352 REPEAT('w', 1024), REPEAT('x', 1024)),
353 (2, REPEAT('a', 1024), REPEAT('b', 1024),
354 REPEAT('c', 1024), REPEAT('d', 1024),
355 REPEAT('e', 1024), REPEAT('f', 1024),
356 REPEAT('g', 4096), REPEAT('h', 1024),
357 REPEAT('i', 1024), REPEAT('j', 1024),
358 REPEAT('k', 1024), REPEAT('l', 1024),
359 REPEAT('m', 1024), REPEAT('n', 1024),
360 REPEAT('o', 1024), REPEAT('p', 1024),
361 REPEAT('q', 1024), REPEAT('r', 1024),
362 REPEAT('s', 1024), REPEAT('t', 1024),
363 REPEAT('u', 1024), REPEAT('v', 1024),
364 REPEAT('w', 1024), REPEAT('x', 1024)),
365 (3, REPEAT('a', 1024), REPEAT('b', 1024),
366 REPEAT('c', 1024), REPEAT('d', 1024),
367 REPEAT('e', 1024), REPEAT('f', 1024),
368 REPEAT('g', 4096), REPEAT('h', 1024),
369 REPEAT('i', 1024), REPEAT('j', 1024),
370 REPEAT('k', 1024), REPEAT('l', 1024),
371 REPEAT('m', 1024), REPEAT('n', 1024),
372 REPEAT('o', 1024), REPEAT('p', 1024),
373 REPEAT('q', 1024), REPEAT('r', 1024),
374 REPEAT('s', 1024), REPEAT('t', 1024),
375 REPEAT('u', 1024), REPEAT('v', 1024),
376 REPEAT('w', 1024), REPEAT('x', 1024));
377 DROP TABLE t1;
378 }