Debian Codegraph @

mysql-test/suite/innodb/r/import_hidden_fts.result

raw
1 SET @save_adaptive=@@GLOBAL.innodb_adaptive_hash_index;
2 SET GLOBAL innodb_adaptive_hash_index=ON;
3 call mtr.add_suppression("InnoDB: Added system generated FTS_DOC_ID and FTS_DOC_ID_INDEX while importing the tablespace");
4 CREATE TABLE t1(f1 INT NOT NULL PRIMARY KEY,
5 f2 CHAR(2) not null, fulltext f_idx(f2),
6 f3 INT as (f1) VIRTUAL, INDEX(f3),
7 f4 INT as (f1) STORED, INDEX(f4),
8 f5 INT as (f1) VIRTUAL)ENGINE=InnoDB;
9 INSERT INTO t1(f1, f2) VALUES(1, "on");
10 INSERT INTO t1(f1, f2) SELECT seq, "si" FROM seq_2_to_256;
11 ALTER TABLE t1 ADD COLUMN f6 INT NOT NULL;
12 ALTER TABLE t1 DROP COLUMN f6;
13 ALTER TABLE t1 DROP INDEX f_idx;
14 connect block_purge,localhost,root,,;
15 START TRANSACTION WITH CONSISTENT SNAPSHOT;
16 connection default;
17 DELETE FROM t1 WHERE f1 > 1;
18 FLUSH TABLE t1 FOR EXPORT;
19 Warnings:
20 Warning 1235 This version of MariaDB doesn't yet support 'FLUSH TABLES on a table that had an FTS index, created on a hidden column, the auxiliary tables haven't been dropped as yet. FTS auxiliary tables will not be flushed.'
21 Warning 1235 This version of MariaDB doesn't yet support 'FLUSH TABLES on a table that had an FTS index, created on a hidden column, the auxiliary tables haven't been dropped as yet. FTS auxiliary tables will not be flushed.'
22 backup: t1
23 UNLOCK TABLES;
24 Warnings:
25 Warning 1235 This version of MariaDB doesn't yet support 'FLUSH TABLES on a table that had an FTS index, created on a hidden column, the auxiliary tables haven't been dropped as yet. FTS auxiliary tables will not be flushed.'
26 DROP TABLE t1;
27 disconnect block_purge;
28 CREATE TABLE t1(f1 INT NOT NULL PRIMARY KEY,
29 f2 CHAR(2) not null,
30 f3 INT as (f1) VIRTUAL, INDEX(f3),
31 f4 INT as (f1) STORED, INDEX(f4),
32 f5 INT as (f1) VIRTUAL)ENGINE=InnoDB;
33 ALTER TABLE t1 DISCARD TABLESPACE;
34 restore: t1 .ibd and .cfg files
35 ALTER TABLE t1 IMPORT TABLESPACE;
36 SHOW CREATE TABLE t1;
37 Table Create Table
38 t1 CREATE TABLE `t1` (
39 `f1` int(11) NOT NULL,
40 `f2` char(2) NOT NULL,
41 `f3` int(11) GENERATED ALWAYS AS (`f1`) VIRTUAL,
42 `f4` int(11) GENERATED ALWAYS AS (`f1`) STORED,
43 `f5` int(11) GENERATED ALWAYS AS (`f1`) VIRTUAL,
44 PRIMARY KEY (`f1`),
45 KEY `f3` (`f3`),
46 KEY `f4` (`f4`)
47 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
48 DROP TABLE t1;
49 SET GLOBAL innodb_adaptive_hash_index=@save_adaptive;