Debian Codegraph @

mysql-test/suite/innodb/t/lob_recovery.test

raw
1 --source include/have_innodb_16k.inc
2
3 --echo #
4 --echo # Bug #33454557 Innodb asserts due to corruption in the fsp layer while
5 --echo # running MTR tests
6 --echo #
7
8 set @s:=concat("CREATE TABLE t(a LONGBLOB GENERATED ALWAYS AS
9 ('",REPEAT("a",1024*1024),"') STORED) ENGINE=INNODB;");
10 PREPARE r FROM @s;
11 EXECUTE r;
12 DEALLOCATE PREPARE r;
13
14 DROP TABLE t;
15
16 set @s:=concat("CREATE TABLE t(w INT, A INT GENERATED ALWAYS
17 AS('",REPEAT("\\0",1024*1024),"') STORED) ENGINE=INNODB;");
18 PREPARE r FROM @s;
19 EXECUTE r;
20 DEALLOCATE PREPARE r;
21
22 DROP TABLE t;
23
24 --source include/kill_and_restart_mysqld.inc
25
26 CREATE TABLE `ibstd_02` (
27 `a` int NOT NULL,
28 `d` int NOT NULL,
29 `b` varchar(198) NOT NULL,
30 `c` char(94) DEFAULT NULL,
31 `nc02614` blob,
32 `nc07663` decimal(10,0) NOT NULL,
33 `nc02836` int DEFAULT NULL,
34 `nc06406` bigint NOT NULL,
35 `nc08713` mediumtext,
36 `nc00159` char(9) DEFAULT NULL,
37 `nc03394` varchar(198) NOT NULL,
38 `nc09912` int DEFAULT NULL,
39 `nc04074` mediumtext NOT NULL,
40 `gc06942` geometry DEFAULT NULL,
41 `nc01416` decimal(10,0) DEFAULT '-62775914',
42 `nc02900` mediumtext,
43 `nc01060` int NOT NULL,
44 `nc09703` double DEFAULT NULL,
45 `nc02361` char(19) DEFAULT NULL,
46 `nc09146` tinytext NOT NULL,
47 `nc01349` tinytext,
48 `nc05115` varchar(83) DEFAULT NULL,
49 `nc01550` blob,
50 `nc01963` tinyint DEFAULT NULL,
51 `nc03089` tinyint DEFAULT NULL,
52 `nc03917` bigint NOT NULL,
53 `nc00433` tinytext,
54 `nc00080` tinytext,
55 `nc03787` decimal(10,0) NOT NULL DEFAULT '-116224180',
56 `nc04351` int NOT NULL,
57 `nc05428` longblob,
58 `nc02756` bigint DEFAULT '-7995081',
59 `nc01152` double NOT NULL,
60 `nc07297` decimal(10,0) NOT NULL,
61 `nc07970` tinytext NOT NULL,
62 `nc07670` varchar(239) DEFAULT '5dgword0.7621719722386470.227883050724099',
63 `nc06861` tinyint NOT NULL,
64 `nc08265` char(23) NOT NULL,
65 `nc09700` longblob NOT NULL,
66 `nc06366` decimal(10,0) DEFAULT '1744702',
67 `nc03517` bigint NOT NULL DEFAULT '-109091878',
68 `nc06783` double NOT NULL,
69 `nc09164` char(21) DEFAULT NULL,
70 `nc00539` blob,
71 `nc05630` varchar(111) NOT NULL,
72 `nc01824` varchar(411) NOT NULL DEFAULT '0.2748128049709210.5692422509033510.0247909802167818',
73 `nc07849` longblob NOT NULL,
74 `nc02543` tinyint DEFAULT NULL,
75 `nc06790` double DEFAULT NULL,
76 `nc08367` varchar(40) DEFAULT '0.678796587967447',
77 `nc04269` mediumtext,
78 `nc01684` char(21) NOT NULL,
79 `nc09725` decimal(10,0) DEFAULT NULL,
80 `nc06545` bigint DEFAULT NULL,
81 `nc08187` varchar(232) DEFAULT NULL,
82 `gc05904` multipoint DEFAULT NULL,
83 `nc03479` longblob,
84 `nc06046` tinyint DEFAULT NULL,
85 `nc01036` decimal(10,0) NOT NULL DEFAULT '-7530867',
86 `nc00735` tinyint DEFAULT NULL,
87 `nc09430` varchar(117) DEFAULT NULL,
88 `nc02844` blob NOT NULL,
89 `nc00023` tinytext,
90 `nc03094` tinyint DEFAULT NULL,
91 `nc03312` tinytext NOT NULL,
92 `nc03475` tinytext,
93 `nc02475` mediumtext NOT NULL,
94 `nc01252` decimal(10,0) NOT NULL DEFAULT '8615274',
95 `nc01020` longblob NOT NULL,
96 `nc04131` mediumtext NOT NULL,
97 `nc05027` mediumtext,
98 `nc02184` double NOT NULL,
99 `nc07416` double DEFAULT NULL,
100 `nc04127` varchar(135) DEFAULT NULL,
101 `nc06159` longblob,
102 `nc01122` int DEFAULT NULL,
103 `nc01409` blob,
104 `nc01326` decimal(10,0) NOT NULL,
105 `nc03458` decimal(10,0) DEFAULT NULL,
106 `nc03327` bigint NOT NULL,
107 `nc00834` tinytext,
108 `nc07637` bigint DEFAULT '-125873342',
109 `nc07289` mediumtext NOT NULL,
110 `nc00110` int NOT NULL,
111 `nc09363` varchar(389) DEFAULT NULL,
112 `nc02046` tinytext,
113 `nc04790` bigint NOT NULL DEFAULT '81062191',
114 `nc03499` tinyint NOT NULL DEFAULT '-100',
115 `nc05566` decimal(10,0) DEFAULT NULL,
116 `nc01148` tinyint NOT NULL,
117 `nc03784` mediumtext,
118 `nc06338` bigint NOT NULL DEFAULT '-92351690',
119 `nc01068` tinytext,
120 `nc08596` mediumtext NOT NULL,
121 `nc02796` tinyint NOT NULL,
122 `nc04875` decimal(10,0) DEFAULT NULL,
123 `nc02799` int NOT NULL,
124 `nc00074` int NOT NULL,
125 `nc03703` decimal(10,0) NOT NULL,
126 `nc06965` tinyint NOT NULL DEFAULT '0',
127 `nc08710` mediumtext NOT NULL,
128 `nc01675` varchar(200) DEFAULT NULL,
129 `nc09917` decimal(10,0) NOT NULL,
130 `nc08148` longblob,
131 `nc01298` longblob,
132 `nc01613` decimal(10,0) DEFAULT NULL,
133 `nc01656` int DEFAULT NULL,
134 `nc08402` char(19) DEFAULT NULL,
135 `nc04340` tinytext,
136 `nc05768` mediumtext,
137 `nc03616` int DEFAULT NULL,
138 `gc00680` point DEFAULT NULL,
139 `nc06802` tinytext,
140 `nc01681` tinytext NOT NULL,
141 `nc00004` double NOT NULL DEFAULT '-110206412.196301',
142 `nc07322` double NOT NULL,
143 `nc05772` bigint DEFAULT NULL,
144 `nc02010` varchar(338) DEFAULT NULL,
145 KEY `d` (`d` DESC),
146 KEY `a` (`a`),
147 KEY `b` (`b`(10),`a`,`d` DESC),
148 KEY `c` (`c`(56),`b`(56) DESC),
149 KEY `b_2` (`b`(5),`c`(10),`a` DESC)
150 ) /*!50100 TABLESPACE `innodb_file_per_table` */
151 ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
152 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=1 ENCRYPTION='N';
153
154 alter table ibstd_02 add column nc09053 blob not null, algorithm=instant;
155 alter table ibstd_02 add column nc03118 mediumtext, algorithm=instant;
156 alter table ibstd_02 add column nc08926 tinytext, algorithm=instant, lock=default;
157 alter table ibstd_02 add column nc09010 double default '73563844.85182579', algorithm=instant;
158 alter table ibstd_02 add column nc07017 decimal not null, algorithm=instant, lock=default;
159 alter table ibstd_02 add column nc07007 tinytext not null, algorithm=instant;
160 alter table ibstd_02 add column nc08086 blob, algorithm=instant;
161
162 select * from ibstd_02;
163
164 drop table ibstd_02;
165
166 --source include/kill_and_restart_mysqld.inc
167
168 # Case 1 : Test create and drop large number of partitions in
169 # system table-space.
170
171 set global innodb_file_per_table = off;
172
173 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
174 PARTITION BY HASH(a) PARTITIONS 1024;
175
176 DROP TABLE t1;
177
178 # Case 2 : Test create, rename and drop large number of partitions in
179 # system table-space.
180
181 set global innodb_file_per_table = off;
182
183 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
184 PARTITION BY HASH(a) PARTITIONS 1024;
185
186 RENAME TABLE t1 TO t2;
187 DROP TABLE t2;
188
189 # Case 3 : Test create, truncate and drop large number of partitions in
190 # system table-space.
191
192 set global innodb_file_per_table = off;
193
194 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
195 PARTITION BY HASH(a) PARTITIONS 1024;
196
197 TRUNCATE TABLE t1;
198 DROP TABLE t1;
199
200 set global innodb_file_per_table = on;
201
202 # Case 4 : Test create and drop max number of partitions in
203 # file per table-space.
204
205 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a)) ENGINE=INNODB
206 PARTITION BY HASH(a) PARTITIONS 1024;
207
208 DROP TABLE t1;
209