Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 --source include/innodb_checksum_algorithm.inc
4
5 call mtr.add_suppression("Operating system error number .* in a file operation.");
6 call mtr.add_suppression("The error means the system cannot find the path specified.");
7 call mtr.add_suppression("File ./test/t1.ibd was not found");
8
9 --disable_query_log
10 call mtr.add_suppression("Table `test`.`t2` contains unrecognizable instant ALTER metadata");
11 call mtr.add_suppression("Index for table 't2' is corrupt; try to repair it");
12 --enable_query_log
13
14 set default_storage_engine=innodb;
15
16 --echo #
17 --echo # MDEV-18295 IMPORT TABLESPACE fails with instant-altered tables
18 --echo #
19
20 create table t2 (x int, z int default 41);
21 alter table t2 discard tablespace;
22
23 create table t1 (x int);
24 insert into t1 values (1);
25 alter table t1 add z int default 42, algorithm instant;
26 select * from t1;
27 flush tables t1 for export;
28 --let $MYSQLD_DATADIR= `select @@datadir`
29 --move_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
30 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
31 unlock tables;
32
33 --echo # The metadata has to be updated to instant ADD COLUMN.
34 alter table t2 import tablespace;
35
36 select * from t2;
37 insert into t2 set x=2;
38 select * from t2;
39
40 alter table t1 discard tablespace;
41 flush tables t2 for export;
42 --move_file $MYSQLD_DATADIR/test/t2.cfg $MYSQLD_DATADIR/test/t1.cfg
43 --copy_file $MYSQLD_DATADIR/test/t2.ibd $MYSQLD_DATADIR/test/t1.ibd
44 unlock tables;
45
46 --echo # Both the metadata and the data file used instant ADD COLUMN.
47 alter table t1 import tablespace;
48 select * from t1;
49
50 drop table t2;
51 create table t2 select * from t1;
52
53 alter table t1 discard tablespace;
54 flush tables t2 for export;
55 --move_file $MYSQLD_DATADIR/test/t2.cfg $MYSQLD_DATADIR/test/t1.cfg
56 --copy_file $MYSQLD_DATADIR/test/t2.ibd $MYSQLD_DATADIR/test/t1.ibd
57 unlock tables;
58 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t1b.cfg
59 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t1b.ibd
60
61 --echo # The instant ADD COLUMN has to be removed from the metadata.
62 alter table t1 import tablespace;
63 select * from t1;
64
65 --echo # Remove metadata for instant DROP COLUMN, then import
66 alter table t1 drop x, add column x int first, algorithm instant;
67 select * from t1;
68 alter table t1 discard tablespace;
69
70 --move_file $MYSQLD_DATADIR/test/t1b.cfg $MYSQLD_DATADIR/test/t1.cfg
71 --move_file $MYSQLD_DATADIR/test/t1b.ibd $MYSQLD_DATADIR/test/t1.ibd
72 alter table t1 import tablespace;
73 select * from t1;
74
75 --echo # Import a data file that contains instant DROP COLUMN metadata
76 alter table t2 drop x;
77 alter table t1 drop x, force;
78 alter table t1 discard tablespace;
79
80 flush tables t2 for export;
81 --move_file $MYSQLD_DATADIR/test/t2.cfg $MYSQLD_DATADIR/test/t1.cfg
82 --copy_file $MYSQLD_DATADIR/test/t2.ibd $MYSQLD_DATADIR/test/t1.ibd
83 unlock tables;
84
85 alter table t1 import tablespace;
86 --source include/restart_mysqld.inc
87 select * from t1;
88 --remove_file $MYSQLD_DATADIR/test/t1.ibd
89
90 drop table t2;
91 drop table t1;
92
93
94 --let $MYSQLD_DATADIR= `SELECT @@datadir`
95
96 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, i1 INT) ENGINE=INNODB;
97
98 CREATE TABLE t2 (id INT PRIMARY KEY AUTO_INCREMENT, i1 INT, i2 INT) ENGINE=INNODB;
99 ALTER TABLE t2 DROP COLUMN i2, ALGORITHM=INSTANT;
100 ALTER TABLE t2 DISCARD TABLESPACE;
101
102 FLUSH TABLE t1 FOR EXPORT;
103
104 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
105 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
106
107 UNLOCK TABLES;
108 ALTER TABLE t2 IMPORT TABLESPACE;
109
110 DROP TABLE t2, t1;
111
112
113 CREATE TABLE t1 (id INT PRIMARY KEY, i2 INT, i1 INT) ENGINE=INNODB;
114
115 INSERT INTO t1 VALUES (1, 1, 1);
116 ALTER TABLE t1 MODIFY COLUMN i2 INT AFTER i1, ALGORITHM=INSTANT;
117
118 CREATE TABLE t2 LIKE t1;
119 ALTER TABLE t2 DISCARD TABLESPACE;
120
121
122 FLUSH TABLE t1 FOR EXPORT;
123
124 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
125 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
126
127 UNLOCK TABLES;
128 ALTER TABLE t2 IMPORT TABLESPACE;
129
130 SELECT * FROM t2;
131
132 DROP TABLE t2, t1;
133
134
135 CREATE TABLE t1 (id INT PRIMARY KEY, i2 INT, i1 INT) ENGINE=INNODB;
136
137 INSERT INTO t1 VALUES (1, 1, 1);
138 ALTER TABLE t1 DROP COLUMN i2, ALGORITHM=INSTANT;
139
140 CREATE TABLE t2 LIKE t1;
141 ALTER TABLE t2 DISCARD TABLESPACE;
142
143
144 FLUSH TABLE t1 FOR EXPORT;
145
146 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
147 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
148
149 UNLOCK TABLES;
150 ALTER TABLE t2 IMPORT TABLESPACE;
151
152 SELECT * FROM t2;
153
154 DROP TABLE t2, t1;
155
156
157 CREATE TABLE t1 (id INT PRIMARY KEY, i2 INT, i1 INT)
158 ENGINE=INNODB PAGE_COMPRESSED=1;
159
160 INSERT INTO t1 VALUES (1, 1, 1);
161 ALTER TABLE t1 DROP COLUMN i2, ALGORITHM=INSTANT;
162
163 CREATE TABLE t2 LIKE t1;
164 ALTER TABLE t2 DISCARD TABLESPACE;
165
166 FLUSH TABLE t1 FOR EXPORT;
167
168 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
169 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
170
171 UNLOCK TABLES;
172 ALTER TABLE t2 IMPORT TABLESPACE;
173
174 DROP TABLE t2, t1;
175
176
177 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, i2 INT, i1 INT) ENGINE=INNODB;
178
179 INSERT INTO t1 (i2) SELECT 4 FROM seq_1_to_1024;
180 ALTER TABLE t1 DROP COLUMN i2, ALGORITHM=INSTANT;
181
182 CREATE TABLE t2 LIKE t1;
183 ALTER TABLE t2 DISCARD TABLESPACE;
184
185 FLUSH TABLE t1 FOR EXPORT;
186
187 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
188 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
189
190 UNLOCK TABLES;
191 ALTER TABLE t2 IMPORT TABLESPACE;
192
193 DROP TABLE t2, t1;
194
195
196 CREATE TABLE t1 ( id INT NOT NULL, i1 INT, i2 INT, PRIMARY KEY (id)) engine=innodb;
197 CREATE TABLE t2 ( id INT NOT NULL, i1 INT, i2 INT, PRIMARY KEY (id)) engine=innodb;
198
199 ALTER TABLE test.t1 add COLUMN i3 INT AFTER i1;
200
201 ALTER TABLE t2 DISCARD TABLESPACE;
202 FLUSH TABLES t1 FOR EXPORT;
203
204 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
205 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
206
207 UNLOCK TABLES;
208 --error ER_NOT_KEYFILE
209 ALTER TABLE t2 IMPORT TABLESPACE;
210
211 DROP TABLE t1, t2;
212
213 --echo #
214 --echo # MDEV-28919 Assertion `(((core_null) + 7) >> 3) ==
215 --echo # oindex.n_core_null_bytes || !not_redundant()' failed
216 --echo #
217 call mtr.add_suppression(" InnoDB: Tablespace for table `test`.`t` is set as discarded");
218 CREATE TABLE t (a INTEGER, b INTEGER as (a) VIRTUAL,
219 c INTEGER)engine=innodb;
220 ALTER TABLE t DISCARD TABLESPACE;
221 FLUSH TABLES;
222 # Table does reload
223 ALTER TABLE t DROP COLUMN b, algorithm=instant;
224 ALTER TABLE t DROP COLUMN c, algorithm=instant;
225
226 CREATE TABLE t1(a INTEGER)ENGINE=InnoDB;
227 INSERT INTO t1 VALUES(1);
228 FLUSH TABLE t1 FOR EXPORT;
229 --let $MYSQLD_DATADIR= `select @@datadir`
230 --move_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t.cfg
231 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t.ibd
232 unlock tables;
233 ALTER TABLE t IMPORT tablespace;
234 check table t;
235 select * from t;
236 DROP TABLE t, t1;