summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/innodb/r/innodb-64k.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-64k.result')
-rw-r--r--mysql-test/suite/innodb/r/innodb-64k.result1092
1 files changed, 1092 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-64k.result b/mysql-test/suite/innodb/r/innodb-64k.result
new file mode 100644
index 00000000..75817956
--- /dev/null
+++ b/mysql-test/suite/innodb/r/innodb-64k.result
@@ -0,0 +1,1092 @@
+call mtr.add_suppression('InnoDB: Cannot add field.*because after adding it, the row size is');
+# Test 1) Show the page size from Information Schema
+SELECT variable_value FROM information_schema.global_status
+WHERE LOWER(variable_name) = 'innodb_page_size';
+variable_value
+65536
+# Test 4) The maximum row size is dependent upon the page size.
+SET SESSION innodb_strict_mode = ON;
+SELECT @@innodb_strict_mode;
+@@innodb_strict_mode
+1
+CREATE TABLE tab5(col1 CHAR (255), col2 CHAR (255), col3 CHAR(255),col4 CHAR(255), col5 CHAR(255),
+col6 CHAR(255), col7 CHAR(255), col8 CHAR(255), col9 CHAR(255),col10 CHAR(255), col11 CHAR(255),
+col12 CHAR(255), col13 CHAR(255),col14 CHAR(255),col15 CHAR(255),col16 CHAR(255), col17 CHAR(255),
+col18 CHAR(255),col19 CHAR(255),col20 CHAR(255),col21 CHAR(255),col22 CHAR(255), col23 CHAR(255),
+col24 CHAR(255),col25 CHAR(255),col26 CHAR(255),col27 CHAR(255),col28 CHAR(255), col29 CHAR(255),
+col30 CHAR(255),col31 CHAR(255),col32 CHAR(255),col33 CHAR(255),col34 CHAR(255), col35 CHAR(255),
+col36 CHAR(255),col37 CHAR(255),col38 CHAR(255),col39 CHAR(255),col40 CHAR(255), col41 CHAR(255),
+col42 CHAR(255),col43 CHAR(255),col44 CHAR(255),col45 CHAR(255),col46 CHAR(255), col47 CHAR(255),
+col48 CHAR(255),col49 CHAR(255),col50 CHAR(255),col51 CHAR(255),col52 CHAR(255), col53 CHAR(255),
+col54 CHAR(255),col55 CHAR(255),col56 CHAR(255),col57 CHAR(255),col58 CHAR(255), col59 CHAR(255),
+col60 CHAR(255),col61 CHAR(255),col62 CHAR(255),col63 CHAR(255),col64 CHAR(255), col65 CHAR(255))
+ENGINE = innodb ROW_FORMAT=REDUNDANT;
+ERROR 42000: Row size too large (> 16382). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
+show warnings;
+Level Code Message
+Error 1118 Row size too large (> 16382). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
+Warning 1030 Got error 139 "Too big row" from storage engine InnoDB
+CREATE TABLE t1 (
+c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
+c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
+c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
+c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
+c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
+c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
+c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
+c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
+c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
+c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
+c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
+c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
+c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
+c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
+c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
+c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
+c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
+c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
+c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
+c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
+c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
+c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
+c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
+c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
+c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
+c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
+c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
+c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
+c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
+c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
+c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
+c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
+c190 char(200), c191 char(200), c192 char(100),
+c81 char(156)
+) ROW_FORMAT=compact;
+DROP TABLE t1;
+CREATE TABLE t1 (
+c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
+c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
+c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
+c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
+c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
+c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
+c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
+c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
+c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
+c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
+c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
+c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
+c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
+c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
+c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
+c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
+c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
+c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
+c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
+c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
+c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
+c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
+c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
+c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
+c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
+c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
+c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
+c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
+c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
+c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
+c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
+c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
+c190 char(200), c191 char(200), c192 char(100),
+c81 char(157)
+) ROW_FORMAT=compact;
+ERROR 42000: Row size too large (> max_row_size). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
+CREATE TABLE t1 (
+c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
+c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
+c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
+c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
+c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
+c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
+c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
+c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
+c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
+c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
+c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
+c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
+c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
+c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
+c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
+c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
+c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
+c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
+c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
+c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
+c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
+c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
+c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
+c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
+c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
+c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
+c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
+c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
+c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
+c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
+c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
+c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
+c190 char(200), c191 char(200), c192 char(100),
+c81 char(156)
+) ROW_FORMAT=dynamic;
+DROP TABLE t1;
+CREATE TABLE t1 (
+c01 char(200), c02 char(200), c03 char(200), c04 char(200), c05 char(200),
+c06 char(200), c07 char(200), c08 char(200), c09 char(200), c10 char(200),
+c11 char(200), c12 char(200), c13 char(200), c14 char(200), c15 char(200),
+c16 char(200), c17 char(200), c18 char(200), c19 char(200), c20 char(200),
+c21 char(200), c22 char(200), c23 char(200), c24 char(200), c25 char(200),
+c26 char(200), c27 char(200), c28 char(200), c29 char(200), c30 char(200),
+c31 char(200), c32 char(200), c33 char(200), c34 char(200), c35 char(200),
+c36 char(200), c37 char(200), c38 char(200), c39 char(200), c40 char(200),
+c41 char(200), c42 char(200), c43 char(200), c44 char(200), c45 char(200),
+c46 char(200), c47 char(200), c48 char(200), c49 char(200), c50 char(200),
+c51 char(200), c52 char(200), c53 char(200), c54 char(200), c55 char(200),
+c56 char(200), c57 char(200), c58 char(200), c59 char(200), c60 char(200),
+c61 char(200), c62 char(200), c63 char(200), c64 char(200), c65 char(200),
+c66 char(200), c67 char(200), c68 char(200), c69 char(200), c70 char(200),
+c71 char(200), c72 char(200), c73 char(200), c74 char(200), c75 char(200),
+c76 char(200), c77 char(200), c78 char(200), c79 char(200), c80 char(200),
+c101 char(200), c102 char(200), c103 char(200), c104 char(200), c105 char(200),
+c106 char(200), c107 char(200), c108 char(200), c109 char(200), c110 char(200),
+c111 char(200), c112 char(200), c113 char(200), c114 char(200), c115 char(200),
+c116 char(200), c117 char(200), c118 char(200), c119 char(200), c120 char(200),
+c121 char(200), c122 char(200), c123 char(200), c124 char(200), c125 char(200),
+c126 char(200), c127 char(200), c128 char(200), c129 char(200), c130 char(200),
+c131 char(200), c132 char(200), c133 char(200), c134 char(200), c135 char(200),
+c136 char(200), c137 char(200), c138 char(200), c139 char(200), c140 char(200),
+c141 char(200), c142 char(200), c143 char(200), c144 char(200), c145 char(200),
+c146 char(200), c147 char(200), c148 char(200), c149 char(200), c150 char(200),
+c151 char(200), c152 char(200), c153 char(200), c154 char(200), c155 char(200),
+c156 char(200), c157 char(200), c158 char(200), c159 char(200), c160 char(200),
+c161 char(200), c162 char(200), c163 char(200), c164 char(200), c165 char(200),
+c166 char(200), c167 char(200), c168 char(200), c169 char(200), c170 char(200),
+c171 char(200), c172 char(200), c173 char(200), c174 char(200), c175 char(200),
+c176 char(200), c177 char(200), c178 char(200), c179 char(200), c180 char(200),
+c190 char(200), c191 char(200), c192 char(100),
+c81 char(157)
+) ROW_FORMAT=dynamic;
+ERROR 42000: Row size too large (> max_row_size). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
+# Test 8) Test creating a table that could lead to undo log overflow.
+CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
+h blob,i blob,j blob,k blob,l blob,m blob,n blob,
+o blob,p blob,q blob,r blob,s blob,t blob,u blob,
+v blob, w blob, x blob, y blob, z blob,
+aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob,
+ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob,
+oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob,
+va blob, wa blob, xa blob, ya blob, za blob,
+ab blob,bb blob,cb blob,db blob,eb blob,fb blob,gb blob,
+hb blob,ib blob,jb blob,kb blob,lb blob,mb blob,nb blob,
+ob blob,pb blob,qb blob,rb blob,sb blob,tb blob,ub blob,
+vb blob, wb blob, xb blob, yb blob, zb blob,
+ac blob, bc blob, cc blob, dc blob, ec blob,fc blob,gc blob,
+hc blob, ic blob, jc blob, kc blob, lc blob,mc blob,nc blob,
+oc blob, pc blob, qc blob, rc blob, sc blob,tc blob,uc blob,
+vc blob, wc blob, xc blob, yc blob, zc blob
+) ENGINE=InnoDB ROW_FORMAT=dynamic;
+SET @a = repeat('a', 767);
+SET @b = repeat('b', 767);
+SET @c = repeat('c', 767);
+SET @d = repeat('d', 767);
+SET @e = repeat('e', 767);
+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,
+@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a
+);
+UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
+k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b,
+v=@b,w=@b,x=@b,y=@b,z=@b,
+aa=@b,ba=@b,ca=@b,da=@b,ea=@b,fa=@b,ga=@b,ha=@b,ia=@b,ja=@b,
+ka=@b,la=@b,ma=@b,na=@b,oa=@b,pa=@b,qa=@b,ra=@b,sa=@b,ta=@b,ua=@b,
+va=@b,wa=@b,xa=@b,ya=@b,za=@b,
+ab=@b,bb=@b,cb=@b,db=@b,eb=@b,fb=@b,gb=@b,hb=@b,ib=@b,jb=@b,
+kb=@b,lb=@b,mb=@b,nb=@b,ob=@b,pb=@b,qb=@b,rb=@b,sb=@b,tb=@b,ub=@b,
+vb=@b,wb=@b,xb=@b,yb=@b,zb=@b,
+ab=@b,bb=@b,cb=@b,db=@b,eb=@b,fb=@b,gb=@b,hb=@b,ib=@b,jb=@b,
+kb=@b,lb=@b,mb=@b,nb=@b,ob=@b,pb=@b,qb=@b,rb=@b,sb=@b,tb=@b,ub=@b,
+vb=@b,wb=@b,xb=@b,yb=@b,zb=@b,
+ac=@b,bc=@b,cc=@b,dc=@b,ec=@b,fc=@b,gc=@b,hc=@b,ic=@b,jc=@b,
+kc=@b,lc=@b,mc=@b,nc=@b,oc=@b,pc=@b,qc=@b,rc=@b,sc=@b,tc=@b,uc=@b,
+vc=@b,wc=@b,xc=@b,yc=@b,zc=@b;
+CREATE INDEX t1a ON t1 (a(767),b(767));
+CREATE INDEX t1c ON t1 (c(767),d(767));
+CREATE INDEX t1e ON t1 (e(767),f(767));
+CREATE INDEX t1f2 ON t1 (g(767),h(767));
+CREATE INDEX t1f4 ON t1 (i(767),j(767));
+CREATE INDEX t1k ON t1 (k(767),m(767));
+CREATE INDEX t1f8 ON t1 (n(767),o(767));
+CREATE INDEX t1f11 ON t1 (p(767),q(767));
+CREATE INDEX t1f13 ON t1 (r(767),s(767));
+CREATE INDEX t1f15 ON t1 (t(767),u(767));
+CREATE INDEX t1f18 ON t1 (w(767),x(767));
+CREATE INDEX t1f20 ON t1 (y(767),z(767));
+CREATE INDEX ta1a6 ON t1 (aa(767),ba(767));
+CREATE INDEX tc1c6 ON t1 (ca(767),da(767));
+CREATE INDEX te1e6 ON t1 (ea(767),fa(767));
+UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
+k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c,
+v=@c,w=@c,x=@c,y=@c,z=@c,
+aa=@c,ba=@c,ca=@c,da=@c,ea=@c,fa=@c,ga=@c,ha=@c,ia=@c,ja=@c,
+ka=@c,la=@c,ma=@c,na=@c,oa=@c,pa=@c,qa=@c,ra=@c,sa=@c,ta=@c,ua=@c,
+va=@c,wa=@c,xa=@c,ya=@c,za=@c,
+ab=@c,bb=@c,cb=@c,db=@c,eb=@c,fb=@c,gb=@c,hb=@c,ib=@c,jb=@c,
+kb=@c,lb=@c,mb=@c,nb=@c,ob=@c,pb=@c,qb=@c,rb=@c,sb=@c,tb=@c,ub=@c,
+vb=@c,wb=@c,xb=@c,yb=@c,zb=@c,
+ac=@c,bc=@c,cc=@c,dc=@c,ec=@c,fc=@c,gc=@c,hc=@c,ic=@c,jc=@c,
+kc=@c,lc=@c,mc=@c,nc=@c,oc=@c,pc=@c,qc=@c,rc=@c,sc=@c,tc=@c,uc=@c,
+vc=@c,wc=@c,xc=@c,yc=@c,zc=@c;
+COMMIT;
+CREATE INDEX tg1f2 ON t1 (ia(767),ja(767));
+BEGIN;
+UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d,f=@d,g=@d,h=@d,i=@d,j=@d,
+k=@d,l=@d,m=@d,n=@d,o=@d,p=@d,q=@d,r=@d,s=@d,t=@d,u=@d,
+v=@d,w=@d,x=@d,y=@d,z=@d,
+aa=@d,ba=@d,ca=@d,da=@d,ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d,
+ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d,qa=@d,ra=@d,sa=@d,ta=@d,ua=@d,
+va=@d,wa=@d,xa=@d,ya=@d,za=@d,
+ab=@d,bb=@d,cb=@d,db=@d,eb=@d,fb=@d,gb=@d,hb=@d,ib=@d,jb=@d,
+kb=@d,lb=@d,mb=@d,nb=@d,ob=@d,pb=@d,qb=@d,rb=@d,sb=@d,tb=@d,ub=@d,
+vb=@d,wb=@d,xb=@d,yb=@d,zb=@d,
+ac=@d,bc=@d,cc=@d,dc=@d,ec=@d,fc=@d,gc=@d,hc=@d,ic=@d,jc=@d,
+kc=@d,lc=@d,mc=@d,nc=@d,oc=@d,pc=@d,qc=@d,rc=@d,sc=@d,tc=@d,uc=@d,
+vc=@d,wc=@d,xc=@d,yc=@d,zc=@d;
+ROLLBACK;
+BEGIN;
+UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
+UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d;
+UPDATE t1 SET k=@d,l=@d,m=@d,n=@d,o=@d;
+UPDATE t1 SET p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
+UPDATE t1 SET v=@d,w=@d,x=@d,y=@d,z=@d;
+UPDATE t1 SET aa=@d,ba=@d,ca=@d,da=@d;
+UPDATE t1 SET ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d;
+UPDATE t1 SET ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d;
+UPDATE t1 SET qa=@d,ra=@d,sa=@d,ta=@d,ua=@d;
+UPDATE t1 SET va=@d,wa=@d,xa=@d,ya=@d,za=@d;
+UPDATE t1 SET ab=@d,bb=@d,cb=@d,db=@d;
+UPDATE t1 SET eb=@d,fb=@d,gb=@d,hb=@d,ib=@d,ja=@d;
+UPDATE t1 SET kb=@d,lb=@d,mb=@d,nb=@d,ob=@d,pa=@d;
+UPDATE t1 SET qb=@d,rb=@d,sb=@d,tb=@d,ub=@d;
+UPDATE t1 SET vb=@d,wb=@d,xb=@d,yb=@d,zb=@d;
+UPDATE t1 SET ac=@d,bc=@d,cc=@d,dc=@d;
+UPDATE t1 SET ec=@d,fc=@d,gc=@d,hc=@d,ic=@d,jc=@d;
+UPDATE t1 SET kc=@d,lc=@d,mc=@d,nc=@d,oc=@d,pc=@d;
+UPDATE t1 SET qc=@d,rc=@d,sc=@d,tc=@d,uc=@d;
+UPDATE t1 SET vc=@d,wc=@d,xc=@d,yc=@d,zc=@d;
+COMMIT;
+CREATE INDEX ti1f4 ON t1 (ia(767),ka(767));
+CREATE INDEX tk1f6 ON t1 (la(767),ma(767));
+CREATE INDEX tm1f8 ON t1 (na(767),oa(767));
+CREATE INDEX to1f11 ON t1 (pa(767),qa(767));
+CREATE INDEX tq1f13 ON t1 (ra(767),sa(767));
+CREATE INDEX ts1f15 ON t1 (ta(767),ua(767));
+CREATE INDEX tu1f18 ON t1 (wa(767),xa(767));
+CREATE INDEX tx1f20 ON t1 (ya(767),za(767));
+CREATE INDEX ta1a5 ON t1 (ab(767),bb(767));
+CREATE INDEX tc1c5 ON t1 (cb(767),db(767));
+CREATE INDEX te1e5 ON t1 (eb(767),fb(767));
+CREATE INDEX t5g1f2 ON t1 (gb(767),hb(767));
+CREATE INDEX t5i1f4 ON t1 (ib(767),kb(767));
+CREATE INDEX t5k1f6 ON t1 (lb(767),mb(767));
+CREATE INDEX t5m1f8 ON t1 (nb(767),ob(767));
+CREATE INDEX t5o1f11 ON t1 (pb(767),qb(767));
+CREATE INDEX t65q1f13 ON t1 (rb(767),sb(767));
+CREATE INDEX t65s1f15 ON t1 (tb(767),ub(767));
+CREATE INDEX t65u1f18 ON t1 (wb(767),xb(767));
+CREATE INDEX t65x1f20 ON t1 (yb(767),zb(767));
+CREATE INDEX xta1a5 ON t1 (ac(767),bc(767));
+CREATE INDEX xt5g1f2 ON t1 (gc(767),hc(767));
+CREATE INDEX xt5i1f4 ON t1 (ic(767));
+CREATE INDEX xtc1c5 ON t1 (cc(767),dc(767));
+CREATE INDEX xte1e5 ON t1 (ec(767),fc(767));
+UPDATE t1 SET t=@e;
+CREATE INDEX xt5k1f6 ON t1 (lc(767),mc(767));
+SHOW CREATE TABLE t1;
+Table Create Table
+t1 CREATE TABLE `t1` (
+ `a` blob DEFAULT NULL,
+ `b` blob DEFAULT NULL,
+ `c` blob DEFAULT NULL,
+ `d` blob DEFAULT NULL,
+ `e` blob DEFAULT NULL,
+ `f` blob DEFAULT NULL,
+ `g` blob DEFAULT NULL,
+ `h` blob DEFAULT NULL,
+ `i` blob DEFAULT NULL,
+ `j` blob DEFAULT NULL,
+ `k` blob DEFAULT NULL,
+ `l` blob DEFAULT NULL,
+ `m` blob DEFAULT NULL,
+ `n` blob DEFAULT NULL,
+ `o` blob DEFAULT NULL,
+ `p` blob DEFAULT NULL,
+ `q` blob DEFAULT NULL,
+ `r` blob DEFAULT NULL,
+ `s` blob DEFAULT NULL,
+ `t` blob DEFAULT NULL,
+ `u` blob DEFAULT NULL,
+ `v` blob DEFAULT NULL,
+ `w` blob DEFAULT NULL,
+ `x` blob DEFAULT NULL,
+ `y` blob DEFAULT NULL,
+ `z` blob DEFAULT NULL,
+ `aa` blob DEFAULT NULL,
+ `ba` blob DEFAULT NULL,
+ `ca` blob DEFAULT NULL,
+ `da` blob DEFAULT NULL,
+ `ea` blob DEFAULT NULL,
+ `fa` blob DEFAULT NULL,
+ `ga` blob DEFAULT NULL,
+ `ha` blob DEFAULT NULL,
+ `ia` blob DEFAULT NULL,
+ `ja` blob DEFAULT NULL,
+ `ka` blob DEFAULT NULL,
+ `la` blob DEFAULT NULL,
+ `ma` blob DEFAULT NULL,
+ `na` blob DEFAULT NULL,
+ `oa` blob DEFAULT NULL,
+ `pa` blob DEFAULT NULL,
+ `qa` blob DEFAULT NULL,
+ `ra` blob DEFAULT NULL,
+ `sa` blob DEFAULT NULL,
+ `ta` blob DEFAULT NULL,
+ `ua` blob DEFAULT NULL,
+ `va` blob DEFAULT NULL,
+ `wa` blob DEFAULT NULL,
+ `xa` blob DEFAULT NULL,
+ `ya` blob DEFAULT NULL,
+ `za` blob DEFAULT NULL,
+ `ab` blob DEFAULT NULL,
+ `bb` blob DEFAULT NULL,
+ `cb` blob DEFAULT NULL,
+ `db` blob DEFAULT NULL,
+ `eb` blob DEFAULT NULL,
+ `fb` blob DEFAULT NULL,
+ `gb` blob DEFAULT NULL,
+ `hb` blob DEFAULT NULL,
+ `ib` blob DEFAULT NULL,
+ `jb` blob DEFAULT NULL,
+ `kb` blob DEFAULT NULL,
+ `lb` blob DEFAULT NULL,
+ `mb` blob DEFAULT NULL,
+ `nb` blob DEFAULT NULL,
+ `ob` blob DEFAULT NULL,
+ `pb` blob DEFAULT NULL,
+ `qb` blob DEFAULT NULL,
+ `rb` blob DEFAULT NULL,
+ `sb` blob DEFAULT NULL,
+ `tb` blob DEFAULT NULL,
+ `ub` blob DEFAULT NULL,
+ `vb` blob DEFAULT NULL,
+ `wb` blob DEFAULT NULL,
+ `xb` blob DEFAULT NULL,
+ `yb` blob DEFAULT NULL,
+ `zb` blob DEFAULT NULL,
+ `ac` blob DEFAULT NULL,
+ `bc` blob DEFAULT NULL,
+ `cc` blob DEFAULT NULL,
+ `dc` blob DEFAULT NULL,
+ `ec` blob DEFAULT NULL,
+ `fc` blob DEFAULT NULL,
+ `gc` blob DEFAULT NULL,
+ `hc` blob DEFAULT NULL,
+ `ic` blob DEFAULT NULL,
+ `jc` blob DEFAULT NULL,
+ `kc` blob DEFAULT NULL,
+ `lc` blob DEFAULT NULL,
+ `mc` blob DEFAULT NULL,
+ `nc` blob DEFAULT NULL,
+ `oc` blob DEFAULT NULL,
+ `pc` blob DEFAULT NULL,
+ `qc` blob DEFAULT NULL,
+ `rc` blob DEFAULT NULL,
+ `sc` blob DEFAULT NULL,
+ `tc` blob DEFAULT NULL,
+ `uc` blob DEFAULT NULL,
+ `vc` blob DEFAULT NULL,
+ `wc` blob DEFAULT NULL,
+ `xc` blob DEFAULT NULL,
+ `yc` blob DEFAULT NULL,
+ `zc` blob DEFAULT NULL,
+ KEY `t1a` (`a`(767),`b`(767)),
+ KEY `t1c` (`c`(767),`d`(767)),
+ KEY `t1e` (`e`(767),`f`(767)),
+ KEY `t1f2` (`g`(767),`h`(767)),
+ KEY `t1f4` (`i`(767),`j`(767)),
+ KEY `t1k` (`k`(767),`m`(767)),
+ KEY `t1f8` (`n`(767),`o`(767)),
+ KEY `t1f11` (`p`(767),`q`(767)),
+ KEY `t1f13` (`r`(767),`s`(767)),
+ KEY `t1f15` (`t`(767),`u`(767)),
+ KEY `t1f18` (`w`(767),`x`(767)),
+ KEY `t1f20` (`y`(767),`z`(767)),
+ KEY `ta1a6` (`aa`(767),`ba`(767)),
+ KEY `tc1c6` (`ca`(767),`da`(767)),
+ KEY `te1e6` (`ea`(767),`fa`(767)),
+ KEY `tg1f2` (`ia`(767),`ja`(767)),
+ KEY `ti1f4` (`ia`(767),`ka`(767)),
+ KEY `tk1f6` (`la`(767),`ma`(767)),
+ KEY `tm1f8` (`na`(767),`oa`(767)),
+ KEY `to1f11` (`pa`(767),`qa`(767)),
+ KEY `tq1f13` (`ra`(767),`sa`(767)),
+ KEY `ts1f15` (`ta`(767),`ua`(767)),
+ KEY `tu1f18` (`wa`(767),`xa`(767)),
+ KEY `tx1f20` (`ya`(767),`za`(767)),
+ KEY `ta1a5` (`ab`(767),`bb`(767)),
+ KEY `tc1c5` (`cb`(767),`db`(767)),
+ KEY `te1e5` (`eb`(767),`fb`(767)),
+ KEY `t5g1f2` (`gb`(767),`hb`(767)),
+ KEY `t5i1f4` (`ib`(767),`kb`(767)),
+ KEY `t5k1f6` (`lb`(767),`mb`(767)),
+ KEY `t5m1f8` (`nb`(767),`ob`(767)),
+ KEY `t5o1f11` (`pb`(767),`qb`(767)),
+ KEY `t65q1f13` (`rb`(767),`sb`(767)),
+ KEY `t65s1f15` (`tb`(767),`ub`(767)),
+ KEY `t65u1f18` (`wb`(767),`xb`(767)),
+ KEY `t65x1f20` (`yb`(767),`zb`(767)),
+ KEY `xta1a5` (`ac`(767),`bc`(767)),
+ KEY `xt5g1f2` (`gc`(767),`hc`(767)),
+ KEY `xt5i1f4` (`ic`(767)),
+ KEY `xtc1c5` (`cc`(767),`dc`(767)),
+ KEY `xte1e5` (`ec`(767),`fc`(767)),
+ KEY `xt5k1f6` (`lc`(767),`mc`(767))
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
+SHOW WARNINGS;
+Level Code Message
+CREATE TABLE t2(COL1 TEXT,
+COL2 TEXT,
+COL3 TEXT,
+COL4 TEXT,
+COL5 TEXT,
+COL6 TEXT,
+COL7 TEXT,
+COL8 TEXT,
+COL9 TEXT,
+COL10 TEXT,
+COL11 TEXT,
+COL12 TEXT,
+COL13 TEXT,
+COL14 TEXT,
+COL15 TEXT,
+COL16 TEXT,
+COL17 TEXT,
+COL18 TEXT,
+COL19 TEXT,
+COL20 TEXT,
+COL21 TEXT,
+COL22 TEXT,
+COL23 TEXT,
+COL24 TEXT,
+COL25 TEXT,
+COL26 TEXT,
+COL27 TEXT,
+COL28 TEXT,
+COL29 TEXT,
+COL30 TEXT,
+COL31 TEXT,
+COL32 TEXT,
+COL33 TEXT,
+COL34 TEXT,
+COL35 TEXT,
+COL36 TEXT,
+COL37 TEXT,
+COL38 TEXT,
+COL39 TEXT,
+COL40 TEXT,
+COL41 TEXT,
+COL42 TEXT,
+COL43 TEXT,
+COL44 TEXT,
+COL45 TEXT,
+COL46 TEXT,
+COL47 TEXT,
+COL48 TEXT,
+COL49 TEXT,
+COL50 TEXT,
+COL51 TEXT,
+COL52 TEXT,
+COL53 TEXT,
+COL54 TEXT,
+COL55 TEXT,
+COL56 TEXT,
+COL57 TEXT,
+COL58 TEXT,
+COL59 TEXT,
+COL60 TEXT,
+COL61 TEXT,
+COL62 TEXT,
+COL63 TEXT,
+COL64 TEXT,
+COL65 TEXT,
+COL66 TEXT,
+COL67 TEXT,
+COL68 TEXT,
+COL69 TEXT,
+COL70 TEXT,
+COL71 TEXT,
+COL72 TEXT,
+COL73 TEXT,
+COL74 TEXT,
+COL75 TEXT,
+COL76 TEXT,
+COL77 TEXT,
+COL78 TEXT,
+COL79 TEXT,
+COL80 TEXT,
+COL81 TEXT,
+COL82 TEXT,
+COL83 TEXT,
+COL84 TEXT,
+COL85 TEXT,
+COL86 TEXT,
+COL87 TEXT,
+COL88 TEXT,
+COL89 TEXT,
+COL90 TEXT,
+COL91 TEXT,
+COL92 TEXT,
+COL93 TEXT,
+COL94 TEXT,
+COL95 TEXT,
+COL96 TEXT,
+COL97 TEXT,
+COL98 TEXT,
+COL99 TEXT,
+COL100 TEXT,
+COL101 TEXT,
+COL102 TEXT,
+COL103 TEXT,
+COL104 TEXT,
+COL105 TEXT,
+COL106 TEXT,
+COL107 TEXT,
+COL108 TEXT,
+COL109 TEXT,
+COL110 TEXT,
+COL111 TEXT,
+COL112 TEXT,
+COL113 TEXT,
+COL114 TEXT,
+COL115 TEXT,
+COL116 TEXT,
+COL117 TEXT,
+COL118 TEXT,
+COL119 TEXT,
+COL120 TEXT,
+COL121 TEXT,
+COL122 TEXT,
+COL123 TEXT,
+COL124 TEXT,
+COL125 TEXT,
+COL126 TEXT,
+COL127 TEXT,
+COL128 TEXT,
+COL129 TEXT,
+COL130 TEXT,
+COL131 TEXT,
+COL132 TEXT,
+COL133 TEXT,
+COL134 TEXT,
+COL135 TEXT,
+COL136 TEXT,
+COL137 TEXT,
+COL138 TEXT,
+COL139 TEXT,
+COL140 TEXT,
+COL141 TEXT,
+COL142 TEXT,
+COL143 TEXT,
+COL144 TEXT,
+COL145 TEXT,
+COL146 TEXT,
+COL147 TEXT,
+COL148 TEXT,
+COL149 TEXT,
+COL150 TEXT,
+COL151 TEXT,
+COL152 TEXT,
+COL153 TEXT,
+COL154 TEXT,
+COL155 TEXT,
+COL156 TEXT,
+COL157 TEXT,
+COL158 TEXT,
+COL159 TEXT,
+COL160 TEXT,
+COL161 TEXT,
+COL162 TEXT,
+COL163 TEXT,
+COL164 TEXT,
+COL165 TEXT,
+COL166 TEXT,
+COL167 TEXT,
+COL168 TEXT,
+COL169 TEXT,
+COL170 TEXT,
+COL171 TEXT,
+COL172 TEXT,
+COL173 TEXT,
+COL174 TEXT,
+COL175 TEXT,
+COL176 TEXT,
+COL177 TEXT,
+COL178 TEXT,
+COL179 TEXT,
+COL180 TEXT,
+COL181 TEXT,
+COL182 TEXT,
+COL183 TEXT,
+COL184 TEXT,
+COL185 TEXT,
+COL186 TEXT,
+COL187 TEXT,
+COL188 TEXT,
+COL189 TEXT,
+COL190 TEXT,
+COL191 TEXT,
+COL192 TEXT,
+COL193 TEXT,
+COL194 TEXT,
+COL195 TEXT,
+COL196 TEXT,
+COL197 TEXT)
+row_format=dynamic,ENGINE=INNODB;
+set @a = repeat('0123456789', 800);
+set @b = repeat('9876543210', 800);
+insert into t2 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,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a);
+update t2 set col190=@b;
+set @a = repeat('0123456789', 1650);
+set @b = repeat('9876543210', 2000);
+insert into t2 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,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,
+@a,@a,@a,@a,@a,@a,@a);
+update t2 set col190=@b;
+# restart
+set @a = repeat('abcdefghijklmnopqrstuvwxyz', 1650);
+set @b = repeat('zyxwvutsrqponmlkjihgfedcba', 2000);
+update t2 set col189 = @b;
+insert into t2 select * from t2;
+show create table t1;
+Table Create Table
+t1 CREATE TABLE `t1` (
+ `a` blob DEFAULT NULL,
+ `b` blob DEFAULT NULL,
+ `c` blob DEFAULT NULL,
+ `d` blob DEFAULT NULL,
+ `e` blob DEFAULT NULL,
+ `f` blob DEFAULT NULL,
+ `g` blob DEFAULT NULL,
+ `h` blob DEFAULT NULL,
+ `i` blob DEFAULT NULL,
+ `j` blob DEFAULT NULL,
+ `k` blob DEFAULT NULL,
+ `l` blob DEFAULT NULL,
+ `m` blob DEFAULT NULL,
+ `n` blob DEFAULT NULL,
+ `o` blob DEFAULT NULL,
+ `p` blob DEFAULT NULL,
+ `q` blob DEFAULT NULL,
+ `r` blob DEFAULT NULL,
+ `s` blob DEFAULT NULL,
+ `t` blob DEFAULT NULL,
+ `u` blob DEFAULT NULL,
+ `v` blob DEFAULT NULL,
+ `w` blob DEFAULT NULL,
+ `x` blob DEFAULT NULL,
+ `y` blob DEFAULT NULL,
+ `z` blob DEFAULT NULL,
+ `aa` blob DEFAULT NULL,
+ `ba` blob DEFAULT NULL,
+ `ca` blob DEFAULT NULL,
+ `da` blob DEFAULT NULL,
+ `ea` blob DEFAULT NULL,
+ `fa` blob DEFAULT NULL,
+ `ga` blob DEFAULT NULL,
+ `ha` blob DEFAULT NULL,
+ `ia` blob DEFAULT NULL,
+ `ja` blob DEFAULT NULL,
+ `ka` blob DEFAULT NULL,
+ `la` blob DEFAULT NULL,
+ `ma` blob DEFAULT NULL,
+ `na` blob DEFAULT NULL,
+ `oa` blob DEFAULT NULL,
+ `pa` blob DEFAULT NULL,
+ `qa` blob DEFAULT NULL,
+ `ra` blob DEFAULT NULL,
+ `sa` blob DEFAULT NULL,
+ `ta` blob DEFAULT NULL,
+ `ua` blob DEFAULT NULL,
+ `va` blob DEFAULT NULL,
+ `wa` blob DEFAULT NULL,
+ `xa` blob DEFAULT NULL,
+ `ya` blob DEFAULT NULL,
+ `za` blob DEFAULT NULL,
+ `ab` blob DEFAULT NULL,
+ `bb` blob DEFAULT NULL,
+ `cb` blob DEFAULT NULL,
+ `db` blob DEFAULT NULL,
+ `eb` blob DEFAULT NULL,
+ `fb` blob DEFAULT NULL,
+ `gb` blob DEFAULT NULL,
+ `hb` blob DEFAULT NULL,
+ `ib` blob DEFAULT NULL,
+ `jb` blob DEFAULT NULL,
+ `kb` blob DEFAULT NULL,
+ `lb` blob DEFAULT NULL,
+ `mb` blob DEFAULT NULL,
+ `nb` blob DEFAULT NULL,
+ `ob` blob DEFAULT NULL,
+ `pb` blob DEFAULT NULL,
+ `qb` blob DEFAULT NULL,
+ `rb` blob DEFAULT NULL,
+ `sb` blob DEFAULT NULL,
+ `tb` blob DEFAULT NULL,
+ `ub` blob DEFAULT NULL,
+ `vb` blob DEFAULT NULL,
+ `wb` blob DEFAULT NULL,
+ `xb` blob DEFAULT NULL,
+ `yb` blob DEFAULT NULL,
+ `zb` blob DEFAULT NULL,
+ `ac` blob DEFAULT NULL,
+ `bc` blob DEFAULT NULL,
+ `cc` blob DEFAULT NULL,
+ `dc` blob DEFAULT NULL,
+ `ec` blob DEFAULT NULL,
+ `fc` blob DEFAULT NULL,
+ `gc` blob DEFAULT NULL,
+ `hc` blob DEFAULT NULL,
+ `ic` blob DEFAULT NULL,
+ `jc` blob DEFAULT NULL,
+ `kc` blob DEFAULT NULL,
+ `lc` blob DEFAULT NULL,
+ `mc` blob DEFAULT NULL,
+ `nc` blob DEFAULT NULL,
+ `oc` blob DEFAULT NULL,
+ `pc` blob DEFAULT NULL,
+ `qc` blob DEFAULT NULL,
+ `rc` blob DEFAULT NULL,
+ `sc` blob DEFAULT NULL,
+ `tc` blob DEFAULT NULL,
+ `uc` blob DEFAULT NULL,
+ `vc` blob DEFAULT NULL,
+ `wc` blob DEFAULT NULL,
+ `xc` blob DEFAULT NULL,
+ `yc` blob DEFAULT NULL,
+ `zc` blob DEFAULT NULL,
+ KEY `t1a` (`a`(767),`b`(767)),
+ KEY `t1c` (`c`(767),`d`(767)),
+ KEY `t1e` (`e`(767),`f`(767)),
+ KEY `t1f2` (`g`(767),`h`(767)),
+ KEY `t1f4` (`i`(767),`j`(767)),
+ KEY `t1k` (`k`(767),`m`(767)),
+ KEY `t1f8` (`n`(767),`o`(767)),
+ KEY `t1f11` (`p`(767),`q`(767)),
+ KEY `t1f13` (`r`(767),`s`(767)),
+ KEY `t1f15` (`t`(767),`u`(767)),
+ KEY `t1f18` (`w`(767),`x`(767)),
+ KEY `t1f20` (`y`(767),`z`(767)),
+ KEY `ta1a6` (`aa`(767),`ba`(767)),
+ KEY `tc1c6` (`ca`(767),`da`(767)),
+ KEY `te1e6` (`ea`(767),`fa`(767)),
+ KEY `tg1f2` (`ia`(767),`ja`(767)),
+ KEY `ti1f4` (`ia`(767),`ka`(767)),
+ KEY `tk1f6` (`la`(767),`ma`(767)),
+ KEY `tm1f8` (`na`(767),`oa`(767)),
+ KEY `to1f11` (`pa`(767),`qa`(767)),
+ KEY `tq1f13` (`ra`(767),`sa`(767)),
+ KEY `ts1f15` (`ta`(767),`ua`(767)),
+ KEY `tu1f18` (`wa`(767),`xa`(767)),
+ KEY `tx1f20` (`ya`(767),`za`(767)),
+ KEY `ta1a5` (`ab`(767),`bb`(767)),
+ KEY `tc1c5` (`cb`(767),`db`(767)),
+ KEY `te1e5` (`eb`(767),`fb`(767)),
+ KEY `t5g1f2` (`gb`(767),`hb`(767)),
+ KEY `t5i1f4` (`ib`(767),`kb`(767)),
+ KEY `t5k1f6` (`lb`(767),`mb`(767)),
+ KEY `t5m1f8` (`nb`(767),`ob`(767)),
+ KEY `t5o1f11` (`pb`(767),`qb`(767)),
+ KEY `t65q1f13` (`rb`(767),`sb`(767)),
+ KEY `t65s1f15` (`tb`(767),`ub`(767)),
+ KEY `t65u1f18` (`wb`(767),`xb`(767)),
+ KEY `t65x1f20` (`yb`(767),`zb`(767)),
+ KEY `xta1a5` (`ac`(767),`bc`(767)),
+ KEY `xt5g1f2` (`gc`(767),`hc`(767)),
+ KEY `xt5i1f4` (`ic`(767)),
+ KEY `xtc1c5` (`cc`(767),`dc`(767)),
+ KEY `xte1e5` (`ec`(767),`fc`(767)),
+ KEY `xt5k1f6` (`lc`(767),`mc`(767))
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
+show create table t2;
+Table Create Table
+t2 CREATE TABLE `t2` (
+ `COL1` text DEFAULT NULL,
+ `COL2` text DEFAULT NULL,
+ `COL3` text DEFAULT NULL,
+ `COL4` text DEFAULT NULL,
+ `COL5` text DEFAULT NULL,
+ `COL6` text DEFAULT NULL,
+ `COL7` text DEFAULT NULL,
+ `COL8` text DEFAULT NULL,
+ `COL9` text DEFAULT NULL,
+ `COL10` text DEFAULT NULL,
+ `COL11` text DEFAULT NULL,
+ `COL12` text DEFAULT NULL,
+ `COL13` text DEFAULT NULL,
+ `COL14` text DEFAULT NULL,
+ `COL15` text DEFAULT NULL,
+ `COL16` text DEFAULT NULL,
+ `COL17` text DEFAULT NULL,
+ `COL18` text DEFAULT NULL,
+ `COL19` text DEFAULT NULL,
+ `COL20` text DEFAULT NULL,
+ `COL21` text DEFAULT NULL,
+ `COL22` text DEFAULT NULL,
+ `COL23` text DEFAULT NULL,
+ `COL24` text DEFAULT NULL,
+ `COL25` text DEFAULT NULL,
+ `COL26` text DEFAULT NULL,
+ `COL27` text DEFAULT NULL,
+ `COL28` text DEFAULT NULL,
+ `COL29` text DEFAULT NULL,
+ `COL30` text DEFAULT NULL,
+ `COL31` text DEFAULT NULL,
+ `COL32` text DEFAULT NULL,
+ `COL33` text DEFAULT NULL,
+ `COL34` text DEFAULT NULL,
+ `COL35` text DEFAULT NULL,
+ `COL36` text DEFAULT NULL,
+ `COL37` text DEFAULT NULL,
+ `COL38` text DEFAULT NULL,
+ `COL39` text DEFAULT NULL,
+ `COL40` text DEFAULT NULL,
+ `COL41` text DEFAULT NULL,
+ `COL42` text DEFAULT NULL,
+ `COL43` text DEFAULT NULL,
+ `COL44` text DEFAULT NULL,
+ `COL45` text DEFAULT NULL,
+ `COL46` text DEFAULT NULL,
+ `COL47` text DEFAULT NULL,
+ `COL48` text DEFAULT NULL,
+ `COL49` text DEFAULT NULL,
+ `COL50` text DEFAULT NULL,
+ `COL51` text DEFAULT NULL,
+ `COL52` text DEFAULT NULL,
+ `COL53` text DEFAULT NULL,
+ `COL54` text DEFAULT NULL,
+ `COL55` text DEFAULT NULL,
+ `COL56` text DEFAULT NULL,
+ `COL57` text DEFAULT NULL,
+ `COL58` text DEFAULT NULL,
+ `COL59` text DEFAULT NULL,
+ `COL60` text DEFAULT NULL,
+ `COL61` text DEFAULT NULL,
+ `COL62` text DEFAULT NULL,
+ `COL63` text DEFAULT NULL,
+ `COL64` text DEFAULT NULL,
+ `COL65` text DEFAULT NULL,
+ `COL66` text DEFAULT NULL,
+ `COL67` text DEFAULT NULL,
+ `COL68` text DEFAULT NULL,
+ `COL69` text DEFAULT NULL,
+ `COL70` text DEFAULT NULL,
+ `COL71` text DEFAULT NULL,
+ `COL72` text DEFAULT NULL,
+ `COL73` text DEFAULT NULL,
+ `COL74` text DEFAULT NULL,
+ `COL75` text DEFAULT NULL,
+ `COL76` text DEFAULT NULL,
+ `COL77` text DEFAULT NULL,
+ `COL78` text DEFAULT NULL,
+ `COL79` text DEFAULT NULL,
+ `COL80` text DEFAULT NULL,
+ `COL81` text DEFAULT NULL,
+ `COL82` text DEFAULT NULL,
+ `COL83` text DEFAULT NULL,
+ `COL84` text DEFAULT NULL,
+ `COL85` text DEFAULT NULL,
+ `COL86` text DEFAULT NULL,
+ `COL87` text DEFAULT NULL,
+ `COL88` text DEFAULT NULL,
+ `COL89` text DEFAULT NULL,
+ `COL90` text DEFAULT NULL,
+ `COL91` text DEFAULT NULL,
+ `COL92` text DEFAULT NULL,
+ `COL93` text DEFAULT NULL,
+ `COL94` text DEFAULT NULL,
+ `COL95` text DEFAULT NULL,
+ `COL96` text DEFAULT NULL,
+ `COL97` text DEFAULT NULL,
+ `COL98` text DEFAULT NULL,
+ `COL99` text DEFAULT NULL,
+ `COL100` text DEFAULT NULL,
+ `COL101` text DEFAULT NULL,
+ `COL102` text DEFAULT NULL,
+ `COL103` text DEFAULT NULL,
+ `COL104` text DEFAULT NULL,
+ `COL105` text DEFAULT NULL,
+ `COL106` text DEFAULT NULL,
+ `COL107` text DEFAULT NULL,
+ `COL108` text DEFAULT NULL,
+ `COL109` text DEFAULT NULL,
+ `COL110` text DEFAULT NULL,
+ `COL111` text DEFAULT NULL,
+ `COL112` text DEFAULT NULL,
+ `COL113` text DEFAULT NULL,
+ `COL114` text DEFAULT NULL,
+ `COL115` text DEFAULT NULL,
+ `COL116` text DEFAULT NULL,
+ `COL117` text DEFAULT NULL,
+ `COL118` text DEFAULT NULL,
+ `COL119` text DEFAULT NULL,
+ `COL120` text DEFAULT NULL,
+ `COL121` text DEFAULT NULL,
+ `COL122` text DEFAULT NULL,
+ `COL123` text DEFAULT NULL,
+ `COL124` text DEFAULT NULL,
+ `COL125` text DEFAULT NULL,
+ `COL126` text DEFAULT NULL,
+ `COL127` text DEFAULT NULL,
+ `COL128` text DEFAULT NULL,
+ `COL129` text DEFAULT NULL,
+ `COL130` text DEFAULT NULL,
+ `COL131` text DEFAULT NULL,
+ `COL132` text DEFAULT NULL,
+ `COL133` text DEFAULT NULL,
+ `COL134` text DEFAULT NULL,
+ `COL135` text DEFAULT NULL,
+ `COL136` text DEFAULT NULL,
+ `COL137` text DEFAULT NULL,
+ `COL138` text DEFAULT NULL,
+ `COL139` text DEFAULT NULL,
+ `COL140` text DEFAULT NULL,
+ `COL141` text DEFAULT NULL,
+ `COL142` text DEFAULT NULL,
+ `COL143` text DEFAULT NULL,
+ `COL144` text DEFAULT NULL,
+ `COL145` text DEFAULT NULL,
+ `COL146` text DEFAULT NULL,
+ `COL147` text DEFAULT NULL,
+ `COL148` text DEFAULT NULL,
+ `COL149` text DEFAULT NULL,
+ `COL150` text DEFAULT NULL,
+ `COL151` text DEFAULT NULL,
+ `COL152` text DEFAULT NULL,
+ `COL153` text DEFAULT NULL,
+ `COL154` text DEFAULT NULL,
+ `COL155` text DEFAULT NULL,
+ `COL156` text DEFAULT NULL,
+ `COL157` text DEFAULT NULL,
+ `COL158` text DEFAULT NULL,
+ `COL159` text DEFAULT NULL,
+ `COL160` text DEFAULT NULL,
+ `COL161` text DEFAULT NULL,
+ `COL162` text DEFAULT NULL,
+ `COL163` text DEFAULT NULL,
+ `COL164` text DEFAULT NULL,
+ `COL165` text DEFAULT NULL,
+ `COL166` text DEFAULT NULL,
+ `COL167` text DEFAULT NULL,
+ `COL168` text DEFAULT NULL,
+ `COL169` text DEFAULT NULL,
+ `COL170` text DEFAULT NULL,
+ `COL171` text DEFAULT NULL,
+ `COL172` text DEFAULT NULL,
+ `COL173` text DEFAULT NULL,
+ `COL174` text DEFAULT NULL,
+ `COL175` text DEFAULT NULL,
+ `COL176` text DEFAULT NULL,
+ `COL177` text DEFAULT NULL,
+ `COL178` text DEFAULT NULL,
+ `COL179` text DEFAULT NULL,
+ `COL180` text DEFAULT NULL,
+ `COL181` text DEFAULT NULL,
+ `COL182` text DEFAULT NULL,
+ `COL183` text DEFAULT NULL,
+ `COL184` text DEFAULT NULL,
+ `COL185` text DEFAULT NULL,
+ `COL186` text DEFAULT NULL,
+ `COL187` text DEFAULT NULL,
+ `COL188` text DEFAULT NULL,
+ `COL189` text DEFAULT NULL,
+ `COL190` text DEFAULT NULL,
+ `COL191` text DEFAULT NULL,
+ `COL192` text DEFAULT NULL,
+ `COL193` text DEFAULT NULL,
+ `COL194` text DEFAULT NULL,
+ `COL195` text DEFAULT NULL,
+ `COL196` text DEFAULT NULL,
+ `COL197` text DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC
+BEGIN;
+update t2 set col150=@a;
+update t2 set col145=@b;
+COMMIT;
+drop table t2;
+DROP TABLE t1;
+#
+# MDEV-19526/MDEV-29742 heap number overflow
+#
+CREATE TABLE t1(a SMALLINT NOT NULL UNIQUE AUTO_INCREMENT, KEY(a))
+ENGINE=InnoDB;
+INSERT INTO t1 (a) SELECT seq FROM seq_1_to_8191;
+ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
+DROP TABLE t1;
+# End of 10.3 tests
generated by cgit v1.2.3 (git 2.39.1) at 2024-12-30 02:14:34 +0000