| 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 |
} |