Debian Codegraph @

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

raw
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;