Debian Codegraph @

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

raw
1 --source include/no_valgrind_without_big.inc
2 # Tests for setting innodb-page-size=64k;
3 --source include/have_innodb.inc
4 --source include/have_innodb_64k.inc
5 --source include/have_sequence.inc
6 --source include/test_db_charset_latin1.inc
7
8 call mtr.add_suppression('InnoDB: Cannot add field.*because after adding it, the row size is');
9
10 let $MYSQLD_DATADIR= `select @@datadir`;
11
12 SET SESSION innodb_strict_mode=ON;
13 --error ER_CANT_CREATE_TABLE
14 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
15 --error ER_CANT_CREATE_TABLE
16 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
17 SET SESSION innodb_strict_mode=OFF;
18 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
19 SHOW WARNINGS;
20 DROP TABLE t1;
21 CREATE TABLE t1(a int PRIMARY KEY) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
22 SHOW WARNINGS;
23 DROP TABLE t1;
24
25 --echo # Test 1) Show the page size from Information Schema
26 SELECT variable_value FROM information_schema.global_status
27 WHERE LOWER(variable_name) = 'innodb_page_size';
28
29 --echo # Test 4) The maximum row size is dependent upon the page size.
30
31 SET SESSION innodb_strict_mode = ON;
32 SELECT @@innodb_strict_mode;
33
34 # Redundant table
35 --error ER_TOO_BIG_ROWSIZE
36 CREATE TABLE tab5(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255),
37 col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255),
38 col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255),
39 col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255),
40 col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255),
41 col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255),
42 col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255),
43 col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255),
44 col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255),
45 col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255),
46 col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255),col64 CHAR(255), col65 CHAR(255))
47 ENGINE = innodb ROW_FORMAT=REDUNDANT;
48 show warnings;
49
50 # Compact table, 32701 bytes
51
52 CREATE TABLE t1 (
53 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
54 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
55 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
56 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
57 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
58 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
59 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
60 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
61 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
62 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
63 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
64 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
65 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
66 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
67 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
68 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
69 c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
70 c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
71 c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
72 c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
73 c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
74 c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
75 c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
76 c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
77 c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
78 c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
79 c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
80 c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
81 c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
82 c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
83 c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
84 c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
85 c190 char(200), c191 char(200), c192 char(100),
86 c81 char(156)
87 ) ROW_FORMAT=compact;
88
89 DROP TABLE t1;
90
91 --replace_regex /> [0-9]*/> max_row_size/
92 --error ER_TOO_BIG_ROWSIZE
93 CREATE TABLE t1 (
94 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
95 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
96 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
97 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
98 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
99 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
100 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
101 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
102 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
103 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
104 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
105 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
106 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
107 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
108 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
109 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
110 c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
111 c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
112 c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
113 c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
114 c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
115 c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
116 c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
117 c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
118 c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
119 c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
120 c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
121 c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
122 c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
123 c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
124 c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
125 c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
126 c190 char(200), c191 char(200), c192 char(100),
127 c81 char(157)
128 ) ROW_FORMAT=compact;
129
130 # Dynamic table, 32701 bytes
131
132 CREATE TABLE t1 (
133 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
134 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
135 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
136 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
137 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
138 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
139 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
140 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
141 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
142 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
143 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
144 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
145 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
146 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
147 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
148 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
149 c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
150 c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
151 c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
152 c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
153 c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
154 c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
155 c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
156 c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
157 c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
158 c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
159 c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
160 c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
161 c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
162 c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
163 c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
164 c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
165 c190 char(200), c191 char(200), c192 char(100),
166 c81 char(156)
167 ) ROW_FORMAT=dynamic;
168
169 DROP TABLE t1;
170
171 --replace_regex /> [0-9]*/> max_row_size/
172 --error ER_TOO_BIG_ROWSIZE
173 CREATE TABLE t1 (
174 c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
175 c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
176 c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
177 c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
178 c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
179 c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
180 c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
181 c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
182 c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
183 c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
184 c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
185 c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
186 c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
187 c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
188 c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
189 c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
190 c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
191 c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
192 c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
193 c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
194 c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
195 c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
196 c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
197 c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
198 c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
199 c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
200 c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
201 c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
202 c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
203 c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
204 c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
205 c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
206 c190 char(200), c191 char(200), c192 char(100),
207 c81 char(157)
208 ) ROW_FORMAT=dynamic;
209
210 --echo # Test 8) Test creating a table that could lead to undo log overflow.
211
212 CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
213 h blob,i blob,j blob,k blob,l blob,m blob,n blob,
214 o blob,p blob,q blob,r blob,s blob,t blob,u blob,
215 v blob, w blob, x blob, y blob, z blob,
216 aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob,
217 ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob,
218 oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob,
219 va blob, wa blob, xa blob, ya blob, za blob,
220 ab blob,bb blob,cb blob,db blob,eb blob,fb blob,gb blob,
221 hb blob,ib blob,jb blob,kb blob,lb blob,mb blob,nb blob,
222 ob blob,pb blob,qb blob,rb blob,sb blob,tb blob,ub blob,
223 vb blob, wb blob, xb blob, yb blob, zb blob,
224 ac blob, bc blob, cc blob, dc blob, ec blob,fc blob,gc blob,
225 hc blob, ic blob, jc blob, kc blob, lc blob,mc blob,nc blob,
226 oc blob, pc blob, qc blob, rc blob, sc blob,tc blob,uc blob,
227 vc blob, wc blob, xc blob, yc blob, zc blob
228 ) ENGINE=InnoDB ROW_FORMAT=dynamic;
229
230 SET @a = repeat('a', 767);
231 SET @b = repeat('b', 767);
232 SET @c = repeat('c', 767);
233 SET @d = repeat('d', 767);
234 SET @e = repeat('e', 767);
235
236 # With no indexes defined, we can update all columns to max key part length.
237
238 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,
239 @a,@a,@a,@a,@a,@a,@a,
240 @a,@a,@a,@a,@a,@a,@a,
241 @a,@a,@a,@a,@a,
242 @a,@a,@a,@a,@a,@a,@a,
243 @a,@a,@a,@a,@a,@a,@a,
244 @a,@a,@a,@a,@a,@a,@a,
245 @a,@a,@a,@a,@a,
246 @a,@a,@a,@a,@a,@a,@a,
247 @a,@a,@a,@a,@a,@a,@a,
248 @a,@a,@a,@a,@a,@a,@a,
249 @a,@a,@a,@a,@a,
250 @a,@a,@a,@a,@a,@a,@a,
251 @a,@a,@a,@a,@a,@a,@a,
252 @a,@a,@a,@a,@a,@a,@a,
253 @a,@a,@a,@a,@a
254 );
255
256 UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
257 k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b,
258 v=@b,w=@b,x=@b,y=@b,z=@b,
259 aa=@b,ba=@b,ca=@b,da=@b,ea=@b,fa=@b,ga=@b,ha=@b,ia=@b,ja=@b,
260 ka=@b,la=@b,ma=@b,na=@b,oa=@b,pa=@b,qa=@b,ra=@b,sa=@b,ta=@b,ua=@b,
261 va=@b,wa=@b,xa=@b,ya=@b,za=@b,
262 ab=@b,bb=@b,cb=@b,db=@b,eb=@b,fb=@b,gb=@b,hb=@b,ib=@b,jb=@b,
263 kb=@b,lb=@b,mb=@b,nb=@b,ob=@b,pb=@b,qb=@b,rb=@b,sb=@b,tb=@b,ub=@b,
264 vb=@b,wb=@b,xb=@b,yb=@b,zb=@b,
265 ab=@b,bb=@b,cb=@b,db=@b,eb=@b,fb=@b,gb=@b,hb=@b,ib=@b,jb=@b,
266 kb=@b,lb=@b,mb=@b,nb=@b,ob=@b,pb=@b,qb=@b,rb=@b,sb=@b,tb=@b,ub=@b,
267 vb=@b,wb=@b,xb=@b,yb=@b,zb=@b,
268 ac=@b,bc=@b,cc=@b,dc=@b,ec=@b,fc=@b,gc=@b,hc=@b,ic=@b,jc=@b,
269 kc=@b,lc=@b,mc=@b,nc=@b,oc=@b,pc=@b,qc=@b,rc=@b,sc=@b,tc=@b,uc=@b,
270 vc=@b,wc=@b,xc=@b,yc=@b,zc=@b;
271
272 # With this many indexes defined, we can still update all fields.
273 CREATE INDEX t1a ON t1 (a(767),b(767));
274 CREATE INDEX t1c ON t1 (c(767),d(767));
275 CREATE INDEX t1e ON t1 (e(767),f(767));
276 CREATE INDEX t1f2 ON t1 (g(767),h(767));
277 CREATE INDEX t1f4 ON t1 (i(767),j(767));
278 CREATE INDEX t1k ON t1 (k(767),m(767));
279 CREATE INDEX t1f8 ON t1 (n(767),o(767));
280 CREATE INDEX t1f11 ON t1 (p(767),q(767));
281 CREATE INDEX t1f13 ON t1 (r(767),s(767));
282 CREATE INDEX t1f15 ON t1 (t(767),u(767));
283 CREATE INDEX t1f18 ON t1 (w(767),x(767));
284 CREATE INDEX t1f20 ON t1 (y(767),z(767));
285 CREATE INDEX ta1a6 ON t1 (aa(767),ba(767));
286 CREATE INDEX tc1c6 ON t1 (ca(767),da(767));
287 CREATE INDEX te1e6 ON t1 (ea(767),fa(767));
288
289 UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
290 k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c,
291 v=@c,w=@c,x=@c,y=@c,z=@c,
292 aa=@c,ba=@c,ca=@c,da=@c,ea=@c,fa=@c,ga=@c,ha=@c,ia=@c,ja=@c,
293 ka=@c,la=@c,ma=@c,na=@c,oa=@c,pa=@c,qa=@c,ra=@c,sa=@c,ta=@c,ua=@c,
294 va=@c,wa=@c,xa=@c,ya=@c,za=@c,
295 ab=@c,bb=@c,cb=@c,db=@c,eb=@c,fb=@c,gb=@c,hb=@c,ib=@c,jb=@c,
296 kb=@c,lb=@c,mb=@c,nb=@c,ob=@c,pb=@c,qb=@c,rb=@c,sb=@c,tb=@c,ub=@c,
297 vb=@c,wb=@c,xb=@c,yb=@c,zb=@c,
298 ac=@c,bc=@c,cc=@c,dc=@c,ec=@c,fc=@c,gc=@c,hc=@c,ic=@c,jc=@c,
299 kc=@c,lc=@c,mc=@c,nc=@c,oc=@c,pc=@c,qc=@c,rc=@c,sc=@c,tc=@c,uc=@c,
300 vc=@c,wc=@c,xc=@c,yc=@c,zc=@c;
301
302 COMMIT;
303
304 # Add one more index and the UNDO record becomes too big to update all columns.
305 # But a single transaction can update the columns in separate statements.
306 # because the UNDO records will be smaller.
307
308 CREATE INDEX tg1f2 ON t1 (ia(767),ja(767));
309
310 BEGIN;
311 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d,f=@d,g=@d,h=@d,i=@d,j=@d,
312 k=@d,l=@d,m=@d,n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d,
313 v=@d,w=@d,x=@d,y=@d,z=@d,
314 aa=@d,ba=@d,ca=@d,da=@d,ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d,
315 ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d,qa=@d,ra=@d,sa=@d,ta=@d,ua=@d,
316 va=@d,wa=@d,xa=@d,ya=@d,za=@d,
317 ab=@d,bb=@d,cb=@d,db=@d,eb=@d,fb=@d,gb=@d,hb=@d,ib=@d,jb=@d,
318 kb=@d,lb=@d,mb=@d,nb=@d,ob=@d,pb=@d,qb=@d,rb=@d,sb=@d,tb=@d,ub=@d,
319 vb=@d,wb=@d,xb=@d,yb=@d,zb=@d,
320 ac=@d,bc=@d,cc=@d,dc=@d,ec=@d,fc=@d,gc=@d,hc=@d,ic=@d,jc=@d,
321 kc=@d,lc=@d,mc=@d,nc=@d,oc=@d,pc=@d,qc=@d,rc=@d,sc=@d,tc=@d,uc=@d,
322 vc=@d,wc=@d,xc=@d,yc=@d,zc=@d;
323 ROLLBACK;
324
325 BEGIN;
326 UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
327 UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d;
328 UPDATE t1 SET k=@d,l=@d,m=@d,n=@d,o=@d;
329 UPDATE t1 SET p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
330 UPDATE t1 SET v=@d,w=@d,x=@d,y=@d,z=@d;
331 UPDATE t1 SET aa=@d,ba=@d,ca=@d,da=@d;
332 UPDATE t1 SET ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d;
333 UPDATE t1 SET ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d;
334 UPDATE t1 SET qa=@d,ra=@d,sa=@d,ta=@d,ua=@d;
335 UPDATE t1 SET va=@d,wa=@d,xa=@d,ya=@d,za=@d;
336 UPDATE t1 SET ab=@d,bb=@d,cb=@d,db=@d;
337 UPDATE t1 SET eb=@d,fb=@d,gb=@d,hb=@d,ib=@d,ja=@d;
338 UPDATE t1 SET kb=@d,lb=@d,mb=@d,nb=@d,ob=@d,pa=@d;
339 UPDATE t1 SET qb=@d,rb=@d,sb=@d,tb=@d,ub=@d;
340 UPDATE t1 SET vb=@d,wb=@d,xb=@d,yb=@d,zb=@d;
341 UPDATE t1 SET ac=@d,bc=@d,cc=@d,dc=@d;
342 UPDATE t1 SET ec=@d,fc=@d,gc=@d,hc=@d,ic=@d,jc=@d;
343 UPDATE t1 SET kc=@d,lc=@d,mc=@d,nc=@d,oc=@d,pc=@d;
344 UPDATE t1 SET qc=@d,rc=@d,sc=@d,tc=@d,uc=@d;
345 UPDATE t1 SET vc=@d,wc=@d,xc=@d,yc=@d,zc=@d;
346 COMMIT;
347
348 # More indexes can still be added and a single field can still be updated
349 CREATE INDEX ti1f4 ON t1 (ia(767),ka(767));
350 CREATE INDEX tk1f6 ON t1 (la(767),ma(767));
351 CREATE INDEX tm1f8 ON t1 (na(767),oa(767));
352 CREATE INDEX to1f11 ON t1 (pa(767),qa(767));
353 CREATE INDEX tq1f13 ON t1 (ra(767),sa(767));
354 CREATE INDEX ts1f15 ON t1 (ta(767),ua(767));
355 CREATE INDEX tu1f18 ON t1 (wa(767),xa(767));
356 CREATE INDEX tx1f20 ON t1 (ya(767),za(767));
357 CREATE INDEX ta1a5 ON t1 (ab(767),bb(767));
358 CREATE INDEX tc1c5 ON t1 (cb(767),db(767));
359 CREATE INDEX te1e5 ON t1 (eb(767),fb(767));
360 CREATE INDEX t5g1f2 ON t1 (gb(767),hb(767));
361 CREATE INDEX t5i1f4 ON t1 (ib(767),kb(767));
362 CREATE INDEX t5k1f6 ON t1 (lb(767),mb(767));
363 CREATE INDEX t5m1f8 ON t1 (nb(767),ob(767));
364 CREATE INDEX t5o1f11 ON t1 (pb(767),qb(767));
365 CREATE INDEX t65q1f13 ON t1 (rb(767),sb(767));
366 CREATE INDEX t65s1f15 ON t1 (tb(767),ub(767));
367 CREATE INDEX t65u1f18 ON t1 (wb(767),xb(767));
368 CREATE INDEX t65x1f20 ON t1 (yb(767),zb(767));
369 CREATE INDEX xta1a5 ON t1 (ac(767),bc(767));
370 CREATE INDEX xt5g1f2 ON t1 (gc(767),hc(767));
371 CREATE INDEX xt5i1f4 ON t1 (ic(767));
372 CREATE INDEX xtc1c5 ON t1 (cc(767),dc(767));
373 CREATE INDEX xte1e5 ON t1 (ec(767),fc(767));
374 UPDATE t1 SET t=@e;
375
376 # One more index and row size is too big (not any more!)
377 #--replace_regex /> [0-9]*/> max_row_size/
378 #--error ER_TOO_BIG_ROWSIZE
379 CREATE INDEX xt5k1f6 ON t1 (lc(767),mc(767));
380 SHOW CREATE TABLE t1;
381 SHOW WARNINGS;
382
383 CREATE TABLE t2(COL1 TEXT,
384 COL2 TEXT,
385 COL3 TEXT,
386 COL4 TEXT,
387 COL5 TEXT,
388 COL6 TEXT,
389 COL7 TEXT,
390 COL8 TEXT,
391 COL9 TEXT,
392 COL10 TEXT,
393 COL11 TEXT,
394 COL12 TEXT,
395 COL13 TEXT,
396 COL14 TEXT,
397 COL15 TEXT,
398 COL16 TEXT,
399 COL17 TEXT,
400 COL18 TEXT,
401 COL19 TEXT,
402 COL20 TEXT,
403 COL21 TEXT,
404 COL22 TEXT,
405 COL23 TEXT,
406 COL24 TEXT,
407 COL25 TEXT,
408 COL26 TEXT,
409 COL27 TEXT,
410 COL28 TEXT,
411 COL29 TEXT,
412 COL30 TEXT,
413 COL31 TEXT,
414 COL32 TEXT,
415 COL33 TEXT,
416 COL34 TEXT,
417 COL35 TEXT,
418 COL36 TEXT,
419 COL37 TEXT,
420 COL38 TEXT,
421 COL39 TEXT,
422 COL40 TEXT,
423 COL41 TEXT,
424 COL42 TEXT,
425 COL43 TEXT,
426 COL44 TEXT,
427 COL45 TEXT,
428 COL46 TEXT,
429 COL47 TEXT,
430 COL48 TEXT,
431 COL49 TEXT,
432 COL50 TEXT,
433 COL51 TEXT,
434 COL52 TEXT,
435 COL53 TEXT,
436 COL54 TEXT,
437 COL55 TEXT,
438 COL56 TEXT,
439 COL57 TEXT,
440 COL58 TEXT,
441 COL59 TEXT,
442 COL60 TEXT,
443 COL61 TEXT,
444 COL62 TEXT,
445 COL63 TEXT,
446 COL64 TEXT,
447 COL65 TEXT,
448 COL66 TEXT,
449 COL67 TEXT,
450 COL68 TEXT,
451 COL69 TEXT,
452 COL70 TEXT,
453 COL71 TEXT,
454 COL72 TEXT,
455 COL73 TEXT,
456 COL74 TEXT,
457 COL75 TEXT,
458 COL76 TEXT,
459 COL77 TEXT,
460 COL78 TEXT,
461 COL79 TEXT,
462 COL80 TEXT,
463 COL81 TEXT,
464 COL82 TEXT,
465 COL83 TEXT,
466 COL84 TEXT,
467 COL85 TEXT,
468 COL86 TEXT,
469 COL87 TEXT,
470 COL88 TEXT,
471 COL89 TEXT,
472 COL90 TEXT,
473 COL91 TEXT,
474 COL92 TEXT,
475 COL93 TEXT,
476 COL94 TEXT,
477 COL95 TEXT,
478 COL96 TEXT,
479 COL97 TEXT,
480 COL98 TEXT,
481 COL99 TEXT,
482 COL100 TEXT,
483 COL101 TEXT,
484 COL102 TEXT,
485 COL103 TEXT,
486 COL104 TEXT,
487 COL105 TEXT,
488 COL106 TEXT,
489 COL107 TEXT,
490 COL108 TEXT,
491 COL109 TEXT,
492 COL110 TEXT,
493 COL111 TEXT,
494 COL112 TEXT,
495 COL113 TEXT,
496 COL114 TEXT,
497 COL115 TEXT,
498 COL116 TEXT,
499 COL117 TEXT,
500 COL118 TEXT,
501 COL119 TEXT,
502 COL120 TEXT,
503 COL121 TEXT,
504 COL122 TEXT,
505 COL123 TEXT,
506 COL124 TEXT,
507 COL125 TEXT,
508 COL126 TEXT,
509 COL127 TEXT,
510 COL128 TEXT,
511 COL129 TEXT,
512 COL130 TEXT,
513 COL131 TEXT,
514 COL132 TEXT,
515 COL133 TEXT,
516 COL134 TEXT,
517 COL135 TEXT,
518 COL136 TEXT,
519 COL137 TEXT,
520 COL138 TEXT,
521 COL139 TEXT,
522 COL140 TEXT,
523 COL141 TEXT,
524 COL142 TEXT,
525 COL143 TEXT,
526 COL144 TEXT,
527 COL145 TEXT,
528 COL146 TEXT,
529 COL147 TEXT,
530 COL148 TEXT,
531 COL149 TEXT,
532 COL150 TEXT,
533 COL151 TEXT,
534 COL152 TEXT,
535 COL153 TEXT,
536 COL154 TEXT,
537 COL155 TEXT,
538 COL156 TEXT,
539 COL157 TEXT,
540 COL158 TEXT,
541 COL159 TEXT,
542 COL160 TEXT,
543 COL161 TEXT,
544 COL162 TEXT,
545 COL163 TEXT,
546 COL164 TEXT,
547 COL165 TEXT,
548 COL166 TEXT,
549 COL167 TEXT,
550 COL168 TEXT,
551 COL169 TEXT,
552 COL170 TEXT,
553 COL171 TEXT,
554 COL172 TEXT,
555 COL173 TEXT,
556 COL174 TEXT,
557 COL175 TEXT,
558 COL176 TEXT,
559 COL177 TEXT,
560 COL178 TEXT,
561 COL179 TEXT,
562 COL180 TEXT,
563 COL181 TEXT,
564 COL182 TEXT,
565 COL183 TEXT,
566 COL184 TEXT,
567 COL185 TEXT,
568 COL186 TEXT,
569 COL187 TEXT,
570 COL188 TEXT,
571 COL189 TEXT,
572 COL190 TEXT,
573 COL191 TEXT,
574 COL192 TEXT,
575 COL193 TEXT,
576 COL194 TEXT,
577 COL195 TEXT,
578 COL196 TEXT,
579 COL197 TEXT)
580 row_format=dynamic,ENGINE=INNODB;
581
582 set @a = repeat('0123456789', 800);
583 set @b = repeat('9876543210', 800);
584
585 insert into t2 values(
586 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
587 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
588 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
589 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
590 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
591 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
592 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
593 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
594 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
595 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
596 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
597 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
598 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
599 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
600 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
601 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
602 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
603 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
604 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
605 @a,@a,@a,@a,@a,@a,@a);
606
607 update t2 set col190=@b;
608
609 set @a = repeat('0123456789', 1650);
610 set @b = repeat('9876543210', 2000);
611
612 insert into t2 values(
613 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
614 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
615 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
616 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
617 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
618 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
619 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
620 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
621 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
622 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
623 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
624 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
625 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
626 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
627 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
628 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
629 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
630 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
631 @a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
632 @a,@a,@a,@a,@a,@a,@a);
633
634 update t2 set col190=@b;
635
636 #
637 # Verify persistence and loading of flags in the ibd files.
638 #
639
640 --source include/restart_mysqld.inc
641
642 set @a = repeat('abcdefghijklmnopqrstuvwxyz', 1650);
643 set @b = repeat('zyxwvutsrqponmlkjihgfedcba', 2000);
644 update t2 set col189 = @b;
645 insert into t2 select * from t2;
646 show create table t1;
647 show create table t2;
648
649 BEGIN;
650 update t2 set col150=@a;
651 update t2 set col145=@b;
652 COMMIT;
653
654 drop table t2;
655 DROP TABLE t1;
656
657 --echo #
658 --echo # MDEV-19526/MDEV-29742 heap number overflow
659 --echo #
660 CREATE TABLE t1(a SMALLINT NOT NULL UNIQUE AUTO_INCREMENT, KEY(a))
661 ENGINE=InnoDB;
662 INSERT INTO t1 (a) SELECT seq FROM seq_1_to_8191;
663 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
664 DROP TABLE t1;
665
666 --echo # End of 10.3 tests
667
668 --source include/test_db_charset_restore.inc