| 1 |
--source include/have_innodb.inc |
| 2 |
--source include/have_innodb_32k.inc |
| 3 |
# Embedded server does not support restarting |
| 4 |
--source include/not_embedded.inc |
| 5 |
|
| 6 |
let $MYSQLD_DATADIR= `select @@datadir`; |
| 7 |
|
| 8 |
CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob, |
| 9 |
h blob,i blob,j blob,k blob,l blob,m blob,n blob, |
| 10 |
o blob,p blob,q blob,r blob,s blob,t blob,u blob, |
| 11 |
v blob, w blob, x blob, y blob, z blob, |
| 12 |
aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob, |
| 13 |
ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob, |
| 14 |
oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob, |
| 15 |
va blob, wa blob, xa blob, ya blob, za blob) |
| 16 |
ENGINE=InnoDB ROW_FORMAT=dynamic; |
| 17 |
|
| 18 |
SET innodb_strict_mode=OFF; |
| 19 |
CREATE TABLE t2(a blob,b blob,c blob,d blob,e blob,f blob,g blob, |
| 20 |
h blob,i blob,j blob,k blob,l blob,m blob,n blob, |
| 21 |
o blob,p blob,q blob,r blob,s blob,t blob,u blob, |
| 22 |
v blob, w blob, x blob, y blob, z blob, |
| 23 |
aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob, |
| 24 |
ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob, |
| 25 |
oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob, |
| 26 |
va blob, wa blob, xa blob, ya blob, za blob) |
| 27 |
ENGINE=InnoDB ROW_FORMAT=compact; |
| 28 |
SET innodb_strict_mode=ON; |
| 29 |
|
| 30 |
SET @a = repeat('a', 767); |
| 31 |
SET @b = repeat('b', 767); |
| 32 |
SET @c = repeat('c', 767); |
| 33 |
SET @d = repeat('d', 767); |
| 34 |
SET @e = repeat('e', 767); |
| 35 |
SET @f = repeat('f', 767); |
| 36 |
SET @f = repeat('g', 767); |
| 37 |
|
| 38 |
# With no indexes defined, we can update all columns to max key part length. |
| 39 |
|
| 40 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 41 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 42 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 43 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 44 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 45 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 46 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 47 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 48 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 49 |
INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a); |
| 50 |
|
| 51 |
SET @f = repeat('h', 500); |
| 52 |
SET @f = repeat('i', 500); |
| 53 |
SET @f = repeat('j', 500); |
| 54 |
SET @f = repeat('k', 500); |
| 55 |
SET @f = repeat('l', 500); |
| 56 |
SET @f = repeat('m', 500); |
| 57 |
|
| 58 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 59 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 60 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 61 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 62 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 63 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 64 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 65 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 66 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 67 |
INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h); |
| 68 |
|
| 69 |
|
| 70 |
UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b, |
| 71 |
k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b, |
| 72 |
v=@b,w=@b,x=@b,y=@b,z=@b, |
| 73 |
aa=@b,ba=@b,ca=@b,da=@b,ea=@b,fa=@b,ga=@b,ha=@b,ia=@b,ja=@b, |
| 74 |
ka=@b,la=@b,ma=@b,na=@b,oa=@b,pa=@b,qa=@b,ra=@b,sa=@b,ta=@b,ua=@b, |
| 75 |
va=@b,wa=@b,xa=@b,ya=@b,za=@b; |
| 76 |
|
| 77 |
UPDATE t2 SET a=@i,b=@i,c=@i,d=@i,e=@i,f=@i,g=@i,h=@i,i=@i,j=@i, |
| 78 |
k=@i,l=@i,m=@i,n=@i,o=@i,p=@i,q=@i,r=@i,s=@i,t=@i,u=@i, |
| 79 |
v=@i,w=@i,x=@i,y=@i,z=@i, |
| 80 |
aa=@i,ba=@i,ca=@i,da=@i,ea=@i,fa=@i,ga=@i,ha=@i,ia=@i,ja=@i, |
| 81 |
ka=@i,la=@i,ma=@i,na=@i,oa=@i,pa=@i,qa=@i,ra=@i,sa=@i,ta=@i,ua=@i, |
| 82 |
va=@i,wa=@i,xa=@i,ya=@i,za=@i; |
| 83 |
|
| 84 |
CREATE INDEX t1a ON t1 (a(767)); |
| 85 |
CREATE INDEX t1b ON t1 (b(767)); |
| 86 |
CREATE INDEX t1c ON t1 (c(767)); |
| 87 |
CREATE INDEX t1d ON t1 (d(767)); |
| 88 |
CREATE INDEX t1e ON t1 (e(767)); |
| 89 |
CREATE INDEX t1f1 ON t1 (f(767)); |
| 90 |
CREATE INDEX t1f2 ON t1 (g(767)); |
| 91 |
CREATE INDEX t1f3 ON t1 (h(767)); |
| 92 |
CREATE INDEX t1f4 ON t1 (i(767)); |
| 93 |
CREATE INDEX t1f5 ON t1 (j(767)); |
| 94 |
|
| 95 |
CREATE INDEX t1a ON t2 (a(767)); |
| 96 |
CREATE INDEX t1b ON t2 (b(767)); |
| 97 |
CREATE INDEX t1c ON t2 (c(767)); |
| 98 |
CREATE INDEX t1d ON t2 (d(767)); |
| 99 |
CREATE INDEX t1e ON t2 (e(767)); |
| 100 |
CREATE INDEX t1f1 ON t2 (f(767)); |
| 101 |
CREATE INDEX t1f2 ON t2 (g(767)); |
| 102 |
CREATE INDEX t1f3 ON t2 (h(767)); |
| 103 |
|
| 104 |
UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c, |
| 105 |
k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c, |
| 106 |
v=@c,w=@c,x=@b,y=@c,z=@c, |
| 107 |
aa=@c,ba=@c,ca=@c,da=@c,ea=@c,fa=@c,ga=@c,ha=@c,ia=@c,ja=@c, |
| 108 |
ka=@c,la=@c,ma=@c,na=@c,oa=@c,pa=@c,qa=@c,ra=@c,sa=@c,ta=@b,ua=@c, |
| 109 |
va=@c,wa=@c,xa=@c,ya=@c,za=@c; |
| 110 |
|
| 111 |
UPDATE t2 SET a=@k,b=@k,c=@k,d=@k,e=@k,f=@k,g=@k,h=@k,i=@k,j=@k, |
| 112 |
k=@k,l=@k,m=@k,n=@k,o=@k,p=@k,q=@k,r=@k,s=@k,t=@k,u=@k, |
| 113 |
v=@k,w=@k,x=@b,y=@k,z=@k, |
| 114 |
aa=@k,ba=@k,ca=@k,da=@k,ea=@k,fa=@k,ga=@k,ha=@k,ia=@k,ja=@k, |
| 115 |
ka=@k,la=@k,ma=@k,na=@k,oa=@k,pa=@k,qa=@k,ra=@k,sa=@k,ta=@b,ua=@k, |
| 116 |
va=@k,wa=@k,xa=@k,ya=@k,za=@k; |
| 117 |
|
| 118 |
BEGIN; |
| 119 |
UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d; |
| 120 |
UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d; |
| 121 |
UPDATE t1 SET k=@d,l=@d,m=@d,n=@d,o=@d; |
| 122 |
UPDATE t1 SET p=@d,q=@d,r=@d,s=@d,t=@d,u=@d; |
| 123 |
UPDATE t1 SET v=@d,w=@d,x=@d,y=@d,z=@d; |
| 124 |
UPDATE t1 SET aa=@d,ba=@d,ca=@d,da=@d; |
| 125 |
UPDATE t1 SET ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d; |
| 126 |
UPDATE t1 SET ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d; |
| 127 |
UPDATE t1 SET qa=@d,ra=@d,sa=@d,ta=@d,ua=@d; |
| 128 |
UPDATE t1 SET va=@d,wa=@d,xa=@d,ya=@d,za=@d; |
| 129 |
COMMIT; |
| 130 |
|
| 131 |
BEGIN; |
| 132 |
UPDATE t2 SET a=@l,b=@l,c=@l,d=@l,e=@l; |
| 133 |
UPDATE t2 SET f=@l,g=@l,h=@l,i=@l,j=@l; |
| 134 |
UPDATE t2 SET k=@l,l=@l,m=@l,n=@l,o=@l; |
| 135 |
UPDATE t2 SET p=@l,q=@l,r=@l,s=@l,t=@l,u=@l; |
| 136 |
UPDATE t2 SET v=@l,w=@l,x=@l,y=@l,z=@l; |
| 137 |
UPDATE t2 SET aa=@l,ba=@l,ca=@l,da=@l; |
| 138 |
UPDATE t2 SET ea=@l,fa=@l,ga=@l,ha=@l,ia=@l,ja=@l; |
| 139 |
UPDATE t2 SET ka=@l,la=@l,ma=@l,na=@l,oa=@l,pa=@l; |
| 140 |
UPDATE t2 SET qa=@l,ra=@l,sa=@l,ta=@l,ua=@l; |
| 141 |
UPDATE t2 SET va=@l,wa=@l,xa=@l,ya=@l,za=@l; |
| 142 |
COMMIT; |
| 143 |
|
| 144 |
BEGIN; |
| 145 |
INSERT INTO t1 SELECT * from t2; |
| 146 |
|
| 147 |
BEGIN; |
| 148 |
UPDATE t1 SET a=@e,b=@e,c=@e,d=@e,e=@e; |
| 149 |
--let $shutdown_timeout=0 |
| 150 |
--source include/restart_mysqld.inc |
| 151 |
--let $shutdown_timeout= |
| 152 |
|
| 153 |
UPDATE t1 SET a=@f,b=@f,c=@f,d=@f,e=@f,f=@f,g=@f,h=@f,i=@f,j=@f, |
| 154 |
k=@f,l=@f,m=@f,n=@f,o=@f,p=@f,q=@f,r=@f,s=@f,t=@f,u=@f, |
| 155 |
v=@f,w=@f,x=@b,y=@f,z=@f, |
| 156 |
aa=@f,ba=@f,ca=@f,da=@f,ea=@f,fa=@f,ga=@f,ha=@f,ia=@f,ja=@f, |
| 157 |
ka=@f,la=@f,ma=@f,na=@f,oa=@f,pa=@f,qa=@f,ra=@f,sa=@f,ta=@b,ua=@f, |
| 158 |
va=@f,wa=@f,xa=@f,ya=@f,za=@f; |
| 159 |
|
| 160 |
UPDATE t2 SET a=@h,b=@h,c=@h,d=@h,e=@h,f=@h,g=@h,h=@h,i=@h,j=@h, |
| 161 |
k=@h,l=@h,m=@h,n=@h,o=@h,p=@h,q=@h,r=@h,s=@h,t=@h,u=@h, |
| 162 |
v=@h,w=@h,x=@b,y=@h,z=@h, |
| 163 |
aa=@h,ba=@h,ca=@h,da=@h,ea=@h,fa=@h,ga=@h,ha=@h,ia=@h,ja=@h, |
| 164 |
ka=@h,la=@h,ma=@h,na=@h,oa=@h,pa=@h,qa=@h,ra=@h,sa=@h,ta=@b,ua=@h, |
| 165 |
va=@h,wa=@h,xa=@h,ya=@h,za=@h; |
| 166 |
|
| 167 |
BEGIN; |
| 168 |
UPDATE t1 SET a=@g,b=@g,c=@g,d=@g,e=@g; |
| 169 |
UPDATE t1 SET f=@g,g=@g,h=@g,i=@g,j=@g; |
| 170 |
UPDATE t1 SET k=@g,l=@g,m=@g,n=@g,o=@g; |
| 171 |
UPDATE t1 SET p=@g,q=@g,r=@g,s=@g,t=@g,u=@g; |
| 172 |
UPDATE t1 SET v=@g,w=@g,x=@g,y=@g,z=@g; |
| 173 |
UPDATE t1 SET aa=@g,ba=@g,ca=@g,da=@g; |
| 174 |
UPDATE t1 SET ea=@g,fa=@g,ga=@g,ha=@g,ia=@g,ja=@g; |
| 175 |
UPDATE t1 SET ka=@g,la=@g,ma=@g,na=@g,oa=@g,pa=@g; |
| 176 |
UPDATE t1 SET qa=@g,ra=@g,sa=@g,ta=@g,ua=@g; |
| 177 |
UPDATE t1 SET va=@g,wa=@g,xa=@g,ya=@g,za=@g; |
| 178 |
COMMIT; |
| 179 |
|
| 180 |
BEGIN; |
| 181 |
UPDATE t2 SET a=@m,b=@m,c=@m,d=@m,e=@m; |
| 182 |
UPDATE t2 SET f=@m,g=@m,h=@m,i=@m,j=@m; |
| 183 |
UPDATE t2 SET k=@m,l=@m,m=@m,n=@m,o=@m; |
| 184 |
UPDATE t2 SET p=@m,q=@m,r=@m,s=@m,t=@m,u=@m; |
| 185 |
UPDATE t2 SET v=@m,w=@m,x=@m,y=@m,z=@m; |
| 186 |
UPDATE t2 SET aa=@m,ba=@m,ca=@m,da=@m; |
| 187 |
UPDATE t2 SET ea=@m,fa=@m,ga=@m,ha=@m,ia=@m,ja=@m; |
| 188 |
UPDATE t2 SET ka=@m,la=@m,ma=@m,na=@m,oa=@m,pa=@m; |
| 189 |
UPDATE t2 SET qa=@m,ra=@m,sa=@m,ta=@m,ua=@m; |
| 190 |
UPDATE t2 SET va=@m,wa=@m,xa=@m,ya=@m,za=@m; |
| 191 |
COMMIT; |
| 192 |
|
| 193 |
show create table t1; |
| 194 |
show create table t2; |
| 195 |
drop table t1,t2; |