Debian Codegraph @

mysql-test/suite/innodb_fts/include/tablespace_location_alter.inc

raw
1 --eval CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT fts_idx(a,b), c INT PRIMARY KEY) $CREATE_TABLE_PARAMS
2 --source suite/innodb/include/show_i_s_tables.inc
3
4 INSERT INTO t1 VALUES
5 ('MySQL Tutorial','DBMS stands for DataBase', 1) ,
6 ('How To Use MySQL Well','After you went through a', 2),
7 ('Optimizing MySQL','In this tutorial we will show', 3);
8
9 INSERT INTO t1 VALUES
10 ('1001 MySQL Tricks','1. Never run mysqld as root', 4),
11 ('MySQL vs. YourSQL','In the following database comparison', 5),
12 ('MySQL Security','When configured properly, MySQL', 6);
13
14 SELECT c FROM t1 WHERE MATCH (a,b)
15 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
16
17 ALTER TABLE t1 ADD UNIQUE INDEX idx1(b(20)), ALGORITHM=INPLACE;
18 --source suite/innodb/include/show_i_s_tables.inc
19
20 SELECT c FROM t1 WHERE MATCH (a,b)
21 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
22
23 --echo # Test with ALGORITHM=COPY and with FTS Index
24 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
25 --source suite/innodb/include/show_i_s_tables.inc
26
27 SELECT pk FROM t1 WHERE MATCH (a,b)
28 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
29
30 --echo # Before drop FTS index
31 --source suite/innodb/include/show_i_s_tables.inc
32
33 --echo # Test with DROP FTS Index & ADD FTS Index
34 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a,b);
35 --source suite/innodb/include/show_i_s_tables.inc
36
37 SELECT pk FROM t1 WHERE MATCH (a,b)
38 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
39
40 DROP TABLE t1;
41
42